![]() ![]() Applications/MAMP/Library/bin/mysqladmin -socket=/Applications/MAMP/tmp/mysql/mysql.sock shutdown -u root -p You’ll be prompted for the new root password when you press enter. Type the following command to shutdown MAMP’s MySQL server. You should be returned to the Terminal prompt. Then, to quit the MySQL command line type: \q Press enter, then type: FLUSH PRIVILEGES Type the following, replacing NewPassword with the password of your choice: UPDATE er SET Password=PASSWORD('NewPassword') WHERE User='root' You should see the MySQL command line prompt: mysql> mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysqlĪt the prompt type the following command to access the MySQL command line: /Applications/MAMP/Library/bin/mysql When Terminal displays the following message, press enter again to return to the Terminal prompt. Stop the Apache and Mysql using the MAMP UIĬopy and paste the following command into a Terminal window and press enter: /Applications/MAMP/Library/bin/mysqld_safe -skip-grant-tables -skip-networking -socket=/Applications/MAMP/tmp/mysql/mysql.sock -lower_case_table_names=0 -pid-file=/Applications/MAMP/tmp/mysql/mysql.pid & So here is an easy way how to reset your root password. You maybe forgot the root password of your mysql installation, or something went wrong during the installation, or …. Mysql: Reset root password without knowing it (Mac MAMP) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |