Then for reload your server to put your new changes into effect run this FLUSH PRIVILEGES In the table that is in the above, you can see that all of your mysql users accounts status & if you have set a password for root account before you see mysql_native_password in plugin column instead auth_socket.Īll in all for change your root password you should run : ALTER USER IDENTIFIED WITH mysql_native_password BY 'password' īe sure to change password to a strong password of your choosing. | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | | ssion | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | | user | authentication_string | plugin | host | Now you can see something like this already : +-+-+-+-+ If you do NOT know the root password, refer to this Ubuntu-centric write up on the process.Īnd then you should check which authentication method of your MySQL user accounts use.So run this command SELECT user,authentication_string,plugin,host FROM er This will ask you a series of questions about securing your installation (highly recommended), including if you want to provide a new root password. If you know the password, login and run this: UPDATE er SET authentication_string=PASSWORD('my-new-password') WHERE USER='root' Īlternatively, you can use the following: sudo mysql_secure_installation Note that if you are using mysql-server-5.7 you can not use the easier dpkg-reconfigure method shown above. If you are not sure which mysql-server version is installed you can try: dpkg -get-selections | grep mysql-server If you are on 10.04: sudo dpkg-reconfigure mysql-server-5.1 The official and easy way to reset the root password on an ubuntu server.
0 Comments
Leave a Reply. |