mySQL info

A quick way to get some mysql information is to run

mysql --help --verbose

but as mysql is not always on the path, we can create an alias or similar as follows;

whereis mysql

and on my Slackware server this is /usr/libexec/mysqld

so we create a file /bin/mysqlinfo containing the following;

/usr/libexec/mysqld --help --verbose

and make it executable;

chmod +x /bin/mysqlinfo

we can now run mysqlinfo or mysqlinfo | grep -i 'bind' etc to our heart's content.

If we didn't need the --help and --verbose we could of course just have done;

ln -s /usr/libexec/mysqld /bin/mysqlinfo

but I did, so I didn't...