MariaDB (Debian)

Connect to Server

$ mysql -u user1 -p                     # Mit Passwortabfrage
$ mysql -u user1 -ppassword1
exit                                    # Close connection

Database Management

show databases;                         # Datenbanken anzeigen
create database [database];             # Create new database
use [database];                         # Select Database
show tables;
describe [table]; 

User Management

Show permissions for current user:

show grants;

List users:

select user,host from mysql.user;

Create user:

create user 'username'@'localhost' identified by 'password';

Grant all access to user for * tables:

grand all on database.* to 'user'@'localhost';

Create Database

# mysql -u root -p<password>

mysql> create database sugarcrm;
Query OK, 1 row affected (0.02 sec)

Restore Database

mysql -u root -p[root_password] [database_name] < dumpfilename.sql