for this kind of error; you just have to set new password to the root user as an admin. follow the steps as follows: [root ~]# mysql -u root ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password:NO) Stop the service/daemon of mysql running [root ~]# service mysql stop mysql stop/waiting Start mysql without … Read more
You need to set the password for root@localhost to be blank. There are two ways: The MySQL SET PASSWORD command: SET PASSWORD FOR root@localhost=PASSWORD(”); — MySQL 5.x SET PASSWORD FOR root@localhost=””; — MySQL 8.x Using the command-line mysqladmin tool: mysqladmin -u root -pType_in_your_current_password_here password ”
I think one can end up in this position with older versions of mysql already installed. I had the same problem and none of the above solutions worked for me. I fixed it thus: Used brew’s remove & cleanup commands, unloaded the launchctl script, then deleted the mysql directory in /usr/local/var, deleted my existing /etc/my.cnf … Read more