登录MySQL
mysql -u <username> -p <password>
显示数据库
show databases;
创建数据库
create database <database_name>;
分配用户权限
grant all on <database_name.*> to <'username'> identified by <'password'>;
mysql -u <username> -p <password>
show databases;
create database <database_name>;
grant all on <database_name.*> to <'username'> identified by <'password'>;