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%’;