Mysql密码更改与配置

获取密码

1、 sudo cat /etc/mysql/debian.cnf

2、使用账号与密码登录

3、修改密码

update user set authentication_string=PASSWORD(“这里输入你要改的密码”) where User=‘root’;

update user set plugin=“mysql_native_password”;

flush privileges;

quit ;

4、设置权限

• 添加授权⽤⼾work,密码123,对所有库的所有表有所有权限
  mysql>grant all privileges on . to ‘work’@’%’ identified by ‘123’;
  mysql>flush privileges;
• 添加⽤⼾duty,对dbª库中所有表有查询,更新权限
  mysql>grant select,update on dbª.* to ‘duty’@’%’ identified by ‘123’;
  mysql>flush privileges;

5、重启

sudo /etc/init.d/mysql restart ;