Manage
Learn to apply best practices and optimize your operations.
Giving users access via wildcard
MySQL expert Scott Noyes explains how to grant users access from any location using the 'wildcard.'
I am using MySQL Administrator to control MySQL. When I create users with MySQL Administrator, I can't access MySQL from any other applications. I can access only through "root" and without password. Why is this happening? How can I fix it?
Try granting that user some privileges.
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
Step 2 of 2:
If that doesn't solve the problem, check the user's host. Using Query Browser or the command line client, while connected as root, issue the following command:
SELECT user, host FROM mysql.user WHERE user = 'theUserYouCreated';
Check the `host` field. If it is set to the wildcard "%," your user should be able to connect from anywhere. If it is set to "localhost," your user can only connect from the server on which MySQL is running. Use the GRANT statement to give user access from "%."
This was last published in September 2006
Dig Deeper on Linux servers
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Data Center experts
View all Data Center questions and answers
Start the conversation
0 comments