I am setting up my newest wordpress site 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?
thanks