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:
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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 "%."
Dig Deeper on Linux management and configuration
Related Q&A from Scott Noyes
Get suggestions for choosing MySQL character sets and field collations from expert Scott Noyes.continue reading
A MySQL expert describes two ways that the multi-master support can be used.continue reading
An expert describes where to find information on detection deadlock algorithms in MySQL.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.