Byte Size Tips: How to Display System Variables for Your MySQL Server

If you are running a MySQL database server, you might be wondering how to see the current settings for the database. In MySQL they are called variables, and it’s very easy to see the current values.

The simplest way is to just use this command from the MySQL prompt, which will show every current configuration setting.

SHOW VARIABLES;

If you want to see only a specific variable, you can use this command. Obviously you’d want to replace the max_connect_errors in that command with the variable that you’re looking for.

by The Geek via How-To Geek