Title: Cesare Rossi's Replies | WordPress.org --- # Cesare Rossi [ ](https://wordpress.org/support/users/back2future/) * [Profile](https://wordpress.org/support/users/back2future/) * [Topics Started](https://wordpress.org/support/users/back2future/topics/) * [Replies Created](https://wordpress.org/support/users/back2future/replies/) * [Reviews Written](https://wordpress.org/support/users/back2future/reviews/) * [Topics Replied To](https://wordpress.org/support/users/back2future/replied-to/) * [Engagements](https://wordpress.org/support/users/back2future/engagements/) * [Favorites](https://wordpress.org/support/users/back2future/favorites/) Search replies: ## Forum Replies Created Viewing 10 replies - 1 through 10 (of 10 total) * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Error connecting remote DB](https://wordpress.org/support/topic/error-connecting-remote-db/) * 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/). * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Error connecting remote DB](https://wordpress.org/support/topic/error-connecting-remote-db/) * 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 ); * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Error connecting remote DB](https://wordpress.org/support/topic/error-connecting-remote-db/) * 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 * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Error connecting remote DB](https://wordpress.org/support/topic/error-connecting-remote-db/) * 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… * Forum: [Installing WordPress](https://wordpress.org/support/forum/installation/) In reply to: [Separate DB server Installation with “Error establishing a database connection”](https://wordpress.org/support/topic/separate-db-server-installation-with-error-establishing-a-database-connection/) * [Cesare Rossi](https://wordpress.org/support/users/back2future/) * (@back2future) * [8 years, 5 months ago](https://wordpress.org/support/topic/separate-db-server-installation-with-error-establishing-a-database-connection/#post-9743256) * Hi, * same problem here. web server on 10.15.63.82, db server on 10.15.6.83. * Permissions for wordpressuser on WordPress db: * +———————————————————————————————————————–+ | Grants for wordpressuser@% | +———————————————————————————————————————– + | GRANT ALL PRIVILEGES ON *.* TO ‘wordpressuser’@’%’ IDENTIFIED BY PASSWORD‘* 16907081F70B954E79743DA4F785043069E9D33F’ | | 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 ‘wordpressuser’@’%’ IDENTIFIED BY PASSWORD ‘*16907081F70B954E79743DA4F785043069E9D33F’ | | GRANT ALL PRIVILEGES ON `wordpress`.* TO ‘wordpressuser’@’%’ | +———————————————————————————————————————– + * Always receive “Error establishing a database connection”: no way to solve it. * I’ve changed permissions on /var/ to 777 🙁 * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Postie] Postie broken in 3.3 _fill_user() problem](https://wordpress.org/support/topic/postie-broken-in-33-_fill_user-problem/) * [Cesare Rossi](https://wordpress.org/support/users/back2future/) * (@back2future) * [14 years, 5 months ago](https://wordpress.org/support/topic/postie-broken-in-33-_fill_user-problem/#post-2443771) * The same here… * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WPBook] WPBook: 2.2 image thumb](https://wordpress.org/support/topic/wpbook-22-image-thumb/) * [Cesare Rossi](https://wordpress.org/support/users/back2future/) * (@back2future) * [15 years, 1 month ago](https://wordpress.org/support/topic/wpbook-22-image-thumb/#post-2011729) * This is my blog post: [http://blog.americacube.us/2011/04/04/svizzeri/](http://blog.americacube.us/2011/04/04/svizzeri/) * And this is the Facebook “publish as note” post: [http://www.facebook.com/notes/cesare-g-rossi/svizzeri/10150143975257374](http://www.facebook.com/notes/cesare-g-rossi/svizzeri/10150143975257374) * Before WPBook update all my blog post were published to Facebook with the hyperlink that point to the blog page: now the hyperlink opens the facebook post… * Try this post of my blog: [http://blog.americacube.us/2011/03/20/torta-flor-150/](http://blog.americacube.us/2011/03/20/torta-flor-150/) * and search for the same post on Facebook on my wall: [http://www.facebook.com/Back2Future](http://www.facebook.com/Back2Future) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WPBook] WPBook: 2.2 image thumb](https://wordpress.org/support/topic/wpbook-22-image-thumb/) * [Cesare Rossi](https://wordpress.org/support/users/back2future/) * (@back2future) * [15 years, 1 month ago](https://wordpress.org/support/topic/wpbook-22-image-thumb/#post-2011726) * If you use “post as note” the hyperlink on facebook doesn’t open the blog post anymore.. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WPBook] WPBook: 2.2 image thumb](https://wordpress.org/support/topic/wpbook-22-image-thumb/) * [Cesare Rossi](https://wordpress.org/support/users/back2future/) * (@back2future) * [15 years, 1 month ago](https://wordpress.org/support/topic/wpbook-22-image-thumb/#post-2011712) * Thank You, Coach! Setting WPBook to post to my wall as a Note fixed the bug, but now the text of published post from my blog is limited to only one line of text… 🙁 * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WPBook] WPBook: 2.2 image thumb](https://wordpress.org/support/topic/wpbook-22-image-thumb/) * [Cesare Rossi](https://wordpress.org/support/users/back2future/) * (@back2future) * [15 years, 1 month ago](https://wordpress.org/support/topic/wpbook-22-image-thumb/#post-2011702) * Tell me more… I’ve the same bug! Viewing 10 replies - 1 through 10 (of 10 total)