WordPress.org

1. PcFrk256
   Member
   Posted 1 year ago #

   I'm trying to setup HyperDB for failover if one DB server goes offline.

   I have 2 servers defined:

   $wpdb->add_database(array( 'Host', 'User','Password' , 'Database'));
   $wpdb->add_database(array( 'Host2', 'User','Password' , 'Database'));

   (If my syntax is wrong, please tell me)

   I keep getting this error:

   "Unable to connect to :3306 to read table 'wp_users' (global)"

   Any suggestions?

   Thanks!

2. skippybosco
   Member
   Posted 1 year ago #

   I suspect the access rights for your users are not set correctly. Specifically check to see if they are set to allow remote connections (ie. not localhost or 127.0.0.1)

Topic Closed

This topic has been closed to new replies.