Drupal install on remote mysql

Posted by msmani on December 15, 2012 at 9:29am

I am trying to install drupal on remote mysql server. I have created the user in mysql and granted the the privileges.

I am able to connect through command line from my web server like this "mysql -u xxxx -h 10.xxx.yy.zz3 -p".

But when I tried to install drupal I get "SQLSTATE[28000] [1045] Access denied for user 'xxxx'@'localhost'". I have given the privileges for "xxxx"@"10.xxx.yy.zz3" but drupal appends localhost instead of IP to user name. I have changed settings.php to mysql server IP.

What am I missing?

Comments

To get your drupal.server to

Posted by dman on December 15, 2012 at 9:59am

To get your drupal.server to connect to mysql.server, you need to open the 'advanced' tab in the database settings form when installing and enter the msql.server address in the field there. Otherwise it assumes localhost.

If you are editing the settings.php by hand ... make sure you are editing the right array in the right site folder. If you've got multisite folders and have recently changed the domain, it may be falling back to the default/settings.php

_{.dan. is the New Zealand Drupal Developer working on Government Web Standards}

Thanks

Posted by msmani on December 15, 2012 at 10:08am

Thanks a lot.. how stupid of me to not notice this...

That's my telepathy at work

Posted by dman on December 15, 2012 at 12:12pm

That's my telepathy at work again.
I intuited you may have been in a go-live migration .. which usually means a new domain :-)

_{.dan. is the New Zealand Drupal Developer working on Government Web Standards}