Detailed explanation of MySQL initialization password operation under Mac

A simple record of the database startup problems encountered by individuals operating databases on Mac. Next, through this article, I will introduce you to the MySQL initialization password operation under Mac. Friends who need it can refer to

A simple record of database startup problems encountered by individuals operating databases on Mac

1. Apple -> System Preferences -> Click mysql at the bottom and close the mysql service in the pop-up page (click stop mysql server)

2. Enter the terminal and enter ：cd /usr/local/mysql/bin/

After pressing Enter, log in with administrator rights sudo su

After pressing Enter, enter the following command to disable the mysql verification function. /mysqld_safe --skip-grant-tables &

After pressing Enter, mysql will automatically restart (the status of mysql in the preferences will change to running)

3. Enter Command./mysql

After pressing Enter, enter the command<a href="http://www.php.cn/wiki/563.html" target="_blank">FLUSH</a> PRIVILEGES;

After pressing Enter, enter the command<a href="http://www.php.cn/code/8209.html" target="_blank">SET</a> PASSW<a href="http://www.php.cn/wiki/1360.html" target="_blank">ORD</a> <a href="http://www.php.cn/wiki/125.html" target="_blank">FOR</a> 'root'@'localhost' = PASSWORD('your new password');

The above is the detailed content of Detailed explanation of MySQL initialization password operation under Mac. For more information, please follow other related articles on the PHP Chinese website!