Old left has been a long time did not pay attention to the information on the AMH panel, because the 5.0 version of the beginning is a fee version, one I did not purchase experience, and then there are problems the official will provide solutions, three free version of the 4.2 can basically meet the basic requirements of the construction station. Today, a netizen to me said that in the phpMyAdmin panel to modify the site database password, the data table was wrong, directly to the root user password modification, this user is the AMH panel linked database.
If this password error causes us to open the panel with "[Amysql-notice] Access denied for user ' root ' @ ' localhost ' (using password:yes) MySQL link error, please configure/amysql /config.php files. "Such a hint is wrong, there is a problem to be solved." This friend is interesting, too. I asked him to provide root information. I logged in to solve, but I described to him to operate, because I have not encountered such a problem, and the hands do not have the AMH panel environment, I can only go to open a test machine, and then install a AMH panel, And, of course, it's boring. The root password should be modified to cause the same mistakes as him to solve.
Before solving this problem, perhaps some users also need such a process, because perhaps we install the AMH panel in the MySQL database password is too simple, we also want to reset a complex point of the AMH panel database password, we will first modify the password.
First, modify the AMH panel root user Database password
We can directly use the command to solve, if trouble or unfamiliar, then login to the AMH panel download components phpMyAdmin installed directly with this database panel login.
We can see the image above, find the root user we need to modify, and then edit it. Today, the friend did not want to modify the user information, he wanted to modify a website database, resulting in a mistake.
Here we can generate a complex password, or we set one ourselves and then execute. In fact this time, we open the front page of the panel can see the error, because we still have a configuration file has not been modified.
Second, modify the AMH panel database configuration file
We can see that the "amysql/config.php" profile needs to be modified when the error is prompted. In AMH5.0 we can see the official solution, after all, people are paid, AMH4.2 is not told where the path (we did not spend money), so the old left on the Find command search, see the server where there is this file. And then find a few files with the same name.
| The code is as follows |
Copy Code |
|
AHM5.0-/usr/local/amh-5.0/web/amysql/
AMH4.2-/home/wwwroot/index/web/amysql/
|
Find config.php file We need to edit the fields inside.
See the above figure, locate the password field, and then modify the replacement. We open the AMH panel page again, there is no such problem.
Summing up, through this method we can solve the need to modify the AMH panel database password problem, not simple to modify the root password on it, but also need to modify the configuration file, and our site's database link file the same
