dev:mysql
This is an old revision of the document!
Table of Contents
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