Quelques infos en vrac .. Changer le mot de passe d’un utilisateur
|
UPDATE user SET password='<strong>mon_nouveau_mdp</strong>' WHERE user=<strong>mon_user</strong>'; |
Export requête vers fichier csv Ajouter a la fin de la requête
|
INTO OUTFILE '/tmp/export_requete.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; |
Pour lister les comptes utilisateurs.
|
MariaDB [(none)]> SELECT User,Host FROM mysql.user; |
|
+-------------------+ | User | Host | +-------------------+ | root | 127.0.0.1 | | root | ::1 | | user1 | localhost | | user2 | localhost | | root | localhost | +-------------------+ 5 rows in set (0.00 sec) |
Supprimer un compte utilisateur.
|
MariaDB [(none)]> DROP USER 'user2'@'localhost'; |
Lister les db.
|
MariaDB [(none)]> SHOW DATABASES; |
|
+--------------------+ | Database | +--------------------+ | information_schema | | mysql | | test-db | +--------------------+ 4 rows in set (0.00 sec) |
Supprimer une db.
|
MariaDB [(none)]> DROP DATABASE test-db; |
ou
|
MariaDB [(none)]> DROP DATABASE IF EXISTS test-db; |
Exporter […]
Lire la suite