创建mysql用户

mysql> create database diocorns;




mysql> GRANT select,insert,update,delete,create,drop ON diocorns.* TO diocorns@localhost IDENTIFIED BY 'diocorns';




mysql> FLUSH PRIVILEGES;

创建库diocorns，并赋权限

TO  为给本机diocorns用户

ON diocorns.*         为对于diocorns库

BY 'diocorns'         为密码是diocorns

shell看库里的表

/usr/local/mysql/bin/mysql -uuser -ppassword database_name -e "show TABLES"

shell看库里的进程

/usr/local/mysql/bin/mysql -uuser -ppassword database_name -e "show processlist"




看权限

mysql> SHOW PRIVILEGES;

看版本

mysql> select version();


看状态

mysql> status