This forum is no longer active. Please post your questions to our new community site

Forums MAMPStack

#1045 Cannot log in to the MySQL server

Subscribe to #1045 Cannot log in to the MySQL server 4 post(s), 2 voice(s)

 
Avatar steve1hold 2 post(s)

Have installed MAMPStack on OSX 10.6. I get the error ‘#1045 Cannot log in to the MySQL server’
when trying to login from phpMyAdmin using the username ‘administrator’ and the password I gave during installation.

I’ve reinstalled with a different password but same result.

Running this script gives the error ‘Access denied’
/Applications/mampstack-5.3.6-0/mysql/bin/mysqlshow -p

Strangely however the following script does seem to work.

/Applications/mampstack-5.3.6-0/mysql/bin/mysqladmin -p version

Any clues?

 
Avatar Beltrán Rueda Administrator 3,714 post(s)

Hi,

The login is “root” and the password is the same that you set during the installation. You can find more info at http://wiki.bitnami.com/Components/phpMyAdmin_a…

You should also specify the root user in the mysqlshow command: $ mysqlshow -u root -p

I hope it helps.

 
Avatar steve1hold 2 post(s)

Hi, actually that helps quite a lot! I used ‘root’ and everything is OK. It seems I was misled by the info provided on the phpAdminMySQL login page, which tells you to use ‘administrator’. Also the ‘mysqlshow’ command I used was copied directly from the Quick Start Guide, so perhaps this needs revision.

Thanks again :-)

 
Avatar Beltrán Rueda Administrator 3,714 post(s)

Thanks, we are working to improve it.

Forums MAMPStack