Password initialization for MySQL on Mac

Password initialization for MySQL on Mac

Simple records of database startup problems when I operate databases on Mac

1. Apple-> system preference settings-> at the bottom of the page, click mysql to close the mysql service on the pop-up page (Click stop mysql server)

2. Enter the terminal:Cd/usr/local/mysql/bin/

Press enter and log on to the Administrator sudo su.

Press enter and enter the following command to disable mysql verification./mysqld_safe -- skip-grant-tables &

After you press enter, mysql will automatically restart (mysql in preference settings will change to running)

3. Enter the command./Mysql

Press enter and enter the commandFlush privileges;

Press enter and enter the commandSet password for 'root' @ 'localhost' = PASSWORD ('your new password ');

The above is a small Editor to introduce you to the MySQL initialization password operation under the Mac, I hope to help you, if you have any questions, please leave a message, the small editor will reply to you in a timely manner. Thank you very much for your support for the help House website!