Can't connect to MySQL

mysql sequelpro
japem picture japem · Mar 19, 2014 · Viewed 9.5k times · Source

I'm trying to connect to MySQL, using Sequel Pro, something I have done many times before. Host 127.0.0.1, username root, no password. I get the following message:

Unable to connect to host 127.0.0.1 because access was denied.

Double-check your username and password and ensure that access from your current location is permitted.

MySQL said: Access denied for user 'root'@'localhost' (using password: NO)

For what it's worth, I got this message after upgrading to a new Mac OS (Mavericks), realized that the server wasn't running, downloaded a new server (which is currently running), and tried again - but I had the same problem.

Answer

Pankaj Gadge picture Pankaj Gadge · Mar 19, 2014
  1. Make sure you are running MySql in background System Preferences -> Mysql -> Start MySql
  2. Make sure you are able to connect to MySql through command line, if command line works, there is no reason why it should not work in SequelPro.
  3. If problem still persists, try changing the 'root' password.

Related questions

Unable to access MySQL after it automatically generated a temporary password

I have erased and installed OSX 10.11 El Capitan and I have been following through this tutorial to get MySQL up and running on the new OS X. The first step was to download MySQL For Mac OS X 10.9 (x86, 64-bit), …

Read More
Sequel Pro and MySQL connection failed

I just installed mysql on mac from Homebrew brew install mysql mysql -V mysql Ver 8.0.11 for osx10.13 on x86_64 (Homebrew) from terminal it works and I can login to mysql but from Sequel Pro it says Unable to connect to …

Read More
Can't connect to MySQL server on (ip or domain name)

I'm trying to configure a web server (Debian 7). I followed this tutorial. I'm renting my server thanks to gandi.net service. And i have now apache2, mysql, php5 up and running. I connect to it using following command on terminal : …

Read More