User Tools

Site Tools


dev:mysql

This is an old revision of the document!


MySQL / MariaDB

Lister les utilisateurs

select host, user, password from mysql.user;

+-----------+-------------+-------------------------------------------+
| Host      | User        | Password                                  |
+-----------+-------------+-------------------------------------------+
| localhost | root        |                                           |
| localhost | freshrss    | *                                         |
| localhost | nextcloud   | *                                         |
| localhost | ttrss       | *                                         |
| localhost | bookstack   | *                                         |
| localhost | wordpress   | *                                         |
| localhost | pommegyv    | *                                         |
| localhost | grimblog    | *                                         |
| localhost | grimbox     | *                                         |
| localhost | mariadb.sys |                                           |
+-----------+-------------+-------------------------------------------+
10 rows in set (0.009 sec)

Lister les bases de données

show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| bookstack_db       |
| freshrss           |
| grimbox_db         |
| information_schema |
| mysql              |
| nextcloud          |
| performance_schema |
| pommegyv_db        |
| ttrss              |
| wordpress_db       |
+--------------------+
10 rows in set (0.005 sec)

Dump d'une base de données

mysqldump -u $USER $DATABASE_NAME > $OUTPUT_FILE

Restore d'une base de données

#mysqldump -u user -p nomdatabase < nom_du_dump.sql
dev/mysql.1697914463.txt.gz · Last modified: 2023/10/21 18:54 by fred