Need Assistance in Updating Forum Passwords

Asked By David.D.eckr 20 points N/A Posted 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.

Thank you.

• Status: Open
• Question Views: 719
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Mark Amna 5 points N/A #136551

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;

mysql> quit

This last method can be use also with PHP, Python or Perl scripting mysql API.

 

I hope this information helps,

Mark Amna

 

About Mark Amna

Questions
0

Answers
90

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 05/17/2012
• Question Category: MySQL Server