mysql cmd 链接方法 导入sql

命令行模式下输入

cd /d D:\Program Files\MySQL\MySQL Server 5.6\bin

然后 D:\Program Files\MySQL\MySQL Server 5.6\bin>mysql -u ibm -p test <d:/dmCountrySi
mplify.sql
Enter password: ****

回车键就等待成功了

添加用户

grant select,insert,update,delete on *.* to ibm@‘%’Identified by “ibm1”;

设置localhost权限

grant all privileges on*.*to ibm@localhostidentified by'ibm1' with grant option;

查看有那些用户及其权限：mysql> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;