Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am trying to get localhost working on my machine. I am using Mac OSX Snow Leopard. The http://localhost in the browser works, MAMP shows the servers are running all well, and displays the start page.

However, when I try Sequel Pro's 'Socket' tab, with root, root as username and password, it says the username or password are wrong. Badly stuck here, please help!

PS: So what I am trying to do? I am trying to install a local wordpress installation in my localhost folder.

enter image description here

share|improve this question

migrated from wordpress.stackexchange.com Mar 14 '11 at 13:03

This question came from our site for WordPress developers and administrators.

2 Answers 2

First i'd suggest you reference where you got your MAMP build from for local root passwords as they default them to something generally. Also in MySQL you usually have to list a database that you are connecting to (whether you are root or not) for example

mysql -h localhost -u root -p yourpassword yourdatabase

or you can let it prompt you for the PW

mysql -h localhost -u root -p yourdatabase

also if localhost isn't being resolved, you can use 127.0.0.1

I hope this helps you in your endeavor to put up your wordpress!

share|improve this answer
    
MySQL uses a filesystem socket to connect to 'localhost' - and a network socket to connect to 127.0.0.1. In the original post the client is connecting but access is denied - this implies different settings in the mysql.user table for localhost and the row which is matched by 127.0.0.1 (i.e. a network connection) –  symcbean Mar 14 '11 at 13:35

What value did you put in the 'host' field when you try to connect to your database? Did you put in 'localhost'?

When you go to http://localhost does the Wordpress installation page show up? If you go through the Wordpress initialization steps, can it connect to your local database?

You can check that your website is listening on localhost by opening a terminal window and attempting to connect to the socket:

telnet localhost 3306

If that can't connect, your MySQL database isn't running (or is on a non-standard port).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.