MySQL\MariaDB

Export all databases:

mysqldump -u root -p --all-databases > alldb.sql

mysqldump -u root -p --all-databases --skip-lock-tables > dump.sql

Export remote databese or rds:

mysqldump -h database-some.resource.com.rds.amazonaws.com -u USER -p DATABASE > dump.sql

Import all databases:

mysql -u root -p < alldb.sql

Export specific database:

mysqldump -u USER -p DATABASE > dump.sql

Import specific database:

mysql -u USER -p DATABASE < dump.sql

Show all databases:

mysqlshow -u USER -p

Show All Users

SELECT User, Host FROM mysql.user;

Connect to mysql

mysql -uroot -p

Show all databases:

show databases;

To access a specific database:

use dbname;

Restart mysql:

service mysql restart

Config mysql:

nano /etc/mysql/my.cnf

Create new MySQL User:

CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';

Grant all privileges to a user account on a specific database:

GRANT ALL PRIVILEGES ON database_name.* TO 'user'@'localhost';

Create a new database:

CREATE DATABASE some_database;

Delete a Database:

DROP DATABASE some_database;

Set user password (MySQL 5.7.6 and later or MariaDB 10.1.20 and later)

ALTER USER 'user'@'localhost' IDENTIFIED BY 'new_password';

FLUSH PRIVILEGES;