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 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 Run Script

source /path/script.sql

MySQL Enterprise vs Percona Server

MySQL Architecture

Bibliography