MySQL数据库新建用户并赋予权限

首先使用root权限登录mysql，切换到mysql数据库，
create user “test”@“localhost” indentified by ‘123456’ ;
grant all on 数据库名.* TO ‘test’@‘localhost’;
flush privileges;
create user “test”@"%" indentified by ‘123456’ ;
grant select on 数据库名.* TO ‘test’@’%’;
flush privileges;
本地连接：cmd命令行中直接输入 MySQL -u test -p 回车后输入密码，即可登录成功
远程连接：mysql -h 166.16.6 -P 3306 -u test -p 123456