Today, a former Chiang Kai-shek helped install the LNMP environment to tell his website not to open, can enter the login interface, but enter the user name and password not to go, here old Chiang to solve this problem, and the whole process of recording down, if you have encountered such a problem can refer to this method to solve the problem.
First, the problem-solving preparatory work
Before encountering the problem, we still check the whole environment whether have the question first, this netizen uses is the Linode VPS server, enters its panel backstage to see the server is the normal stable operation also does not have the alarm reminder. Second, you can log in to the root account smoothly, and at last I login to the phpMyAdmin panel and see that there is no login, and the login entry appears blank.
Second, restart the Web environment check for errors
Here, execute the command reboot LNMP:
The code is as follows |
Copy Code |
LNMP restart
|
Here you can see MySQL with errors (starting MySQL). error! The server quit without updating PID file) seems to have found the problem, so we are ready to go to the corresponding/usr/local/mysql/var/.
Here we can see that the key to probably know the problem, see a lot of hard disk cache files. Speculation should be caused by a full VPS disk. Let's see if this is the case.
Can see sure enough VPS disk full, here we will solve this problem.
Third, solve the problem of LNMP cache full disk
The code is as follows |
Copy Code |
/etc/init.d/mysql restart
|
Here we remove the current few disk-hogging files and then execute the command to restart MySQL, and then we can see that phpmyadmin can see the login entry and can log in. If we need to completely resolve the disk footprint cache problem.
The code is as follows |
Copy Code |
/etc/my.cnf
|
Edit this file, and then find Log-bin=mysql-bin and binlog_format=mixed two lines preceded by a # logout, and then save to restart MySQL to take effect, so that the cache will not be generated later.