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

ASLAN Hi Sir, I try with your way. But I cannot access my db from other hosting. Can you help me? Thanks, May

Can't Access to a MySQL database from external Server

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

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

« Previous Page