1、查询users表
#mysql -uroot -p
password
mariadb>show databases;
mariadb>user zabbix;
mariadb>show tables;
mariadb>select * from users;
2、生成一个MD5类型的新密码,新的密码是admin
echo -n admin | openssl md5 (stdin)= 5fce1b3e34b520afeffb37ce08c7cd66
3、更新表数据
mariadb>update users set passwd='5fce1b3e34b520afeffb37ce08c7cd66' where userid = '1';
4、刷新表数据
mariadb>FLUSH PRIVILEGES;