Shulou(Shulou.com)06/01 Report--

This article is about how the pagoda panel can't connect to the database remotely. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Ready to build their own website, take advantage of the 618 discount to buy a linux server, the configuration is generally appropriate price. Because I don't know much about the server, I chose to use the graphical interface panel to manage, because I learned about the pagoda panel through Aliyun before, so I installed the pagoda linux panel on the server.

After the relevant environment configuration in the pagoda, the website program is installed, and there is also a problem when installing the program, and the solution will be explained later. Because my django is still in the learning stage, I chose the zblog program that I was familiar with before to build, because I am going to build a website in many aspects, and the website I built at this time is ready to do traffic stations, which mainly depends on the crawler to collect and store the database to update the website, which also saves time.

Because I am not used to phpmyadmin, I use Navicat locally to connect to the database remotely, but there are various problems when connecting to the database. Because when logging in from the pagoda backend, the login port of the pagoda's phpmyadmin is 888. then the login port is changed to 888. later, when you try to log in, the password of the database account is correct, but the error message indicates that you cannot log in. Don't be confused by the login port 888 of phpmyadmin, this is only the port to log in to phpmyadmin to enter the database, not the port of MySQL, the port of MySQL is still 3306, at this time change the port in Navicat to 3306.

But it's not over here, and there are two more steps to set up:

Step 1: as shown in the figure, you need to modify permissions from the database, and the condition is changed to allow everyone or your computer to IP (specify IP).

Step 2: select "Security", set the release port, fill in 3306 in the first corresponding position, write your own notes later, and then click the "release" button, or you can specify a range, such as 3000Rom 3500.

After the above operations are completed, it is best to restart MySQL on the home page, then go back to Navicat, enter relevant configuration information, and the connection test will be successful.

This method may not be solved for all situations, this article only focuses on whether the port is released or not. There may be MySQL database that does not give root account permission, please go to MySQL database for authorization.

# authorize root users to operate on all databases in any ip grant all on *. * to root@'%' identified by '123456' with grant option;# refresh database flush privileges; thank you for reading! This is the end of the article on "what to do if the pagoda panel cannot connect to the database remotely". I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.