dev:mysql
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| dev:mysql [2023/10/21 18:54] – ↷ Page moved from mysql to dev:mysql fred | dev:mysql [2025/01/15 20:35] (current) – removed fred | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== 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