In case that you are trying to change your root password(or other user password without success you can check previous section. So, run:ĪLTER USER IDENTIFIED WITH mysql_native_password BY 'test' įor more information you can check the link in references 1699 SET PASSWORD has no significance for user as authentication plugin does not support it. First changing the plugin and then setting the password won’t work, and it will fall back to auth_socket again. This is a new change since 5.7: If we want to configure a password, we need to change the plugin and set the password at the same time, in the same command. One of the reasons to not be able to connect would be: auth_socket plugin. It's advisable to create another DBA user while playing with these settings. If you remove your root password or set it to null then you may experience problems when you try to connect with root. MySQL problems related to root authentication Not able to connect with root and no password Or removing the root password: ALTER USER IDENTIFIED WITH mysql_native_password BY '' If you can log in to your MySQL server and you wanto to change your password by query you can do it by: ALTER USER IDENTIFIED WITH mysql_native_password BY '123456' Server version: 5.7.23-0ubuntu0.18.04.1 (Ubuntu)Īfter successful login you can select any of the other sections or just remove the root password by: ALTER USER IDENTIFIED WITH mysql_native_password BY '' Īnd restart mysql server by(optional): sudo systemctl stop mysql
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |