Re: Cannot set privileges

2002-07-07 Thread Todd Cary
Thanks to Paul, I solved the problem by replacing the "*" with "*.*". In my "PHP and MySQL" book, the "*" is used in the examples. Any explanation why this does not work? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] ---

Cannot set privileges

2002-07-07 Thread Todd Cary
When I log into mysql with [root mysql]# mysql -u root -p and enter the password, I have access to mysql. Then I type in grant all on * to todd identified by 'mypassword' with grant option; Now when I do a select * from users; All of the privileges for todd have N's. Have I missed somethin