mysql/PHP question

[sarumont]

I have apache and php4 (and php4-mysql) running on my webserver. When trying to access the db from a PHP script, I get this:

Warning: Access denied for user: 'guest@evocation' (Using password: YES) in /pub/www/media.php on line 25

Warning: MySQL Connection Failed: Access denied for user: 'guest@evocation' (Using password: YES) in /pub/www/media.php on line 25
Unable to open connection.

I've used this command to add guest:

grant select on Media.* to guest@'%' identified by 'guest';

And here's the PHP snippet that should handle the connection:

$link = mysql_connect( "evocation", "guest", "guest" ) or die( "Unable to open connection." );

Anyone have any clues as to why I can't connect?

[jasonlambert]

after doing your mysql grant statement, you then need to do a "Flush privilages" statement as well.

Jason

[sarumont]

Schweet. That worked. Thanks, J. Now all I have to do is learn some PHP.