Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

2 Answers 2

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

mysql> SHOW GLOBAL VARIABLES;
share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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.