N/APosted on - 05/08/2012
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.
Need Assistance in Updating Forum Passwords
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;
This last method can be use also with PHP, Python or Perl scripting mysql API.
I hope this information helps,