[support] New Install Problem: Access Denied

[Jason Flatt]

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 at 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/