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. -- Jason Flatt http://www.oadae.net/ Father of Six: http://www.flattfamily.com/ (Joseph, 13; Cramer, 11; Travis, 9; Angela; Harry, 5; and William, 12:04 am, 12-29-2005) Linux User: http://www.sourcemage.org/ Drupal Fanatic: http://drupal.org/