Geek asks and answers

Reset MySQL default root password is MAMP

I changed my root level password to phpMyAdmin. I did not know where to enter the password myself, because it did not give me the opportunity (login form). I wondered if it was a php.ini file, but users with read privileges could read it if I posted the password there.

Now mysql does not start as I tried to use various online resources to fix the problem. If necessary, I would uninstall mamp and reinstall, but I do not want to lose the database files. Ideally, I would return the default password, which I think was nothing but now I can’t connect to phpmyadmin or the layout start page:

Error: Could not connect to MySQL server!

Any help would be great.

UPDATE -

Error message from mom:

/Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
+5
4

, reset :

/Applications/MAMP/Library/bin/mysqladmin -u root -p password newpassword

mamp faq.

+15

:

  • checkMysql.sh
  • quickCheckMysqlUpgrade.sh
  • repairMysql.sh
  • stopMysql.sh

"quickCheckMysqlUpgrade.sh". /Applications/MAMP/bin/.

-

# /bin/sh
/Applications/MAMP/Library/bin/mysqlcheck --quick --check-upgrade -u root -proot --socket=/Applications/MAMP/tmp/mysql/mysql.sock mysql

-proot, , MAMP , -p {}.

-p "", , , . "-proot" , . "-pmysecret" .

+1

I am annoyed by the "access denied" startup error that MAMP will display, although I was able to access my site using phpMyAdmin or other SQL tools. I even found / updated the password in checkMysql.sh, repairMysql.sh and upgradeMysql.sh. I did not notice a script called quickCheckMysqlUpgrade.sh and fixed the password in which the startup error for me was fixed.

0
source

I just solved this problem on my MBP! In MAMP Pro (v352), go to the MySQL tab and click "Change Password".

0
source

More articles: