Listing MySQL variables
MySQL servers have several environment variables that are used in different ways by system administrators and web developers.
This recipe shows you how to use Nmap to list environment variables in MySQL servers.
How to do it...
Open your terminal and enter the following command:
$ nmap -p3306 --script mysql-variables --script-args mysqluser=<root>,mysqlpass=<pass> <target>
The MySQL variables will be listed under the script output:
3306/tcp open mysql | mysql-variables: | auto_increment_increment: 1 | auto_increment_offset: 1 | automatic_sp_privileges: ON | back_log: 50 | basedir: /usr/ | binlog_cache_size: 32768 | bulk_insert_buffer_size: 8388608 | character_set_client: latin1 | character_set_connection: latin1 | character_set_database: latin1 | version_comment: (Debian) | version_compile_machine: powerpc | version_compile_os: debian-linux-gnu |_ wait_timeout...