Rob,
Thursday, March 14, 2002, 7:01:02 PM, you wrote:
RQ> 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
RQ> under the mysql on the Linux machine to create a valid user in the hosts table.
RQ> I am using version 3.22.32 and logged in as root. When I try to perform a GRANT
statement, I get the error message "ERROR 1045: Access denied for user:
'root@localhost' (Using password: YES)"
RQ> Any ideas why root is not allowed rights? How do I give root user root access?
Did I set up mysql incorrectly from the start? The root user seems to be able to do
everything else.
You can use GRANT statement if you set GRANT OPTION for your user. So
it looks like that your mysql user don't have privileges to set
grants.
Show me the output of the following:
SHOW GRANTS FOR 'username'@'hostname';
RQ> Rob
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
