I am doing something wrong or have something set up wrong.
When I issue
mysql> grant all on * to mike identified by 'joented' with grant
option;
Query OK, 0 rows affected (0.69 sec)
It looks like the grant worked. Here is what the mysql.user table looks
like.
mysql> select user,password, host from mysql.user;
+---------+---------------------+-----------+
| user | password | host |
+---------+---------------------+-----------+
| root | | localhost |
| root | | % |
| | 3823a5ee1f831626 | localhost |
| | | % |
| bruceaj | 426d920b373a5e5b | % |
| mike | 426d920b373a5e5b | % |
| peter | 426d920b373a5e5b | % |
| jim | 426d920b373a5e5b | % |
+---------+-----------------==-+-----------+
Now, when I issue a mysql command for mike, I get
C:\mysql\bin>mysql -u mike -pjoented;
ERROR 1045: Access denied for user: 'mike@localhost' (Using password:
YES)
The ONLY User I can login as is root, as:
mysql -u root
Appreciate your help in identifing what what I have screwed up, and how do I
fix it.
Thanks.....
Bruce