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 am getting a 'msyql server has gone away' error sometimes when doing a large binary insert, so I wanted to check the settings on mysql, things like wait_timeout and max_allowed_packet. However

show create table mysql.user


[Err] 1142 - SELECT command denied to user '557574_prod'@'' for table 'user'

I'd rather not hit up tech support whenever I want to know some of the relevant settings, so I was wondering if there might be a workaround?

share|improve this question
Can you do: show variables like 'wait%';? – Jack Douglas May 26 '11 at 18:57
up vote 2 down vote accepted

You could do things like these:



Show status;

share|improve this answer

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.