Nội dung
In today’s article, AZDIGI will guide you on how to enable the SQL feature on aaPanel remotely.
I. Overview
In many cases, you will need to connect SQL on aaPanel remotely instead of using the phpMyAdmin interface right in the browser. This feature is extremely useful, especially for developers specializing in designing websites, applications… will need a remote SQL connection because of its stability and handy for editing databases, just like you usually use to edit the source code via FTP.
II. How to enable remote SQL on aaPanel
To enable remote SQL on aaPanel, we perform the following 3 steps:
Step 1: Access the aaPanel admin page
To access the aaPanel admin interface, we access the link http://IP:8888 on the browser.
Below is my aaPanel interface:
After accessing the aaPanel admin page, we continue to step 2 to enable remote SQL for any database.
Step 2: Enable remote SQL for a database on aaPanel
At this step, we access the database list at the Databases feature on the left toolbar.
As in the image below, I have 2 databases and I will enable remote SQL for the database named iphime, please select the Permission button at that line.
Then the screen will show 3 options:
- Option 1: Local server – Only allow connections from the aaPanel server.
- Option 2: Everyone – Allow remote connections from all IPs.
- Option 3: Specified IP – Only allow from certain IP addresses, each separated by a comma (,).
Because my devs ask me to turn on this feature, they often work remotely, and their network’s IP address will change constantly. And I need to select the Everyone option so she can always connect.
Then we click Submit to confirm the Permission change. If you want the remote SQL connection between your devs to your server to be encrypted, please enable the SSL option as well, but this will reduce performance because of the encryption and decryption between the two ends.
After enabling remote SQL on aaPanel, let’s try remote to the database just enabled.
I will use Sequel Pro software to connect.
- Host: fill in the aaPanel server IP information.
- Username: enter the username of the database, by default aaPanel Database and Username, will be the same.
- Password: The password of your Username. If you don’t remember, you can choose the eye icon or the copy button next to the password.
- Database: I leave it as Username.
- Port: If your MySQL uses another Port, you can fill in that port, and if you leave it blank by default, Sequel Pro will understand it as 3306.
- Connect using SSL: Remember to tick this box if you enabled Force SSL in the previous paragraph.
After clicking Connect, I got an error that I could not connect to the host, If you can connect, you can skip step 3. Since we can’t connect, we need step 3, which is to open port 3306
Step 3: Open MySQL port 3306 on aaPanel
If you can’t connect as in step 2, it’s because aaPanel’s firewall has not opened port 3306. So to be able to open this port we access the Security feature in the left sidebar.
Next, fill in the information as shown below and select Open.
Please wait a moment you will see that Port 3306 has been added.
Then we can try to connect again with Sequel Pro. And the result is that I have successfully connected.
So we have completed the steps to enable the remote SQL feature on aaPanel.
III. Summary
So through this article, AZDIGI has shown you how to enable the remote SQL feature on aaPanel. If you have done all the steps but still cannot connect, please contact your VPS provider to check if it is being blocked outside your management.
Hope this article will be of help to you. Wishing you success!
See more useful articles about aaPanel at the following link:
If you need assistance, you can contact support in the ways below:
- Hotline 247: 028 888 24768 (Ext 0)
- Ticket/Email: You use the email to register for the service and send it directly to: support@azdigi.com
- Refer to AZDIGI’s Hosting/VPS service here!
