3

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

returns

[Err] 1142 - SELECT command denied to user '557574_prod'@'96.25.95.162' 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?

  • Can you do: show variables like 'wait%';? – Jack Douglas May 26 '11 at 18:57
2

You could do things like these:

SHOW VARIABLES;

SHOW GRANTS;

Show status;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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