MySQL数据库登录及修改密码
mysql rpm包安装后的默认密码
grep 'temporary password' /var/log/mysqld.log
1 登录
mysql -h127.0.0.1 -P3308 -uroot -p
2 修改密码
set password for root@localhost='123456';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY "123456";
flush privileges;
3 修改密码安全等级
set global validate_password_policy=0;
set global validate_password_length=1;
4 忘记密码时登录mysql
systemctl stop mysqld
vim /etc/my.cnf
...
[mysqld]
skip_grant_tables=1
...
systemctl start mysqld
直接输入mysql 登录
update mysql.user set authentication_string=password('123456') where user='root' and host='localhost';
FLUSH PRIVILEGES;
exit