MySQL 基本操作

创建用户及密码

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'

->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION; 

//本地操作的权限

mysql> GRANT ALL PRIVILEGES ON *.* TO ' root '@'%'

->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

查看 MySql 用户数据字典

mysql.user

查看字符集

show variables like '%collation%';
show variables like '%char%';