I installed mysql on macbook and workbench get an error:

Your access was failed for the user 'root' @ 'localhost' (using password: NO)

Please:
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check your access to your server from
4 if you need your password for 127.0.0.1

I just created a root connection without a password, since there was no password field, at first I installed a simple workbench and created this root connection without a password, but could not create anything in the database, there was a red line on the left not connections. Then I set the connection community and server running, but now I get an error ...

  • How did you install the MySQL server? Judging by the error with a high probability, it is simply not running. See if it is in the task list via System Monitoring or the ps aux | grep mysqld - cheops
  • Access denied is a MySQL response, so the server is running - retvizan

1 answer 1

if you created root without specifying a host, then by default you have created 'root' @ '%' and you cannot log in from the local machine.

you need to create root @ localhost

if you cannot log into mysql to create a user, then this can be done through skip-grant-tables mode, see MySQL error 1045 for details