MariaDB
MariaDB CLI commands
Connect as a user
mysql -u root -p
mysql -u derek -p
Create a new user
CREATE USER 'derek'@'%' IDENTIFIED BY 'SOMEPASSWORDSTRING';
Grant all privileges to the new user
GRANT ALL PRIVILEGES ON *.* TO 'derek'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT;
Alter a current user
ALTER USER 'derek'@'localhost' IDENTIFIED BY 'SOMEPASSWORDSTRING';
FLUSH PRIVILEGES;
EXIT;
Show grants for a user
SHOW GRANTS FOR 'derek';
Backup & Restore
# Dump structure and data
mysqldump -u root -p database > /path/to/database.sql
# If you only want the database structure, no data
mysqldump -u root -p database --no-data > /path/to/database.sql
# Restore a database from SQL backup
mysql -u root -p database < /path/to/database.sql