一般自己用mysql直接登录的root用户,但是有时候给别人使用时只能给该用户的只读权限
1.登录mysql
mysql -u root -p password
2.创建用户
create user 'username'@'%' identified by 'password';
3.设置密码('root'@'%' 'root'等于user表里的user,'%' 等于user表里的host)
ALTER USER 'root'@'%' IDENTIFIED BY '新密码' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '新密码';
4.赋予权限
grant select on DB_name.* to 'username'@'%'; //只读
5.允许账户远程连接
grant all privileges on *.* to 'username'@'%'
6.刷新权限
flush privileges;