RE: [PHP-INST] PHP w/ MySQL
| From: | Matt Schroebel | Date: | Thu, 30 Jan 2003 16:22:54 +0000 |
| Subject: | RE: [PHP-INST] PHP w/ MySQL | ||
| Groups: | php.install | ||
| Request: | Send a blank email to php-install+get-9896@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Nick Gianakas [mailto:ngianakas@lio.aacisd.com]
> Sent: Thursday, January 30, 2003 11:17 AM
> To: php-install@lists.php.net
> Subject: RE: [PHP-INST] PHP w/ MySQL
> > Do you have a host entry for localhost?
> If you're referring to /etc/hosts, yes I do.
> These are the contents of my hosts file:
> 127.0.0.1 nimble localhost.localdomain localhost
Change that to
127.0.0.1 localhost localhost.localdomain nimble
And you should be fine
> 192.168.1.5 nimble
>
> > Quick & Dirty you could add rights to nimble your user.
> I don't follow. Add rights for my database user in MySQL
> explicitly for
> nimble?
If you need to, add the rights to your user at nimble, but the above
should fix it:
Grant all privileges on database_name.* to user_name@nimble identified
by 'my_secret';
Flush privileges;
That example is pretty un-restrictive, so you may only want to grant
insert,update,delete,etc rights