remote mysql database problems

  • Resolved Rob

    (@roballred)


    13 years, 1 month 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?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    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?

    Thread Starter Rob

    (@roballred)

    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.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Nah, just making sure we are where I think we are ??

    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');
    Thread Starter Rob

    (@roballred)

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘remote mysql database problems’ is closed to new replies.