Re: Solved! mysql_connect() - but mysql_result problem occurs
| From: | Rino Mardo | Date: | Tue, 12 Dec 2000 18:06:51 +0000 |
| Subject: | Re: Solved! mysql_connect() - but mysql_result problem occurs | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-29913@lists.php.net to get a copy of this message | ||
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');
i've also reloaded mysql to make sure.
--
--------------------------------------------------------------------
Key fingerprint = 9DE1 5825 77B4 FF45 7485 D3EB DCCF DE48 09B6 4426
--------------------------------------------------------------------
"Who's watching the watchmen?"