WordPress.org

1. Rob
   Member
   Posted 7 months ago #

   I am setting up my newest wordpress multisite to use the database i have on another server. This is all done in amazon ec2, using ubuntu, just as an fyi. here is the problem, I can connect at the command line to database server using "mysql -u myusername -h myipaddress -p", once i enter the password i can do all the fun database stuff I should be able to. However on the same machine using the same credentials, wordpress install script fails to connect to the database. Any suggestions?

2. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 7 months ago #

   This is a new install, right, so you're not even at the Multisite part?

   What did you put in for your DB location? And is it available on the standard ports?

3. Rob
   Member
   Posted 7 months ago #

   the database is on 3306, i have put the ip address with and without the port in the wp-config.php. My assumption is that if i can connect at command line then i would have to be doing something wrong in the wp-config.php. Sorry, I am not at the multisite part yet, you will have to forgive me for that, but it will be when i get to that part. I can close this topic if you think its a problem.

4. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 7 months ago #

   Nah, just making sure we are where I think we are :D

   You may need to make the wp-config.php file manually (using the wp-config.sample file as a template)

   define('DB_NAME', 'wp_mydatabase');
   define('DB_USER', 'myusername');
   define('DB_PASSWORD', 'PASSWORD');
   define('DB_HOST', 'myipaddress');

5. Rob
   Member
   Posted 7 months ago #

   just found it, i had a space in front of the ipaddress string...doh..thanks for the help

Reply

You must log in to post.