mysql学习之-密码管理（默认密码，修改密码，解决忘记密码）

比眉伴天荒 2022-01-09 07:17 342阅读 0赞

1. mysql安装后默认没有密码，初始化安装后默认密码登录，需要马上修改root密码。  
\[root@mysql ~\]\# cat /root/.mysql\_secret --查看root账号密码  
\# The random password set for the root user at Tue Dec 13 18:59:06 2016 (local time): 7MhtyX3aZEl9OUf8  
\[root@mysql ~\]\# mysql -uroot -p -- 登录mysql  
Enter password: --（此处复制粘贴 7MhtyX3aZEl9OUf8）  
Welcome to the MySQL monitor. Commands end with ; or \\g.  
Your MySQL connection id is 2  
Server version: 5.6.25  
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.  
Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.  
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.  
说明： 出现mysql> 表示一切顺利成功。  
  
2. 修改密码  
mysql> SET PASSWORD = PASSWORD('123456'); --设置密码为123456  
\[root@mysql etc\]\# mysql -uroot -p123456 --修改密码后，登录  
Warning: Using a password on the command line interface can be insecure.  
Welcome to the MySQL monitor. Commands end with ; or \\g.  
Your MySQL connection id is 39  
Server version: 5.6.25 MySQL Community Server (GPL)  
mysql> --登录成功  
  
3. 忘记mysql数据库root的密码后，如何修改密码。  
\[root@mysql etc\]\# service mysql stop --停止mysql进程  
Shutting down MySQL.... SUCCESS!  
\[root@mysql etc\]\# mysqld\_safe --skip-grant-tables& --启动mysql时不启动grant-tables，授权表。执行后出现下面画面，另起一个新会话。  
\[1\] 3574  
\[root@mysql etc\]\# 161215 06:13:53 mysqld\_safe Logging to '/var/lib/mysql/mysql.err'.  
161215 06:13:53 mysqld\_safe Starting mysqld daemon with databases from /var/lib/mysql  
\[root@mysql ~\]\# ps -ef|grep mysql --查看mysql进程是否起来  
root 3467 3440 0 05:29 pts/2 00:00:00 mysql -uandy -px xx  
root 3574 2845 0 06:13 pts/0 00:00:00 /bin/sh /usr/bin/mysqld\_safe --skip-grant-tables  
mysql 3677 3574 2 06:13 pts/0 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-  
mysql> UPDATE user SET password=PASSWORD('cccccc') WHERE user='root'; --更改root密码  
Query OK, 4 rows affected (0.04 sec)  
Rows matched: 4 Changed: 4 Warnings: 0  
mysql> FLUSH PRIVILEGES; --权限更新  
Query OK, 0 rows affected (0.00 sec)  
\[root@mysql ~\]\# mysql -uroot -p123456 --使用旧密码登录，发现不行，说明密码已经更新  
Warning: Using a password on the command line interface can be insecure.  
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)  
\[root@mysql ~\]\# mysql -uroot -pcccccc --新密码登录成功  
Warning: Using a password on the command line interface can be insecure.  
Welcome to the MySQL monitor. Commands end with ; or \\g.  
mysql>

转载于:https://www.cnblogs.com/andy6/p/6181401.html