Title: SQL problems Last modified: August 19, 2016 --- # SQL problems * [aianta03](https://wordpress.org/support/users/aianta03/) * (@aianta03) * [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/) * One of my clients want to have the wordpress directory on his server but does no currently have SQL on it. So I am trying to connect him to my sql server. I have added his IP address as the host for the database (in phpmyadmin not in the wp-config) like it says here: [http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html](http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html) I also added his IP to the bind-address thing. Still I am getting the error saying that the database connection could not be established. Please help Viewing 15 replies - 1 through 15 (of 15 total) * [s_ha_dum](https://wordpress.org/support/users/apljdi/) * (@apljdi) * [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/#post-1194889) * This is an interesting project. * I assume you’ve made it all the way through the instructions, opening the ports and such. Do the tests in step #7 work at all? * [Kailash](https://wordpress.org/support/users/kailash1/) * (@kailash1) * [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/#post-1194942) * Have you installed any firewall on the server where Mysql server is running. If you have installed any firewall, try to add web server’s (where your wordpress files are uploaded) IP in allowed (whitelist). * Also, upload sample PHP-MySQL connection script and check whether you are able to connect or not. * Kailash * Thread Starter [aianta03](https://wordpress.org/support/users/aianta03/) * (@aianta03) * [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/#post-1195004) * I have done all those steps to the best of my ability. You see Those instruction are for linux but I run my SQL Server on a windows using XAMPP * [Brian Harris](https://wordpress.org/support/users/zgani/) * (@zgani) * [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/#post-1195010) * One of WordPress’ requirement is to have MySQL. I don’t believe you can run it on SQL. * [s_ha_dum](https://wordpress.org/support/users/apljdi/) * (@apljdi) * [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/#post-1195011) * Is your SQL server online? This isn’t a locally hosted development server right? * Moderator [cubecolour](https://wordpress.org/support/users/numeeja/) * (@numeeja) * [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/#post-1195019) * PhpMyAdmin needs to connect to the MySQL server not the Web Server where the PHP files reside. * [Kailash](https://wordpress.org/support/users/kailash1/) * (@kailash1) * [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/#post-1195020) * > PhpMyAdmin needs to connect to the MySQL server not the Web Server where the > PHP files reside. * PHPMyAdmin is just an interface to manage MySQL database and you can still manage your mysql database without PHPMyAdmin. But if your wordpress files (web server) can’t connect to your remote MySQL server then your blog will not work. * Did you properly bind your dedicated IP address to your MySQL server in XAMPP? If MySQL server is running and you have assigned proper IP address to MySQL server then you should not face any problem to connect your database remotely. Also, make sure that the port 3306 is not blocked for incoming connection in your system. * Kailash * Thread Starter [aianta03](https://wordpress.org/support/users/aianta03/) * (@aianta03) * [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/#post-1195036) * I have spent the past hour try to see If it will work, I did this by making a wordpress on my server but connecting to an MySQL database on another one of my servers. About 10min ago I just succeed. Buy simply adding my servers internal IP address in the MySQL host field. So it looks like this * Server with files: wp-config.php DB name: test DB username: test DB pass: test DB host XXX.XXX.X.XXX <– MySQL server IP * My SQL server: In “mysql” database and “user” field * DB name:test DB host: XXX.XXX.X.XXX <– IP address of my other server with the files. * So it is possible. now I need to set this up to work externally. I think that has something to do with that 3306 port, but how do I open it to external connections? * Oh and I ment to say MYSQL not SQL sorry bout that * thanks for all the replies * Thread Starter [aianta03](https://wordpress.org/support/users/aianta03/) * (@aianta03) * [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/#post-1195037) * [@apljdi](https://wordpress.org/support/users/apljdi/) It is a locally hosted server yes. But it is up to code and everything. * Thread Starter [aianta03](https://wordpress.org/support/users/aianta03/) * (@aianta03) * [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/#post-1195046) * anymore Ideas? * [s_ha_dum](https://wordpress.org/support/users/apljdi/) * (@apljdi) * [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/#post-1195048) * Is your local server connected to the web via a static IP? * Thread Starter [aianta03](https://wordpress.org/support/users/aianta03/) * (@aianta03) * [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/#post-1195050) * yes * Thread Starter [aianta03](https://wordpress.org/support/users/aianta03/) * (@aianta03) * [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/#post-1195053) * anyone else? any Ideas at all? I will try even very doubtful ideas. I really need a solution * [whooami](https://wordpress.org/support/users/whooami/) * (@whooami) * [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/#post-1195054) * if you really need a solution, why dont you go ask these questions on **the** mysql support forum? Im missing why this is an issue for this forum. you are setting up mysql — you just happen to want to use it for wordpress. * This is where general mysql support questions ought to go: * [http://forums.mysql.com/](http://forums.mysql.com/) * Furthermore, STOP bumping this thread. Read the rules. * [http://wordpress.org/support/topic/68664?replies=6](http://wordpress.org/support/topic/68664?replies=6) * > **“Bumps”. Do not bump posts on this forum. Putting posts at the top doesn’t > help them get noticed here. The volunteers who try to answer questions look > for those without replies first. If you bump a post, then it disappears from > the “no replies” view. DO NOT BUMP.** * Thread Starter [aianta03](https://wordpress.org/support/users/aianta03/) * (@aianta03) * [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/#post-1195056) * [@whooami](https://wordpress.org/support/users/whooami/) Thx for the reply, I put this thread here to see if other wordpress users have done this and know how to help me. Also I wanted to know if wordpress is compatible with this configuration. * Oh and I am not setting up MySQL I am connecting WordPress to it. * P.Sorry about the bump thing. Viewing 15 replies - 1 through 15 (of 15 total) The topic ‘SQL problems’ is closed to new replies. * In: [Installing WordPress](https://wordpress.org/support/forum/installation/) * 15 replies * 6 participants * Last reply from: [aianta03](https://wordpress.org/support/users/aianta03/) * Last activity: [16 years, 9 months ago](https://wordpress.org/support/topic/sql-problems-2/#post-1195056) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics