Grant User Problem
Posted: Sat Jul 13, 2002 10:50 pm
I created a user with something similar to the following:
I intentionally left out the host so that it would default to all hosts so that I can connect from any location (I travel alot).
It accepted the command and I flushed the privileges to update mysql.
I can connect from any host but localhost, which I really need.
What did I do wrong and how can I fix it?
Thanks for everything.
Code: Select all
GRANT UPDATE, INSERT, DELETE ON table_name.* TO user_name IDENTIFIED BY "user_password";It accepted the command and I flushed the privileges to update mysql.
I can connect from any host but localhost, which I really need.
What did I do wrong and how can I fix it?
Thanks for everything.