Mysql update user password9/2/2023 ![]() WHERE User = 'root' AND Host = 'localhost' įinally reload the table grants by: FLUSH PRIVILEGES SET authentication_string = PASSWORD('newPass'), password_expired = 'N' This is a simple update - set which will set new password. Mysqld -init-file=/home/me/mysqlResetRoot.txt &Īnother option to reset the password of your root account is by update statement. Create new text file - /home/user/mysqlResetRoot.txt.Login with the user running the MySQL serviceįor older versions of Ubuntu you can use: sudo /etc/init.d/mysql stop. ![]() Mysqld -init-file=C:\\mysqlResetRoot.txtįor Ubuntu and Linux Mint you can do these steps:
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |