1.登录命令
mysql -u root -p
2.创建用户
create user 'test'@'%' identified by 'Test!123';
3.创建数据库
create database testdb default charset=utf8 collate=utf8_bin;
4.为用户授权
grant all on testdb.* to 'test'@'%' ;
5.导入SQL
source xxx.sql;
1.登录命令
mysql -u root -p
2.创建用户
create user 'test'@'%' identified by 'Test!123';
3.创建数据库
create database testdb default charset=utf8 collate=utf8_bin;
4.为用户授权
grant all on testdb.* to 'test'@'%' ;
5.导入SQL
source xxx.sql;