![]() ![]() | 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |