MySQL 新建数据库并分配
2018-02-05 本文已影响0人
运动的布朗
登录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'>;