Solution to the problem that the server cannot remotely connect to the database when installing the Pagoda Panel

I am planning to build my own website, so I took advantage of the 618 promotion and bought a Linux server from Tencent Cloud. The configuration is generally good and the price is reasonable. Because I don’t know much about servers, I chose to use a graphical interface panel for management. Because I learned about the Baota panel through Alibaba Cloud before, I installed the Baota Linux panel on the server.

After configuring the relevant environment in Baota, I installed the website program. I encountered problems when installing the program. I will post an article to explain the solution later. Because I am still in the learning stage of Django, I chose the zblog program that I was familiar with before to build it. Because I am preparing to build websites in multiple aspects, the website I build at this time is intended to be a traffic site, and the website is mainly updated by crawlers to collect and store data, which also saves time.

Because I am not very familiar with phpmyadmin, I used Navicat locally to connect to the database remotely, but various problems occurred when connecting to the database. Because when logging in from the Baota backend, you enter the database directly. The login port of Baota's phpmyadmin is 888, and then you change the port to 888 when logging in. Later, when you try to log in, the database account and password are correct, but an error message appears and you cannot log in. Don’t be confused by the login port 888 of phpmyadmin. This is just the port for logging into phpmyadmin and entering the database, not the MySQL port. The MySQL port is still 3306. At this time, just change the port in Navicat to 3306.

But it doesn't end here, there are two more steps to set up:

Step 1: As shown in the figure, you need to modify the permissions from the database and change the conditions to allow everyone or your computer's local IP (specified IP);

Step 2: Select "Security", set the release port, fill in 3306 in the first corresponding position, write your own notes, and then click the "Release" button. You can also specify a range, such as 3000:3500.

After completing the above operations, it is best to return to the homepage and restart MySQL, then return to Navicat, enter the relevant configuration information, and the connection test will be successful.

This method may not be applicable to all situations. This article only checks whether the port is allowed. The MySQL database may not give the root account permissions. Please enter the MySQL database authorization.

# Authorize the root user to operate all databases on any IP address grant all on *.* to root@'%' identified by '123456' with grant option;
# Refresh database flush privileges;

This concludes this article on how to solve the problem that the Baota Panel cannot remotely connect to the database when it is installed on the server. For more information about the problem that the Baota Panel cannot remotely connect to the database, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope you will support 123WORDPRESS.COM in the future!