semi-OT Grant Tables in MySQL
| From: | John Starkey | Date: | Tue, 09 Jan 2001 05:51:33 +0000 |
| Subject: | semi-OT Grant Tables in MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-5730@lists.php.net to get a copy of this message | ||
Please forgive me but I really don't want to sign on to another list for
one question. And I am trying to access MySQL via PHP.
So uhhh. How do I set up user tables in MySQL.
Using
"GRANT ALL PRIVILEGES ON db.* TO user@localhost IDENTIFIED BY 'passwd';
Is returning SYNTAX OK 0 rows affected and access denieds.
Can anyone tell me what's going on? I can access it without specifying a
user. And with PHP I get @localhost denieds.
Thanks,
JOhn