Can't Access to a MySQL database from external Server

ASLAN

Hey guys
I've just trying my first VPS with aaPanel
Great Job! It's very simple and intuitive

Everything is fine by now, except I can't access to MySQL from other Server (remote access through PHP)
If I use my domain (host.neosmartness.com) I get this error: Network is unreachable
If I use my IP (178.18.248.203) I get this error: Connection refused
(Both the domain and the IP indicated correspond to the VPS with aaPanel.
I'm trying to access to a database from an external Server using PHP)

My Setup

Port 3306 open
![https://www.acahol.com/img/firewall.png]

Bind Address 0.0.0.0
![https://www.acahol.com/img/mysql.png]

and from phpMyAdmin I created a new user and I also added to root user this host
![https://www.acahol.com/img/phpmyadmin.png]

my PHP code is this (work fine using localhost)
![https://www.acahol.com/img/php.png]

I'm using
MySQL 10.4.14-MariaDB
phpMyAdmin 5.0

Did I miss something?
Any help wil be wellcome
Thanks

szone

ASLAN Whitelist the MySQL Port 3306 from Firewall, and it will work. 🙂

ASLAN

szone
I did, but it doesn't work

Port 3306 open
![https://www.acahol.com/img/firewall.png]

szone

ASLAN Install the security firewall plugin and add that 3306 port there. Worked for me that way.

ASLAN

szone
As my originial post shows, security firewall plugin is installed and port 3306 is opened

My problem was that my Source Server (PHP) was rejecting the connection to the Remote Server (MySQL)
All Setup on aaPanel was right (Remote Server)
I made changes on csf (Source Server) and everything works fine now.

Thanks for aaPanel, it is a great tool

wdsonlobo

ASLAN
Hi, I'm having the same problem, could you let me know how you did it?

aaP_swe_mayhtike

ASLAN
Hi Sir,

I try with your way. But I cannot access my db from other hosting.
Can you help me?

Thanks,
May

aaPanel_Kern

wdsonlobo
Hello, you can open the specified database to allow other ip access, and the system firewall (server provider) opens port 3306

ruicarlossantos

aaPanel_Kern Worked for me. Thanks!

aaP_swe_mayhtike

aaPanel_Kern
Dear aapanel,

I did this two things also I still cannot connect my db. Can you help me?

Thanks,
May

aaPanel_Kern

aaP_swe_mayhtike
Hello, is the database on the same server as the website? If so, please configure the database address directly on the website: 127.0.0.1
If not, is the specified IP the IP of the server of the website? Is port 3306 open on the firewall of the server provider?

szone

aaP_swe_mayhtike

You must ensure that ports are open from Server Provider and within the server.

To check whether the port is open from your server provider or within server, you can use this tool:

https://tools.websolxpert.com/port-checker

aaP_swe_mayhtike

aaPanel_Kern
Many Thanks Sir. I will open 3306 on the firewall of the website server provider.

aaP_swe_mayhtike

aaPanel_Kern
I did port open 3306 at website server. and database server also.
But still cannot access database.
$con = mysqli_connect("xxxxxxxx","username","password","dyname");
error message
Warning: mysqli_connect(): (HY000/2002): Connection timed out in /var/www/lis/html/index.php on line 11
Failed to connect to MySQL: Connection timed out

aaPanel_Kern

aaP_swe_mayhtike

curl -kv http://IP:3306

aaP_swe_mayhtike

aaPanel_Kern

What you mean Sir? aaPanel is very simple and helpful for me. Can you guide more?

aaPanel_Kern

aaP_swe_mayhtike
Hello, execute this command on the web server to check if you can connect to the database?
curl -kv http://IP:3306

aaP_swe_mayhtike

aaPanel_Kern
I got this Sir at website server.

aaPanel_Kern

aaP_swe_mayhtike
Hello, replace the ip with your own database server IP

aaP_swe_mayhtike

aaPanel_Kern
Sorry Sir. I got this result. Please check for me.

aaPanel_Kern

aaP_swe_mayhtike
Hello, your server cannot connect to port 3306 of the database. It is recommended to check whether port 3306 is open in the security group of the server provider? Is the system firewall open?

Vevioz

aaPanel_Kern

Error: (1142, "SELECT command denied to user 'xxx'@'194.233.84.11' for table 'user'")

Insufficient user rights!

Where to open it please?