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
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