views:

154

answers:

2

Can not find a command that displays the current configuration of mysql from within the database.

I know I could look at /etc/mysql/my.cnf but that is not what I need.

+1  A: 

What you are looking for is:

SHOW VARIABLES

You can modify it further like any query:

SHOW VARIABLES LIKE '%max%'
code_burgar
A: 

Use SHOW VARIABLES:

show variables like 'version';

Seth