At 18:09 -0500 3/24/02, alan4100 wrote:
>mysql> Grant all on mysql.* to 'root'@'localhost' identified by "password";
>Query OK, 0 rows affected (0.00 sec)
>At this point the priveleges are granted to root@localhost.
>I had to type \q to quit and type in the following:
>But ..... see what happened when I then typed in below..
>C:\mysql\bin>mysql -u root -h localhost
>ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
>I am asking why my access is still denied after I was GRANTED in the
In the GRANT statement, you specified that from that point on
root would need to specify a password in order to connect.
In the subsequent mysql command, you attempted to connect as root,
but you specified no password.
You see why those actions are self-contradictory? :-)