默认密码
#查看默认密码
grep "password" /var/log/mysqld.log
#jPcu6%DpYaX6
#jPcu6%DpYaX6
登陆
mysql -u root -p ${password}
需要重置密码才能操作
设置密码等操作
#设置新密码 Root@123456是密码
alter user 'root'@'localhost' identified by 'Root@123456';
#刷新权限
flush privileges;
# Root@123456是密码
CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123456';
set global validate_password_policy=0;
grant all on *.* to 'root'@'%' identified by 'Root@123456' with grant option;
#切换到msyql库
use mysql;
#看用户表
select host,user,authentication_string from user;