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 have a mysql server that is not under my control (I don't have ssh on that machine). I only have access to one database using mysql client.

How can I have access to config options that are declared in my.cnf?

share|improve this question
up vote 4 down vote accepted

Depending on how your access was implemented, you may be able to look at my.cnf with the \! command.

mysql> pager less
mysql> \! cat /etc/mysql/my.cnf
mysql> nopager

If you want to know what variables are actually running on the server, look at SHOW GLOBAL VARIABLES

share|improve this answer

I am not sure whether you want to know configuration parameters or want to modify those parameters. Just if you want to know configuration parameters, then from MySQL client, execute following query,

Show global variables;

This will list all the configuration parameters which is nothing but my.cnf.

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.