mysql> grant all privileges on * to bhaselto identified by '<password>';
where <password> is, of course, the password I wanted to use for the user 'bhaselto'. I can see an entry for that user in the 'user' table in the 'mysql' database:
+------------------------+----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+------------------------+----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
[...]
| % | bhaselto | <alphanumerics> | Y | Y | Y | Y | Y | Y | N | N | N | N | N | Y | Y | Y |
where <alphanumerics> is an alphanumeric code that presumably represents the hash of the password that I entered.
However, if I exit mysql and try logging in with the "bhaselto" username, it doesn't let me:
[EMAIL PROTECTED] bhaselto]$ mysql -u bhaselto -p
Enter password: [Here I type the password that I created above]
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
[EMAIL PROTECTED] bhaselto]$
As far as I can tell from reading
http://www.mysql.com/doc/en/GRANT.html
I followed the GRANT syntax correctly for creating a new user; why can't I connect to MySQL as that user?
-Bennett
[EMAIL PROTECTED] http://www.peacefire.org (425) 497 9002
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]