[root@izj6c4danzl2zg703g6apoz default]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@izj6c4danzl2zg703g6apoz default]# sudo /usr/local/mysql/support-files/mysql.server stop
Shutting down MySQL. [ 确定 ]
[root@izj6c4danzl2zg703g6apoz default]# cd /usr/local/mysql/bin
[root@izj6c4danzl2zg703g6apoz bin]# sudo su
[root@izj6c4danzl2zg703g6apoz bin]# ./mysqld_safe --skip-grant-tables &
[1] 2690
[root@izj6c4danzl2zg703g6apoz bin]# 190207 14:03:01 mysqld_safe Logging to '/usr/local/mysql/var/izj6c4danzl2zg703g6apoz.err'.
190207 14:03:01 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
[root@izj6c4danzl2zg703g6apoz bin]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 85
Server version: 5.5.48-log Source distribution
Copyright (c) 2000, 2016, 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> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> set password for 'root'@'localhost'=password('abc@123');
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持 码农网
猜你喜欢:- MySQL忘记密码
- [MySQl]MySQL忘记密码
- Mysql用户忘记密码及密码过期问题的处理方法
- MySQL忘记密码了怎么办?
- 一次忘记密码引发的算法思考
- 如何通过Wireshark找回忘记的FTP密码
本站部分资源来源于网络,本站转载出于传递更多信息之目的,版权归原作者或者来源机构所有,如转载稿涉及版权问题,请联系我们。
Head First JavaScript Programming
Eric T. Freeman、Elisabeth Robson / O'Reilly Media / 2014-4-10 / USD 49.99
This brain-friendly guide teaches you everything from JavaScript language fundamentals to advanced topics, including objects, functions, and the browser’s document object model. You won’t just be read......一起来看看 《Head First JavaScript Programming》 这本书的介绍吧!