Mariadb commandes

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

Updated on 15 May 2025