MySQL数据库登录及修改密码
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
#关闭mysql，修改配置文件让mysql允许无密码登录，再重启Mysql
systemctl stop mysqld
#跳过授权表启动MySQL服务程序
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
