mysql> show databases;
Pour créer une base db pour l’utilisateur user :
mysql> CREATE DATABASE db; mysql> GRANT ALL ON db.* TO user@localhost IDENTIFIED BY 'password';
mysql> use articles;
mysql> use mysql; mysql> select host,user,password from user;
user # mysqldump db_name > fichier.sql
user # mysql db_name < fichier.sql