mysql数据库更改用户密码和用户授权

分类: 文章 • 2022-09-11 20:02:40

查询用户、密码

1、select host,user,password from mysql.user;

更改密码

2、update mysql.user set password=password("openstack") where user='keystone' and host='localhost';

授权：grant all privileges on zabbix.* to zabbix@localhost identified by '密码';