I recently changed the password in MySQL Server. I am not aware that by doing so, the forums would become unauthorized.
I would like to know if there is a way to update the old forum password with the new password I just created.
Thank you.
Good day David.D.eckr,
Â
Inside MySQL database, MySQL stores username and passwords in user table. You can straightly update your root password using the following method to update or change password for user vivek:
1) Login to mysql server and then type the following command at shell prompt:
$ mysql -u root -p
2) Use mysql database (type command at mysql> prompt):
mysql> use mysql;
3) Change password for user vivek, enter:
mysql> update user set password=PASSWORD("NEWPASSWORD") where User='vivek';
4) Finally, restock/reload the privileges:
mysql> flush privileges;
mysql> quit
This last method can be use also with PHP, Python or Perl scripting mysql API.
Â
I hope this information helps,
Mark Amna
Â
