On Saturday 11 February 2006 02:19 pm, Kory Hamzeh wrote:
Jason,
Mysql://drupalusername:drupalpassword@fullhostname/drupaldatabasename
If your database is on the same computer as the Web server, you probably want "localhost" instead of "fullhostname".
$db_url = 'mysql://drupalusername:drupalpassword@localhost/drupaldatabasename';
It works now!! Thank you.
If your database is on a different computer, your grant permissions were probably not set to allow the remote Web server to access the database.
GRANT ALL PRIVILEGES ON drupaldatabasename.* TO drupalusername@fullhostname IDENTIFIED BY 'drupalpassword';
I did issue the above command, except the MySQL doc stated to use '%" instead of the actual host name. Did I misunderstand something?
I believe the % represents the wild card for host names. I guess if it works, then it should be okay, but if you want a greater level of security, you should probably use localhost, if you can.
Anyway, its working and I'm very happy!
You're welcome.