Forums / Installing on a Mac Server / MAMP - MySQL access denied

MAMP - MySQL access denied

Locked

Started by noruga on 2 May 2009, 7:47 PM · Views: 6,990

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
2 May 2009, 7:47 PM
#1
noruga avatar

noruga

New Zenner

Join Date:
May 2009
Posts:
31
Plugin Contributions:
0

MAMP - MySQL access denied

Hello everyone,

I have downloaded MAMP, downloaded the Zen Cart files, changed the name and put them in the MAMP htdocs file.
I have changed the Apache route to 80.
I can view my Zen Cart admin page and front end page.
But in MAMP I get the following message:

"Error: Could not connect to MySQL server!"

In PHPAdmin it looks like this:

"phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server."

Have struggled with this for quite some time now. Anyone who can help?

26 Oct 2009, 8:26 PM
#2
peytonrm avatar

peytonrm

New Zenner

Join Date:
Jun 2008
Location:
Morrisville, NC
Posts:
47
Plugin Contributions:
0

Re: MAMP - MySQL access denied

Sounds like a simple case of a wrong password/username. Did you change the mysql root password when you installed MAMP? My guess would be you changed the password during initial setup and are trying to use the default password. Or maybe you didn't change the default password and are trying to use the password from your production install? Also be sure you are using the username "root" unless you created other users.

"Whether you think you can or think you can't, you're right" - Henry Ford

16 Nov 2009, 5:20 AM
#3
rojertwose avatar

rojertwose

New Zenner

Join Date:
Nov 2009
Posts:
3
Plugin Contributions:
0

Re: MAMP - MySQL access denied

Hello,

I am trying to create a new database with the mysqladmin command in MAMP. I am in the terminal and I have navigated to

/Applications/MAMP/bin/mysql4/bin

and then I hit

sudo ./mysqladmin create databasename

and I get this message

error: 'Access denied for user: 'xxxxxxx@localhost' (Using password: NO)'

Is there something I can do to fix this?

Thanks in advance!

16 Nov 2009, 6:34 AM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: MAMP - MySQL access denied

You'll need to supply the correct MySQL username and password. Look up the correct syntax for command line parameters for mysqladmin.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.