Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

So I am having an issue with trying to figure out how to connect to MySQL to create/edit a database using Sequel Pro on Mac OSX Lion.

I downloaded and installed MySQl from here:

I then added it to preferences pane and made sure the server was Running.

I downloaded and installed Sequel Pro from here:

When I run Sequel Pro it is asking me to use either Standard or Socket connection and is asking me for Host, Username and Password.

I think I want to use as the host, but where/how do I set the username and password in MySQL as it did not ask me for those when I started it up!

share|improve this question

migrated from Oct 2 '12 at 18:10

This question came from our site for professional and enthusiast programmers.

Okay so after a couple of hours of searching, it turns out that the default username is root and the default password is just left blank! I am surprised at how hard it was to find this information. I guess if you come from a MySQL background then maybe you would know this but was not something easily figured out by me!

So for standard MySQL connection in Sequel Pro use:

    Username: root
    Password: *(leave this blank)*

And you should now be able to create and edit a database now.

share|improve this answer
Here's the relevant part of the documentation: (it's in chapter Installing and Upgrading MySQL, section Postinstallation Setup and Testing) – Daniel Beck Oct 2 '12 at 21:04

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.