mysql忘记登陆密码

修改mysql的配置文件my.cnf

my.cnf配置文件的位置，一般在/etc/my.cnf，有些版本在/etc/mysql/my.cnf

在配置文件中，增加2行代码

[mysqld]

skip-grant-tables

然后启动mysql服务，并进入mysql

[root@b ~]# service mysqld start
[root@b ~]#
[root@b ~]# mysql -u root 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>

 修改密码

连接mysql这个数据库，修改用户密码

mysql> use mysql;
Database changed
mysql> update mysql.user set authentication_string=password('root_password') where user='root';
Query OK, 1 row affected, 1 warning (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 1 mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> \q


使用新密码登陆

[root@b ~]# mysql -u root -p
输入新密码

修改root登陆密码
mysql>ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxx';

mysql> flush privileges; Query OK, 0 rows affected (0.01 sec)
mysql> \q

转载于:https://www.cnblogs.com/xiaofeng666/p/11060614.html