Solve the problem of being unable to connect due to the AMH panel changing the MYSQL database password

Snail has not paid attention to the information on the AMH panel for a long time, because the later version 5.0 is a paid version. Firstly, I have no purchase experience. Secondly, if there are problems, the official will provide solutions. Thirdly, the free 4.2 version is basically It can also meet basic website building needs. Today, a netizen came to me and said that when he changed the website database password in the PHPMYADMIN panel, he selected the wrong data table and directly changed the password of the ROOT user. This user is the database linked to the AMH panel.

If this password is wrong, it will cause \\"[Amysql-Notice] Access denied for user \\'root\\'@\\'localhost\\' (using password: YES) Mysql link error when we open the panel. Please configure the /Amysql/config.php file. \\" If there is an error message like this, the problem must be solved. This friend is also quite interesting. I asked him to provide ROOT information and I logged in to solve it, but he asked me to describe it to him, because I have never encountered such a problem here, and I don’t have an AMH panel environment. I can only open another test machine and install an AMH panel. Of course, I have to boringly change the ROOT password first, causing the same error as him, and then solve it myself.

Before solving this problem, some users may also need such a process, because the MYSQL database password we set when installing the AMH panel may be too simple. We also hope to reset the database password of a more complex AMH panel. Let’s change the password first.

First, change the AMH panel ROOT user database password

We can solve it directly with commands. If it is troublesome or unfamiliar, log in to the AMH panel first and download the component PHPMYADMIN. After installing it, log in directly with this database panel.

We can see the picture above, find the ROOT user we need to modify, and then edit it. Today, this friend did not want to modify the user information. He wanted to modify a website database, which resulted in a mistake.

Here we can generate a complex password, or set one ourselves and then execute it. In fact, at this time, we can see the error when we open the homepage of the panel, because we still have a configuration file that has not been modified.

Second, modify the AMH panel database configuration file

In the error prompt, we can see that the "Amysql/config.php\\" configuration file needs to be modified. In AMH5.0, we can see the official solution. After all, people are paying. AMH4.2 does not tell where the path is (we did not spend money), so Snail used the find command to search to see where the file is on the server. Then find several files with the same name.

AHM5.0 – /usr/local/amh-5.0/web/Amysql/

AMH4.2 – /home/wwwroot/index/web/Amysql/

Find the config.php file and we need to edit the fields in it.

See the picture above, find the location of the password field, and then modify and replace it. When we open the AMH panel homepage again, there will be no such problem.

In conclusion, through this method we can solve the problem of needing to modify the AMH panel database password. It is not just a matter of simply modifying the ROOT user password. We also need to modify the configuration file, just like the database link file of our website.

Recommended site search: overseas virtual host space, instant solution server, foreign server, ip138 website query, US server rental website, US imitation brand space, domain name agent, ip168, Hong Kong host high defense asp.net host,