centos 7 安装查看并修改密码的命令操作方式

cat /var/log/mysqld.log

mysql -u root -p

ALTER USER USER() IDENTIFIED BY '密码';

use mysql;
select user,host,plugin,authentication_string from mysql.user;
select user,host,plugin from mysql.user;

update mysql.user set host='%' where user='root';
flush privileges;

create user 'test'@'%' identified by '账号';

grant all privileges on testdb.* to 'test'@'%';
flush privileges;

grant select on testdb.* to 'test'@'%';
flush privileges;

grant insert,delete,update on testdb.* to 'test'@'%';
flush privileges;

show grants for 'test'@'%';