5

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.

japem
  • 1,037
  • 5
  • 16
  • 30
  • 1
    root has most probably a password now :S – Cedric Simon Mar 19 '14 at 00:41
  • This should help: http://dev.mysql.com/doc/refman/5.6/en/resetting-permissions.html –  Mar 19 '14 at 00:44
  • @CedricSimon - A textedit file with the password showed up on my desktop. I tried putting that in as the password (username still root) and it didn't work. – japem Mar 19 '14 at 00:56
  • @japem: A text file with a password in it randomly showed up on your desktop without intervention? Does that seem likely? – Lightness Races in Orbit May 17 '19 at 01:10
  • 1
    Possible duplicate of [MySQL said: Access denied for user 'root'@'localhost' (using password: NO)"](https://stackoverflow.com/questions/48812947/mysql-said-access-denied-for-user-rootlocalhost-using-password-no) – Ken White Sep 14 '19 at 02:09
  • you can refer this https://stackoverflow.com/questions/39281594/error-1698-28000-access-denied-for-user-rootlocalhost – Pavan Nagadiya Jan 13 '20 at 07:38

2 Answers2

0
  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.
Pankaj Gadge
  • 2,748
  • 3
  • 18
  • 25
0

It happened to my in Mac. I went to system preferences -> MySQL -> Stopped the server, started it again, and it worked.

NordinZ
  • 66
  • 2