Re: Mysql Authentication problem

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"); > > print "connected"; > > > > with user = null && pass=null && name=test then I can access the test db > > with no probs > > How did you create this new user? Using mysql grant statements: originally: grant all privilges on name.* to user@localhost 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.1'... also tried expanding name.* to *.* JH