I think you're using it incorrectly. It should be:
grant insert on test.* to testuser@localhost identified by 'testpassword';
> I have successfully installed MySQL 3.23.38. I can start the server
> and log in as root. When I try to grant new users using:
>
> grant insert to test.* for testuser identified by 'testpassword';
>
> It comes back saying 0 rows affected. I can go the the MySQL db
> and look at the grant table and it will show testuser with proper
> privlidges but a very scrambled looking password (not sure if that is
> on purpose for security). But when I try to log that user in using:
>
> mysql -u testuser -p
> and then enter the password: testpassword
>
> The login fails everytime.
>
> Any help would be appreciated. Thanks!!!
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
