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:
I've used this command to add guest:
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.
And here's the PHP snippet that should handle the connection:
grant select on Media.* to guest@'%' identified by 'guest';
Anyone have any clues as to why I can't connect? :)
$link = mysql_connect( "evocation", "guest", "guest" ) or die( "Unable to open connection." );
after doing your mysql grant statement, you then need to do a "Flush privilages" statement as well.
Schweet. That worked. Thanks, J. Now all I have to do is learn some PHP. :D