Enter password for user root: Error: Access denied for user 'root''localhost' (using password: NO) I've tried reinstalling it multiple times (deleting all mysql packages, the /var/lib/mysql/ file, and the my.cnf file and reinstalling.
#Mysql access denied for user 'root'@'localhost' (using password yes) mac install#
If you do not have permission, you can modify the readable and writable permission of the file. I was trying to install MySQL 5.6.15 to my computer and got this error: unable to update security settings. rootlocalhost sudo mysqlsecureinstallation Securing the MySQL server deployment. If you also encounter this problem, please first find the directory / usr / local / MySQL / data /, and find the data folder. It’s just strange that I can’t log in (all modes are invalid), and it’s almost impossible to change the password! In the final analysis, this problem is still the problem of wrong password. Many netizens said to modify / etc / my.conf ， I didn’t look for the document. I just can’t log in normally and report the same error. Also, don’t use ‘tcp’ for connecting, ‘socket. Enter that, and set the password in the PMA config to the same value. I’ve tried all kinds of methods, but I can’t solve my problem. Following you should be able to set up a password for root in MySQL. I’ve read a lot of answers from netizens to this question.
bash_ pro file # Open the environment variable settings fileĮnter in the file: export PATH=$:/usr/local/mysql/binĪfter the installation is completed, this error will appear when starting and entering:ĮRROR 1045 (28000): Access denied for user (using password: YES) Pay attention to the setting of environment variables
0 kommentar(er)
