Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using the CREATE USER and GRANT commands as mentioned here

When I try to connect I get this in MySQL Quer Browser:

Could not connect to host ''.
MySQL Error Nr. 0

Output in MySQL Workbench:

Your connection attempt failed for user 'site' from your host to server at
  MySQL server has gone away

Some details:

  • MySQL version: 5.6.13

  • Credentials are typed correctly. When I miss them I get the standard 1045 access denied error.

  • The user created with the instance and another limited user I created some weeks ago are working fine

  • Same commands worked fine on a non RDS server

Any ideas?

Thanks in advance.

share|improve this question
Did you run FLUSH PRIVILEGES; after granting? – Phil Jan 7 '14 at 17:24
Yes. I also tried to restart the instance. – FkJ Jan 7 '14 at 17:30
up vote 2 down vote accepted

I forgot that I had created a stored procedure to set the time zone after every connection made.

Looking at the server log I found that the problem was that the new users didn't have permission to execute it.

share|improve this answer
Thank you, this is a wonderful tip for something to be aware of. – dotancohen Mar 20 '14 at 13:41

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.