MySQL 5 版本使用以下命令:
1、GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘密码’ WITH GRANT OPTION;
MySQL 8 以上将账号添加和权限分开,通过以下操作添加账号和权限:
1、create user ‘zltest’@’%’ identified by ‘zltest’;
2、grant all privileges on . to ‘zltest’@’%’;
3、flush privileges;
以下sql查询:
user mysql;
select user,host from user;