Using remote MySql from ISPConfig server
I updated my ISPConfig to the last version 22.214.171.124
I created a client with his respective database. The database has in the Remote Access IPs textfield the IP of an external hosting.
The idea is using this mysql database in another external hosting to manage a forum.
The problem is that I'm not abble to use in my external hosting the mysql server (provided by the ISPConfig).
I filled up all the parameters in the config.php in my forum with the IP, user and password info.
When I try to acces to the forum it doesn't work. My Internet browsers says "The connection has been reset".
What I'm doing wrong?
It is possible to use the mysql server in another server? They are in separate networks.
I realized a simple test with another external hosting trying to obtain simple records from my mysql server.
I finished all the lines which try to conect to DB with the function "or die (mysql_errno());"
The result when I go to test.php is:
Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /XXXX/test.php on line 10
Lost connection to MySQL server at 'reading initial communication packet', system error: 111
In the line 10 there's the 1st sentence connection:
mysql_connect($dbhost,$dbuser,$dbpasswd) or die (mysql_errno());
I have to say the external hosting is not a slave of the mysql server. I mean, I have just ISPConfig in the mysql server. The other hosting is a VPS so I can't install anything else.
The forum is running in the VPS. As traffic has increase I need a powerful mysql server to respond all the user petitions. So I chose a dedicated server running the ISPConfig just to bring the DB.
Should I configure something else in the ISPConfig to be able to acces to its mysql from another server which is outside its network?
Have you configured mysql to allow connections from other hosts in my.cnf file and did you open the mysql port in the firewall if you use one? Please post the output of:
netstat -tap | grep mysql
and also the output of:
I read out about commenting the bind line. I did it. I restarted the mysql server (after creating a new password for the root user).
With that, the currenlty nestat result is:
But I'm still getting an error when I try to access to the test.php:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'XXXX'@'XXXX.com' (using password: YES) in /X/test.php on line 10
Access denied for user 'XXXX'@'XXXX.com' (using password: YES)
I use the correct user/password.
Is that messages only a credentials error or a misconfiguration of the mysql/web server?
Try to use the IP address to connect to the server instead of using the hostname.
|All times are GMT +2. The time now is 06:19.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.