This article mainly introduces the relevant information on the solution to the forgotten mysql password in MAC. Friends in need can refer to the
Solution to the forgotten mysql password in MACMy recent project used MySQL. I had installed one before, but I forgot the password I set at that time, and then I embarked on the bumpy road of changing the password. After searching a lot of information on Baidu and Google, I still found that there are pitfalls for programmers everywhere. So I decided to write a blog covering solutions to forgotten passwords in various situations.
Situation 1: Download the dmg file directly from the mysql official website for installation, forget the password
1.Close the mysql server
sudo /usr/local/mysql/support-files/mysql.server stop
2.Enter the directory
cd /usr/local/mysql/bin
3. Obtain permission
sudo su
4.Restart the server
./mysqld_safe --skip-grant-tables &
5.control + D to exit editing
6.Configure short command
alias mysql=/usr/local/mysql/bin/mysql
7.Enter mysql
Command modemysql
8. Enter the
use mysql
9. Obtain change permissions
flush privileges;
10.Reset Password
set password for 'root'@'localhost'=password('新密码');
Case 2: If you often use home-brew installation to install software, you only need to change the path in the above steps. The default installation directory of mysql is /usr/local/Cellar/mysql/ 5.7.16, just change steps 1, 2, and 6 above /usr/local/mysql to /usr/local/Cellar/mysql/5.7.16
Case 3: In this case This is a rather tricky situation. After downloading mysql, I forgot about it for a long time, and then downloaded another one. I found that the database I downloaded first directly prompted me to enter the password. Then enter the command according to situation 1 or 2 and it cannot be modified successfully. Afterwards, modifying my.cnf (now changed to my-default.cnf) according to the method introduced online did not work. If you unfortunately encounter this situation, please follow the steps below
1. Uninstall mysql
sudo rm /usr/local/mysql sudo rm -rf /usr/local/var/mysql sudo rm -rf /usr/local/mysql* sudo rm -rf /Library/StartupItems/MySQLCOM sudo rm -rf /Library/PreferencePanes/My* vim /etc/hostconfig and removed the line MYSQLCOM=-YES-rm -rf ~/Library/PreferencePanes/My* sudo rm -rf /Library/Receipts/mysql* sudo rm -rf /Library/Receipts/MySQL* sudo rm -rf /var/db/receipts/com.mysql.*
2. Reinstall mysql
3. In this case, if you still You will be prompted to enter your password, just follow the situation 1 or 2 again
The above is the detailed content of Detailed explanation of the sample code for solving the problem of forgotten mysql password in MAC. For more information, please follow other related articles on the PHP Chinese website!