Welcome to Linux Forums!

With a comprehensive Linux Forum, information on various types of Linux software and many Linux Reviews articles, we have all the knowledge you need a click away, or accessible via our knowledgeable members.

Linux Forum ArticlesLinux ForumsLinux Forum DownloadsLinux Hosts
Home|Register|FAQ|Member List|Calendar|Unanswered Posts|Forum Rules|Today's Posts|Advanced Search|
SEARCH FOR IN
Go Back   Linux Forums > GNU Linux Zone > Linux Programming & Scripting
Reload this Page mysql/PHP question
Linux Forums
Linux Forums
Welcome To The Linux Forums!
Welcome to Linux Forums. We pride ourselves in being one of the largest Linux communities on the web, we encourage you to REGISTER on our forums and participate in the community. There are over 150,000 members ready to answer your questions. JOINING US today will allow you to make new posts, get support, send messages to other members and submit downloads to our downloads directory and many other great features!

Linux Programming & Scripting C, Perl, PHP, Bash Scripts, anything programming or script related post in here!

Reply
 
Thread Tools Display Modes
Old 12-28-2003   #1 (permalink)
sarumont
Content Team Leader
 
sarumont's Avatar
 
Join Date: Apr 2003
Location: /dev/urandom
Posts: 3,662
mysql/PHP question

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:

Code:
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:

Code:
grant select on Media.* to guest@'%' identified by 'guest';
And here's the PHP snippet that should handle the connection:

Code:
$link = mysql_connect( "evocation", "guest", "guest" ) or die( "Unable to open connection." );
Anyone have any clues as to why I can't connect?
sarumont is offline   Reply With Quote
Old 12-28-2003   #2 (permalink)
jasonlambert
Linux Guru
 
Join Date: Apr 2003
Location: London, UK
Posts: 3,284
after doing your mysql grant statement, you then need to do a "Flush privilages" statement as well.

Jason
jasonlambert is offline   Reply With Quote
Old 12-28-2003   #3 (permalink)
sarumont
Content Team Leader
 
sarumont's Avatar
 
Join Date: Apr 2003
Location: /dev/urandom
Posts: 3,662
Schweet. That worked. Thanks, J. Now all I have to do is learn some PHP.
sarumont is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




All times are GMT. The time now is 05:54 AM.




© 2000 - 2008 - All Rights Reserved - Property of  MAS Media

Content Relevant URLs by vBSEO 3.0.0