All geek questions in one place

Unable to connect to MySQL

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

Could not connect to host 127.0.0.1 because access was denied.

Double check your username and password and make sure access is allowed from your current location.

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

For what it's worth, I received this message after switching to a new Mac OS (Mavericks), I realized that the server was not running, a new server (which is currently working) was loaded, and tried again - but I had the same problem.

+4
source share
1 answer
  • Make sure you use MySql in the background. System Preferences -> Mysql -> Start MySql
  • Make sure you can connect to MySql through the command line if the command line is working, there is no reason why it should not work in SequelPro.
  • If the problem still persists, try changing the "root" password.
0
source

Source: https://habr.com/ru/post/1532389/

More articles:


All Articles