Re: [PHP] Mysql Authentication problem

2003-09-13 Thread Curt Zirzow
* Thus wrote James Hamilton ([EMAIL PROTECTED]): > > > [snip] > > > The user has both localhost and % host privileges in the mysql > > > permission > > > schema. > > > [/snip] > > > > > Any other thoughts? > > [/snip] > > > current testing code: > > $link = mysql_connect("localhost", "user", "pas

RE: [PHP] Mysql Authentication problem

2003-09-11 Thread James Hamilton
> > How did you create this new user? > > Using mysql grant statements: > > originally: > > grant all privilges on name.* to [EMAIL PROTECTED] identified by 'pass'; > grant all privileges on name.* to user@'%' identified by 'pass; > and just now > grant all privileges on name.* to user@'127.0.0.

RE: [PHP] Mysql Authentication problem

2003-09-11 Thread Jay Blanchard
[snip] On Thu, 11 Sep 2003, CPT John W. Holmes wrote: > > current testing code: > > > > $link = mysql_connect("localhost", "user", "pass" ) > > or die("Could not connect : " . mysql_error()); > > print "Connected successfully"; > > mysql_select_db("name") or die("Could not select database");

Re: [PHP] Mysql Authentication problem

2003-09-11 Thread James Hamilton
On Thu, 11 Sep 2003, CPT John W. Holmes wrote: > > current testing code: > > > > $link = mysql_connect("localhost", "user", "pass" ) > > or die("Could not connect : " . mysql_error()); > > print "Connected successfully"; > > mysql_select_db("name") or die("Could not select database"); > > pri

Re: [PHP] Mysql Authentication problem

2003-09-11 Thread CPT John W. Holmes
From: "James Hamilton" <[EMAIL PROTECTED]> > current testing code: > > $link = mysql_connect("localhost", "user", "pass" ) > or die("Could not connect : " . mysql_error()); > print "Connected successfully"; > mysql_select_db("name") or die("Could not select database"); > print "connected"; >

RE: [PHP] Mysql Authentication problem

2003-09-11 Thread James Hamilton
> > [snip] > > The user has both localhost and % host privileges in the mysql > > permission > > schema. > > [/snip] > > > > Add the same user with 127.0.0.1 as the host. Make sure you reload > > ("flush") the users table > > > > Any other thoughts? > [/snip] > > What is your connection string? (

RE: [PHP] Mysql Authentication problem

2003-09-11 Thread Jay Blanchard
[snip] > [snip] > The user has both localhost and % host privileges in the mysql > permission > schema. > [/snip] > > Add the same user with 127.0.0.1 as the host. Make sure you reload > ("flush") the users table > Any other thoughts? [/snip] What is your connection string? (code) P.S. Always

RE: [PHP] Mysql Authentication problem

2003-09-11 Thread Jay Blanchard
[snip] The user has both localhost and % host privileges in the mysql permission schema. [/snip] Add the same user with 127.0.0.1 as the host. Make sure you reload ("flush") the users table -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php