sudo systemctl restart mysql
How to import database in MySQL
mysql --user=root --password=root DatabaseName < backup.sql
How to output the last part of files
tail File1 File2...
How to output the first part of files
head File1 File2...
How to validate MySQL server configuration
mysqld --validate-config
How to view all mysqld options and configurable system variables in MySQL
mysqld --verbose --help
How to find the MySQL configuration file location
mysqld --verbose --help | grep cnf
How to backup databases in MySQL
mysqldump --user=root --password=root --databases db1 db2... > backup.sql
How to display databases, tables, and columns information in MySQL
mysqlshow --user=root --password=root
mysqlshow --user=root --password=root DatabaseName
mysqlshow --user=root --password=root DatabaseName TableName
How to remove untracked files from the working tree in Git
git clean -df