Title: Error connecting remote DB Last modified: December 4, 2017 --- # Error connecting remote DB * [Cesare Rossi](https://wordpress.org/support/users/back2future/) * (@back2future) * [8 years, 5 months ago](https://wordpress.org/support/topic/error-connecting-remote-db/) * Hi, * I need to configure WordPress on two servers: one web server and one db server. * Accessing remote db with WordPress is getting my crazy: I always receive “Error establishing a database connection” * I’ve configured and installed all the stuff (LAMP on web server, MySQL on db server). I’ve disabled firewall on both servers. * web server on 10.15.63.82 (centos6), db server on 10.15.6.83 (centosdb). * Permissions for “xxxx” on “wordpress” db: * +———————————————————————————————————————–+ | Grants for xxx@% | +———————————————————————————————————————– + | GRANT ALL PRIVILEGES ON *.* TO ‘xxx’@’%’ IDENTIFIED BY PASSWORD ‘*xxx’ | | GRANT ALL PRIVILEGES ON wordpress.* TO ‘wordpressuser’@’%’ | +———————————————————————————————————————– + * Connecting from web server to db server with mysql works fine: * [root@centos6 ~]# mysql -u wordpressuser -p -h 10.15.63.83 Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 17 Server version: 5.1.73 Source distribution * Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. * Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. * Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement. * mysql> show grants; +———————————————————————————————————————–+ | Grants for wordpressuser@% | +———————————————————————————————————————–+ | GRANT ALL PRIVILEGES ON *.* TO ‘xxx’@’%’ IDENTIFIED BY PASSWORD ‘*xxxx’ | | GRANT ALL PRIVILEGES ON wordpress.* TO ‘wordpressuser’@’%’ | +———————————————————————————————————————– + * Checking connections from db server: * mysql> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST; +—-+—————+—————+———–+——— +——+———–+———————————————-+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | +—-+—————+—————+———–+———+——+———–+———————————————-+ | 5 | root | localhost | NULL | Query | 0 | executing | SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST | | 3 | xxx | centos6:57212 | wordpress | Sleep | 160 | | NULL | +—-+—————+————— +———–+———+——+———–+———————————————-+ * Always receive “Error establishing a database connection”: no way to solve it. * I’ve changed permissions on /var/ to 777 🙁, changed /var/www/html/wp-config. php to: * // ** MySQL settings – You can get this info from your web host ** // /** The name of the database for WordPress */ define(‘DB_NAME’, ‘wordpress’); * /** MySQL database username */ define(‘DB_USER’, ‘xxx’); * /** MySQL database password */ define(‘DB_PASSWORD’, ‘xxx!’); * /** MySQL hostname */ define(‘DB_HOST’, ’10.xx.xx.xx’); * **[moderator note: I don’t know if you posted real credentials or not, but I XXX’d them anyway.]** - This topic was modified 8 years, 5 months ago by [Cesare Rossi](https://wordpress.org/support/users/back2future/). - This topic was modified 8 years, 5 months ago by [Cesare Rossi](https://wordpress.org/support/users/back2future/). - This topic was modified 8 years, 5 months ago by [Cesare Rossi](https://wordpress.org/support/users/back2future/). - This topic was modified 8 years, 5 months ago by [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/). - This topic was modified 8 years, 5 months ago by [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/). Viewing 7 replies - 1 through 7 (of 7 total) * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [8 years, 5 months ago](https://wordpress.org/support/topic/error-connecting-remote-db/#post-9745713) * Just for fun… give the DB server a name in your local hosts file (e.g, dbserver. local) and use that in place of the IP address. It *shouldn’t* make a difference, but who knows? * If that fixes it, then let us know and we can file a ticket with the core team. * Thread Starter [Cesare Rossi](https://wordpress.org/support/users/back2future/) * (@back2future) * [8 years, 5 months ago](https://wordpress.org/support/topic/error-connecting-remote-db/#post-9747223) * Steve, * thank You for your answer. * In both the servers the hosts file contains the definition for both server names: * 10.15.63.82 centos6 centos6.ross.lan 10.15.63.83 centosdb centosdb.ross.lan * I’ve tried to assign permissions to the DB on: hostname (short), hostname (FQDN), IP address for root & wordpressuser * ____________________________________________________ * #!/bin/bash * dbadmin=root dbadminpassword=VMware1! dbaddress=centosdb.ross.lan wpdbname=wordpress wpuser=wordpressuser wppassword=VMware1! wpaddress=centos6.ross.lan wpaddressshort =centos6 wpaddressip=10.15.63.82 * /sbin/chkconfig iptables off /sbin/chkconfig ip6tables off /sbin/service iptables stop /sbin/service ip6tables stop * /usr/bin/yum install mysql mysql-server -y /sbin/chkconfig mysqld on /sbin/service mysqld start * /usr/bin/mysql -e “UPDATE mysql.user SET Password=PASSWORD(‘$dbadminpassword’) WHERE User=’$dbadmin’;” /usr/bin/mysql -e “DELETE FROM mysql.user WHERE User =”;” /usr/bin/mysql -e “DROP DATABASE test;” /usr/bin/mysql -e “FLUSH PRIVILEGES;” * /usr/bin/mysql -e “CREATE DATABASE $wpdbname;” –user=$dbadmin –password=$dbadminpassword * /usr/bin/mysql -e “CREATE USER ‘$dbadmin’@’$wpaddress’;” –user=$dbadmin –password =$dbadminpassword /usr/bin/mysql -e “SET PASSWORD FOR ‘$dbadmin’@’$wpaddress’ =PASSWORD(‘$dbadminpassword’);” –user=$dbadmin –password=$dbadminpassword /usr/ bin/mysql -e “GRANT ALL PRIVILEGES ON *.* TO ‘$dbadmin’@’$wpaddress’ IDENTIFIED BY ‘$dbadminpassword’;” –user=$dbadmin –password=$dbadminpassword /usr/bin/mysql- e “GRANT ALL ON *.* TO ‘$dbadmin’@’$wpaddress’ IDENTIFIED BY ‘$dbadminpassword’;”– user=$dbadmin –password=$dbadminpassword * /usr/bin/mysql -e “CREATE USER ‘$dbadmin’@’$wpaddressshort’;” –user=$dbadmin – password=$dbadminpassword /usr/bin/mysql -e “SET PASSWORD FOR ‘$dbadmin’@’$wpaddressshort’ =PASSWORD(‘$dbadminpassword’);” –user=$dbadmin –password=$dbadminpassword /usr/ bin/mysql -e “GRANT ALL PRIVILEGES ON *.* TO ‘$dbadmin’@’$wpaddressshort’ IDENTIFIED BY ‘$dbadminpassword’;” –user=$dbadmin –password=$dbadminpassword /usr/bin/mysql- e “GRANT ALL ON *.* TO ‘$dbadmin’@’$wpaddressshort’ IDENTIFIED BY ‘$dbadminpassword’;”– user=$dbadmin –password=$dbadminpassword * /usr/bin/mysql -e “CREATE USER ‘$dbadmin’@’$wpaddressip’;” –user=$dbadmin –password =$dbadminpassword /usr/bin/mysql -e “SET PASSWORD FOR ‘$dbadmin’@’$wpaddressip’ =PASSWORD(‘$dbadminpassword’);” –user=$dbadmin –password=$dbadminpassword /usr/ bin/mysql -e “GRANT ALL PRIVILEGES ON *.* TO ‘$dbadmin’@’$wpaddressip’ IDENTIFIED BY ‘$dbadminpassword’;” –user=$dbadmin –password=$dbadminpassword /usr/bin/mysql- e “GRANT ALL ON *.* TO ‘$dbadmin’@’$wpaddressip’ IDENTIFIED BY ‘$dbadminpassword’;”– user=$dbadmin –password=$dbadminpassword * /usr/bin/mysql -e “CREATE USER ‘$wpuser’@’$wpaddress’;” –user=$dbadmin –password =$dbadminpassword /usr/bin/mysql -e “SET PASSWORD FOR ‘$wpuser’@’$wpaddress’ =PASSWORD(‘$wppassword’);” –user=$dbadmin –password=$dbadminpassword /usr/bin/ mysql -e “GRANT ALL PRIVILEGES ON $wpdbname.* TO ‘$wpuser’@’$wpaddress’ IDENTIFIED BY ‘$wppassword’;” –user=$dbadmin –password=$dbadminpassword /usr/bin/mysql - e “GRANT ALL ON $wpdbname.* TO ‘$wpuser’@’$wpaddress’ IDENTIFIED BY ‘$wppassword’;”– user=$dbadmin –password=$dbadminpassword * /usr/bin/mysql -e “CREATE USER ‘$wpuser’@’$wpaddressshort’;” –user=$dbadmin – password=$dbadminpassword /usr/bin/mysql -e “SET PASSWORD FOR ‘$wpuser’@’$wpaddressshort’ =PASSWORD(‘$wppassword’);” –user=$dbadmin –password=$dbadminpassword /usr/bin/ mysql -e “GRANT ALL PRIVILEGES ON $wpdbname.* TO ‘$wpuser’@’$wpaddressshort’ IDENTIFIED BY ‘$wppassword’;” –user=$dbadmin –password=$dbadminpassword /usr/ bin/mysql -e “GRANT ALL ON $wpdbname.* TO ‘$wpuser’@’$wpaddressshort’ IDENTIFIED BY ‘$wppassword’;” –user=$dbadmin –password=$dbadminpassword * /usr/bin/mysql -e “CREATE USER ‘$wpuser’@’$wpaddresssip’;” –user=$dbadmin –password =$dbadminpassword /usr/bin/mysql -e “SET PASSWORD FOR ‘$wpuser’@’$wpaddresip’ =PASSWORD(‘$wppassword’);” –user=$dbadmin –password=$dbadminpassword /usr/bin/ mysql -e “GRANT ALL PRIVILEGES ON $wpdbname.* TO ‘$wpuser’@’$wpaddressip’ IDENTIFIED BY ‘$wppassword’;” –user=$dbadmin –password=$dbadminpassword /usr/bin/mysql - e “GRANT ALL ON $wpdbname.* TO ‘$wpuser’@’$wpaddressip’ IDENTIFIED BY ‘$wppassword’;”– user=$dbadmin –password=$dbadminpassword * /usr/bin/mysql -e “FLUSH PRIVILEGES;” –user=$dbadmin –password=$dbadminpassword ______________________________________________________________________________ * No way… * Thread Starter [Cesare Rossi](https://wordpress.org/support/users/back2future/) * (@back2future) * [8 years, 5 months ago](https://wordpress.org/support/topic/error-connecting-remote-db/#post-9747233) * This is the wp.sh install script (CentOS 6): * #!/bin/bash * WP_DB_NAME=wordpress WP_DB_USER=wordpressuser WP_DB_PASSWORD=VMware1! WP_DB_HOST =centosdb.ross.lan site_ip=centos6.ross.lan wordpress_site_files=/var/www/html/ site_title=Wordpress01 admin_user=admin admin_password=VMware1! admin_email=administrator@ross. lan * /sbin/chkconfig iptables off /sbin/chkconfig ip6tables off /sbin/service iptables stop /sbin/service ip6tables stop * yum install -y wget yum install -y mysql * /usr/bin/yum install httpd -y /sbin/chkconfig httpd on /sbin/service httpd start * /usr/bin/yum install php php-mysql mysql-client -y /usr/bin/yum -y install php- gd php-ldap php-odbc php-pear php-xml php-xmlrpc php-mbstring php-snmp php-soap curl curl-devel * /sbin/service httpd restart * curl -O [https://raw.githubusercontent.com/wp-cli/builds/gh-pages/phar/wp-cli.phar](https://raw.githubusercontent.com/wp-cli/builds/gh-pages/phar/wp-cli.phar) chmod +x wp-cli.phar mv wp-cli.phar /usr/local/bin/wp * touch /var/www/html/index.php echo “

Welcome to VMware Apache Server! My IP Address is:

” > /var/www/html/index.php * cd /tmp /usr/bin/wget [http://wordpress.org/latest.tar.gz](http://wordpress.org/latest.tar.gz)– output-document=/tmp/latest.tar.gz /bin/tar -xzvf /tmp/latest.tar.gz yes | cp- rf /tmp/wordpress/* /var/www/html/ * cp /var/www/html/wp-config-sample.php /var/www/html/wp-config.php /bin/sed - i “s/database_name_here/$WP_DB_NAME/g” /var/www/html/wp-config.php /bin/sed - i “s/username_here/$WP_DB_USER/g” /var/www/html/wp-config.php /bin/sed -i “s/ password_here/$WP_DB_PASSWORD/g” /var/www/html/wp-config.php /bin/sed -i “s/localhost/ $WP_DB_HOST/g” /var/www/html/wp-config.php * wp core install –url=http://$site_ip –path=$wordpress_site_files –title=”Welcome to the home of the $site_title” –admin_user=$admin_user –admin_password=$admin_password– admin_email=$admin_email * /sbin/service httpd restart * Thread Starter [Cesare Rossi](https://wordpress.org/support/users/back2future/) * (@back2future) * [8 years, 5 months ago](https://wordpress.org/support/topic/error-connecting-remote-db/#post-9747520) * I activated debug options on wp-config.php and the error showed is: * Warning: mysql_connect(): Can’t connect to MySQL server on ‘centosdb.ross.lan’( 13) in /var/www/html/wp-includes/wp-db.php on line 1569 * The line in wp-includes is: * $this->dbh = mysql_connect( $this->dbhost, $this->dbuser, $this->dbpassword, $new_link, $client_flags ); * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [8 years, 5 months ago](https://wordpress.org/support/topic/error-connecting-remote-db/#post-9748390) * I know you’e on a 10. non-routable network, but it just makes my teeth tingle unpleasantly when you post passwords. * Given that `mysql -u wordpressuser -p -h 10.15.63.83` works, we know it’s not firewall or networking issue, nor how the password was set. * So, could there be some character in the DB password that’s confusing PHP? Change the db user password to something really stupidly simple (no special characters, just letters) and see if that makes a diff. * If you’re using a version of PHP less than 7, this script may give you a more useful message that “something bad happened”: [https://gist.github.com/sivel/162913](https://gist.github.com/sivel/162913) * Thread Starter [Cesare Rossi](https://wordpress.org/support/users/back2future/) * (@back2future) * [8 years, 5 months ago](https://wordpress.org/support/topic/error-connecting-remote-db/#post-9751728) * Steve, * don’t worry about the password in clear, it is the standard password we use in public Hand-On-Labs in VMworld, so about 30,000 people every year knows that password 🙂 * I’ve change that password with “password” but nothing changed. * The wp-mysql-test.php You mention says: * [root@centos6 html]# php /var/www/html/wp-mysql-test.php Connected successfully to the MySQL server Database selected successfully * Checking tables for errors: The table wordpress.wp_commentmeta is OK The table wordpress.wp_comments is OK The table wordpress.wp_links is OK The table wordpress. wp_options is OK The table wordpress.wp_postmeta is OK The table wordpress.wp_posts is OK The table wordpress.wp_term_relationships is OK The table wordpress.wp_term_taxonomy is OK The table wordpress.wp_termmeta is OK The table wordpress.wp_terms is OK The table wordpress.wp_usermeta is OK The table wordpress.wp_users is OK * Thank You for Your cooperation. - This reply was modified 8 years, 5 months ago by [Cesare Rossi](https://wordpress.org/support/users/back2future/). - This reply was modified 8 years, 5 months ago by [Cesare Rossi](https://wordpress.org/support/users/back2future/). - This reply was modified 8 years, 5 months ago by [Cesare Rossi](https://wordpress.org/support/users/back2future/). * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [8 years, 5 months ago](https://wordpress.org/support/topic/error-connecting-remote-db/#post-9752783) * Darn, so it’s able to connect. I’m out of ideas. Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘Error connecting remote DB’ is closed to new replies. ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [failure](https://wordpress.org/support/topic-tag/failure/) * [Remote](https://wordpress.org/support/topic-tag/remote/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 7 replies * 2 participants * Last reply from: [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * Last activity: [8 years, 5 months ago](https://wordpress.org/support/topic/error-connecting-remote-db/#post-9752783) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics