Mysql Basics

create database dbname;

create database `dbname` CHARACTER SET utf8 COLLATE utf8_general_ci;

create schema some_db default character set utf8mb4;

create user 'user'@'%' identified by 'some_pwd';

grant all privileges on dbname.* to 'user'@'%';
flush privileges;

ALTER USER 'userName'@'%' IDENTIFIED BY 'Newpass';
flush privileges;

select user,host from mysql.user;

show grants for 'some_user'@'%';

GRANT ALL PRIVILEGES ON *.* TO 'some_user'@'%';

GRANT ALL PRIVILEGES ON *.* TO 'some_user'@'localhost';

GRANT PROCESS, SELECT ON *.* TO 'username'@'%';

GRANT SELECT ON database_name.* TO 'username'@'%';

GRANT SELECT ON *.* TO 'username'@'%';

GRANT SELECT ON database_name.table_name TO 'username'@'%';

FLUSH PRIVILEGES;

drop databse some_db;

show processlist;

show variables like "max_connections";

show status where `variable_name` = 'Threads_connected';

set global max_connections = 200;

SHOW VARIABLES LIKE 'max_allowed_packet';

SET GLOBAL max_allowed_packet=16777216;