What should I do if the Alibaba Cloud database cannot connect to phpmyadmin?

Alibaba Cloud database cannot be connectedphpmyadminWhat should I do?

The Alibaba Cloud server configured using the one-click installation web tutorial is quite convenient to use, but occasionally there will be some inexplicable problems, such as being unable to log in to the database, being unable to change the website root directory, etc. Yes, it’s a pity that I don’t understand Linux servers, so if there is any problem, I can only ask others or Baidu for help, which is quite inconvenient. It seems that I need to find some time to learn Linux server.

Record the most common database login problems and solutions encountered since using Alibaba Cloud Server:

Use xftp to operate files on Alibaba Cloud Server, and encounter interruptions when submitting forms. Internet, the form submission failed, and when I tried to submit it again, it prompted a database connection error. At this time, when I accessed phpmyadmin, it prompted a 2002 error. When Baidu found a solution, all I saw was that the configuration file needed to be changed, change '127.0.0.1' Change it to 'localhost' or something like that.

Solution.#2002 Unable to log in to the MySQL server

Copy config.sample.inc.php to config.inc.php

This error occurs, indicating that there is no Connect to the database. Modify the config.inc.php file,

The code is as follows:

Change $cfg['Servers'][$i]['host'] = 'localhost';

Change to $cfg['Servers'][$i]['host'] = '127.0.0.1';

or

Modify php.ini: mysql.default_socket = /tmp /mysql.sock

After imitating the configuration file and modifying it, I found that the problem was still not solved. So I used Alibaba Cloud's snapshot rollback to restore the file to an earlier stage.

After the snapshot is rolled back, Alibaba Cloud returns to an earlier state. After restarting the system and trying to access the URL again, a message appears that the page cannot be opened. At first, Baidu tried for a long time but couldn't find a solution. Finally, when I couldn't figure it out, I asked a friend who knew Linux for help, and I realized that it turned out that the service needed to be restarted after the Alibaba Cloud system was restarted.

Just two lines of code start the Alibaba Cloud service, and then you can visit the website.

The above is the detailed content of What should I do if the Alibaba Cloud database cannot connect to phpmyadmin?. For more information, please follow other related articles on the PHP Chinese website!