Re: Newbie Question - mysql_select_db fails with access denied.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



This might be a stupid idea, but did you remember to issue the Flush Privelages; command to the mysql database after granting your user all the rights?
 
--John


Christian Schlaefcke <cschlaefcke@xxxxxxxxxxxxxx> wrote:
Hi Folks,

I want to do something like the following:
$db = mysql_connect("localhost", "myuser") or die("Connect failed : " .
mysql_error());

mysql_select_db("mydb",$db) or die("SELECT_DB failed : " . mysql_error
());

$result = mysql_query("SELECT * FROM mytable", $db) or die("Query
failed : " . mysql_error());

The script does not proceed beyond the "mysql_select_db" line. I get
this error:
SELECT_DB failed: Access denied for user ''@'localhost' to database
'mydb'

What happened to the user information. I have granted all neccessary
rights to "myuser". But it seems that it´s even not caring about the
user.

I have MySQL 4.1.4 and PHP 4.3.8-2.1 on a Fedore Core 2 System running.

Thanks & Regards,

Chris

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



		
---------------------------------
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux