Fact Finding

If you have just been given access to a server with some form of MySQL on it and you want to find out about it...

ps -ef  | grep mysql

cat /etc/my.cnf

mysql -V

MySQL Status

sudo systemctl status mysqld

MySQL Start

Linux

sudo systemctl start mysqld

sudo service mysql start

Windows

"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld"

or (assuming a MySQL Windows Service has been configured)

sc start mysqld_service_name

or

NET START mysqld_service_name 

MySQL Stop

Linux

sudo service mysql stop

Windows

"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqladmin" -u root shutdown  -p

or (assuming a MySQL Windows Service has been configured)

sc stop mysqld_service_name

or

NET STOP mysqld_service_name 

MySQL Version

mysql -V

mysql --version

mysqld --version

If there are no firewalls blocking your route, you can also get basic version information using telnet or nc...

telnet myserver 3306

nc myserver 3306

Example output from nc...

SELECT VERSION();

SELECT @@VERSION;

SHOW VARIABLES LIKE "%version%";

MySQL Uptime

SHOW GLOBAL STATUS LIKE 'Uptime';

SELECT TIME_FORMAT(SEC_TO_TIME(VARIABLE_VALUE ),'%Hh %im') AS Uptime

  FROM information_schema.GLOBAL_STATUS

 WHERE VARIABLE_NAME='Uptime';

MySQL Run Script

source /path/script.sql

MySQL Architecture

Bibliography