Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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: http://dev.mysql.com/downloads/mysql/

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

I downloaded and installed Sequel Pro from here: http://www.sequelpro.com/download

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 127.0.0.1 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 stackoverflow.com 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:

    Host: 127.0.0.1
    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: dev.mysql.com/doc/refman/5.6/en/default-privileges.html (it's in chapter Installing and Upgrading MySQL, section Postinstallation Setup and Testing) – Daniel Beck Oct 2 '12 at 21:04

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .