>>Show me the output of the following:
>> SHOW GRANTS FOR 'username'@'hostname';
output:
mysql> show grants for 'root@localhost';
ERROR 1064: You have an error in your SQL syntax near 'grants for 'root@localhost'' at
line 1
I noticed that my user table doesn't seem to have all the fields it
I am trying to set up MyODBC on a Win2K box to access MySQL on a Linux machine. I am
getting an error message that says my host is not allowed to connect. I then tried to
run a GRANT query under the mysql on the Linux machine to create a valid user in the
hosts table.
I am using version 3.22
