Error 'access denied for user 'root'@'localhost' (using password no)' mac

broken image

In order to reduce the number of variables, I've also shutdown apache and deleted my crontab just in case that was part of the problem. It's only the in the error log that is irritating me and that I want to debug. Using the IP address forces the connection to go over TCP instead of a unix socket (a special type of file that lets programs talk to each other). How do I figure the offending config file or server or application that is trying to log in as on startup? What other information can I provide to help to understand and resolve this issue?Īlso, I am able to log in as if I do so explicitly. See if setting the server name to127.0.0.1 instead of localhost does the trick.

broken image

The last line in /var/log/mysql/error.log related to starting the server is: Access denied for user (using password: NO) I keep getting this error: 'Access denied for user 'root''localhost' (using password: YES)' I made the simple mistake of deleting all users from my database while trying to reset users for setting up WordPress locally.

broken image

Mysqladmin Ver 8.42 Distrib 5.7.16, for Linux on x86_64Ĭlearly something is trying to log into my mysql server as root upon service mysql start I was trying to install MySQL 5.6.15 to my computer and got this error: unable to update security settings.