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

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

szone I did, but it doesn't work Port 3306 open ![ https://www.acahol.com/img/firewall.png ]

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

[unknown] Thank you. I will try.

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

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

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

aaPanel_Kern Worked for me. Thanks!

aaPanel_Kern Dear aapanel, I did this two things also I still cannot connect my db. Can you help me? Thanks, May

Can't Access to a MySQL database from external Server

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

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

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?

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?

aaPanel_Kern

Hello, please check the permissions of your remote server database user

Vevioz

aaP_dewaajusbali1

i have seem error i cannot connet database to another server, port 3306 was open, fire wall was opened
but test with tools sqlyog to access database work fine but if a user another server to access database there error "SQLSTATE[HY000] [2002] Connection timed out ". can you help me what wrong in aapanel?
im user aapanel 7.0.17

aaPanel_Kern

Hello, is the problem solved? By default, mysql can only be accessed locally by the server.
If you need access to other servers, please check whether the system firewall and server provider's security group are open to port 3306, whether mysql users are open to specified IP access or everyone's access

aaP_dewaajusbali1

« Previous Page