Re: Solved! mysql_connect() - but mysql_result problem occurs

On Tue, 12 Dec 2000, Rino Mardo wrote: > On Tue, Dec 12, 2000 at 12:31:39PM -0500 or thereabouts, Ignacio Vazquez-Abrams wrote: > <...snipped...> > > > > > > </body> > > > </html> > > > > > > > Quick question: Does the userid test have select rights on mydb? > > > i think so. here's what i did: > > mysql> insert into > -> host(host,db,Select_priv, Insert_priv, Update_priv, > -> Delete_priv, Create_priv, Drop_priv) > -> > values('localhost','%','Y','Y','Y','Y','Y','Y'); > > > mysql> insert into > -> user (host, user, password) > -> values('localhost','test',password('test')); > > mysql> insert into > -> db (host,db,user,Select_priv, Insert_priv, Update_priv, > Delete_priv, Create_priv, Drop_priv) > -> values > > ('localhost','test','test','Y','Y','Y','Y','Y','Y'); Is that correct? ^^^^ > i've also reloaded mysql to make sure. > -- Ignacio Vazquez-Abrams <ignacio@openservices.net>