Method one, directly in the command state to modify
2.1 Version vi/www/wdlinux/wdcp/data/db.inc.php view database user name and password
The code is as follows |
Copy Code |
Mysql-uwdcp-pxxxxxx UPDATE ' wdcpdb ' wd_member ' SET ' passwd ' = MD5 ("Initial password") WHERE ' Wd_member '. ' id ' = 1; 1.1 Version vi/www/web/wdcp/data/wd_sys.php Modify Adm_pass |
The Adm_pass in the Wdcpdb.wd_sys table also needs to be modified consistent
Method Two, phpmadymin modify password
Http://www.example.com:8080/phpmyadmin
Enter the phpMyAdmin login interface, enter your phpMyAdmin username and password into the phpMyAdmin management interface.
To this step, things are simple, the rest is the operation of phpMyAdmin, as long as the Update Wd_member member table specified user passwd field on the line. This should be, right? If not, Baidu/Google will do.
Okay, have you changed it? Easy, huh?
Method three, remote login ssh modify password
The steps are as follows:
Since to remote landing, you must rely on some remote landing tools, Baidu/Google, a big push SSH tool, here recommend the use of PUTTY, its advantages to the official website you know, here will not say more.
To run the PUTTY tool, enter the remote host IP line.
After connecting to the remote host, open the MySQL service and turn on MySQL:
code is as follows |
copy code |
#service MySQL start >mysql-uroot-p Enter Password: Welcome to the MySQL monitor. Commands. Your MySQL Connection ID is 1 Server version:5.6.12-log mysql Community server (GPL) Copyright (c) 2000, 201 3, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark to Oracle Corporation and/or its affiliates. Names may trademarks of their respective owners. Type ' help, ' or ' \h ' for help. Type ' \c ' to clear the current input statement. Mysql> |
See the text information as above, indicating that you have entered MySQL successfully.
Second, you can reset the password by executing the following statement:
To be blunt, to modify the password is to update the password, in fact, is to execute a sentence of SQL, and we usually do when the development of the update SQL statement AH ~
The code is as follows |
Copy Code |
UPDATE ' wd_member ' set ' passwd ' = PASSWORD (' The password you want to set ') WHERE ' NAME ' = ' root '; 1. |
All right, it's finished, and now your WDCP is back to normal.