show user list:
Select user from mysql.user;
show user list with their host connections:
select host, user from mysql.user;
SELECT User FROM mysql.user;
Show databases
SHOW {DATABASES | SCHEMAS}
[LIKE ‘pattern’ | WHERE expr]
Show tables
Show tables ;
Backup and restore bdd
Grant privileges
GRANT ALL PRIVILEGES ON database_name.* TO ‘username’@’localhost’;
Show Privileges
Show grants ;
Autoriser connexion d’un serveur distant:
/etc/mysql/mariabd.conf.d/50-server.cnf
Ajouter le réseau dans bindadress