Macos – How to access MySQL with Sequel Pro on Mac OSx

macosMySQLsequel-pro

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!

Best Answer

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.

Related Solutions

Macos – How Do I Reset My Root Password on MySQL on a Mac

Depending on what you're using to run MySQL, you could take a look at the official instructions.

If you're using MAMP or something similar you need to find where mysqladmin is located.

/Applications/MAMP/Library/bin/mysqladmin -u root -p password ’somepassword’

If you are using another installation of mysql, you may be able to find out where it is located with:

$ which mysqladmin

Why has thesql stopped working on localhost and how to fix it

I hate to suggest this, but given the level of detail you've supplied I'm guessing the underlying applications that MAMP is comprised of are nearly foreign to you (at least in terms of how they function at a lower level and how they can be manipulated via configuration, etc.), so I believe your best bet is to totally uninstall and reinstall.

However, if you are willing to start digging and learning, let's focus on MySQL first as it seems to be your larger issue:

Confirm what MySQLd is doing, or any problems it is having, by checking the logs (a good idea to supply that when you're asking questions, so others can help you);
To find the logs and/or what config file MySQLd is using, you'll need to determine how MAMP is calling MySQL - doing a process listing is the quickest way to see this, using ps (not sure of the BSD/OS X method, but something similar to ps -eFw should give you an indication, otherwise check the relevant man page), or using OS X's built-in Activity Monitor (Applications -> Utilities);
If no arguments are given to the MySQL daemon, then it's either a wrapper script (a file /mysql/command/of/process/running should tell you that) which you'll need to dig into to find the commands, or it's being called with default parameters... in which case the command mysqladmin variables should give you an idea of how it's configured;
Since the UNIX versus TCP socket option of MySQL is configurable your final step will be to find the config file (generally my.cnf) and check that the socket definition is in place (similar to socket=/tmp/mysql.sock), and once confirmed you'll need to also check the permissions are good for the user the MySQL daemon is running as.

Keep in mind most of these steps may become irrelevant, depending on the content of the logs. So finding them is of paramount importance. Likely the file already exists or there is a permission issue.

Best Answer

Related Solutions

Macos – How Do I Reset My Root Password on MySQL on a Mac

Why has thesql stopped working on localhost and how to fix it

Related Question