默认密码

#查看默认密码
grep "password" /var/log/mysqld.log

#jPcu6%DpYaX6
#jPcu6%DpYaX6

mysql安装后设置_IT

 

登陆

 mysql -u root -p ${password}

需要重置密码才能操作mysql安装后设置_IT_02

 

设置密码等操作

#设置新密码  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;

mysql安装后设置_ide_03