// 创建用户(注意%表示所有Ip都可以连接这台MySql,但连接时也要用这台MySql所在Ip去连接)(其中USAGE表示无权限)
GRANT USAGE ON . TO ‘test’@’%’ IDENTIFIED BY ‘ymPassByMySql_cc84647f4f524a4eb61d7d30d8d6bdb6’ WITH GRANT OPTION;
flush privileges;
// 查询用户表重要字段(看一下)
select Host,User,Password from mysql.user;
// 为用户授权
grant all privileges on testDB.* to test@’%’ identified by ‘ymPassByMySql_cc84647f4f524a4eb61d7d30d8d6bdb6’;
flush privileges;
// 删除用户
delete from mysql.user where User=‘test’ and Host=’%’;
flush privileges;
/第二个例子(root)*************************************/
// 创建用户(注意%表示所有Ip都可以连接这台MySql,但连接时也要用这台MySql所在Ip去连接)
GRANT USAGE ON . TO ‘root’@’%’ IDENTIFIED BY ‘ymPassByMySql_cc84647f4f524a4eb61d7d30d8d6bdb6’ WITH GRANT OPTION;
// 查询用户表重要字段(看一下)
select Host,User,Password from mysql.user;
// 为用户授权
grant all privileges on . to root@’%’ identified by ‘ymPassByMySql_cc84647f4f524a4eb61d7d30d8d6bdb6’;
flush privileges;
// 删除用户
delete from mysql.user where User=‘root’ and Host=’%’;
flush privileges;
常见问题:
创建好了用户后不能登录(是由于空用户导致的->删除即可)
use mysql#选择mysql库
delete from mysql.user where User=’’;#删除账号为空的行
flush privileges;