![]() You should be able to log in as root now. Check /var/log/mysql/error.log make sure there is no error and the mysqld is successfully startedĮnter the password that you specified in mysql-init. Start mysqld_safe again try step 2 above. ![]() The file permission of mysql-init was not the problem, need to edit apparmor permissionĮdit by #sudo vi /etc/apparmor.d/. The error was in /var/log/mysql/error.log ERROR 1045 (28000): Access denied for user ‘root’’localhost’ (using password: NO) Code Answer’s By Jeff Posted on JIn this article we will learn about some of the frequently asked MySQL programming questions in technical like ERROR 1045 (28000): Access denied for user ‘root’’localhost’ (using password. ![]() ![]() When I tried #sudo mysqld_safe –init-file=/home/me/mysql-init & it failed. In Ubuntu 16.04 (MySQL version 5.7.13) I was able to resolve the problem with the steps below:įollow the instructions from the in section B.5.3.2.2 Resetting the Root Password: Unix and Unix-Like Systems MySQL 5.7 reference manual
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |