Need Assistance in Updating Forum Passwords

Asked By 20 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #136551

Need Assistance in Updating Forum Passwords

qa-featured

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

 

Login/Register to Answer

Related Questions