登录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'>;
本文标题:MySQL 新建数据库并分配
本文链接:https://www.haomeiwen.com/subject/ewoizxtx.html
网友评论