![]() ![]() login to MySQL database with - sudo mysql -u root.Once you lost access to the MySQL database or simply you never have it in order to access to this data base you need to do: Solution for Access denied for user Open terminal on the machine where data base is - CTRL + ALT + T In this article we will do only one which is the one I'm using most. ![]() In the article you can find several solutions about the problem and some general tips at the end. You can find more information on this link: MySQL 8 set or reset user password or the resources below. Even if you were able to login in the past and had access to the local MySQL database this problem might happen in future - if your current password is weak, not set or some system changes. There is a security change since MySQL 5.7 which is causing the errors above. MySQL 8 Access denied for user denied for user (using password: YES)Īccess denied for user (using password: NO) Quick solution for MySQL 8 (and MySQL 5.7) error:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |