Ci-dessous, les différences entre deux révisions de la page.
Prochaine révision | Révision précédente Dernière révision Les deux révisions suivantes | ||
linux:mariadb [10-09-2017 17:59] edmc73 créée |
linux:mariadb [09-02-2020 22:49] edmc73 [Commandes] |
||
---|---|---|---|
Ligne 19: | Ligne 19: | ||
</ | </ | ||
+ | |||
+ | ===== Commandes ===== | ||
+ | |||
+ | Voir la liste des users | ||
+ | |||
+ | < | ||
+ | mysql> select host,user from mysql.user; | ||
+ | +-----------+------------------+ | ||
+ | | host | user | | ||
+ | +-----------+------------------+ | ||
+ | | % | toto | | ||
+ | | 127.0.0.1 | root | | ||
+ | | ::1 | root | | ||
+ | | debian | ||
+ | | localhost | api | | ||
+ | | localhost | debian-sys-maint | | ||
+ | | localhost | root | | ||
+ | +-----------+------------------+ | ||
+ | </ | ||
+ | |||
+ | |||
+ | |||
+ | Voir les privilèges | ||
+ | |||
+ | < | ||
+ | mysql> SELECT * FROM information_schema.user_privileges; | ||
+ | +--------------------------------+---------------+-------------------------+--------------+ | ||
+ | | GRANTEE | ||
+ | +--------------------------------+---------------+-------------------------+--------------+ | ||
+ | | ' | ||
+ | | ' | ||
+ | | ' | ||
+ | | ' | ||
+ | | ' | ||
+ | | ' | ||
+ | | ' | ||
+ | | ' | ||
+ | | ' | ||
+ | ... | ||
+ | </ | ||
+ | |||
+ | |||
+ | < | ||
+ | mysql> show grants for ' | ||
+ | +----------------------------------------------------------------------------------------------------------------------------------------+ | ||
+ | | Grants for root@localhost | ||
+ | +----------------------------------------------------------------------------------------------------------------------------------------+ | ||
+ | | GRANT ALL PRIVILEGES ON *.* TO ' | ||
+ | | GRANT PROXY ON '' | ||
+ | +----------------------------------------------------------------------------------------------------------------------------------------+ | ||
+ | </ | ||
+ | |||
+ | Penser aussi à modifier le fichier **/ | ||
+ | < | ||
+ | # Automatically generated for Debian scripts. DO NOT TOUCH! | ||
+ | [client] | ||
+ | host = localhost | ||
+ | user = root | ||
+ | password = XXXXXXXXXX | ||
+ | socket | ||
+ | [mysql_upgrade] | ||
+ | host = localhost | ||
+ | user = root | ||
+ | password = XXXXXXXXXX | ||
+ | socket | ||
+ | basedir | ||
+ | </ | ||
+ | |||
+ | Ca permettra par exemple à logrotate de générer des erreurs du type | ||
+ | < | ||
+ | # | ||
+ | error: ' | ||
+ | error: error running shared postrotate script for '/ | ||
+ | </ | ||
+ | |||
+ | Vérifiez le bon fonctionnement avec la commande | ||
+ | < | ||
+ | # mysqladmin --defaults-file=/ | ||
+ | +----------+-------------+-----------+----+---------+------+--------------------------+------------------+----------+ | ||
+ | | Id | User | Host | db | Command | Time | State | Info | Progress | | ||
+ | +----------+-------------+-----------+----+---------+------+--------------------------+------------------+----------+ | ||
+ | | 1 | system user | | ||
+ | | 2 | system user | | ||
+ | | 3 | system user | | ||
+ | | 4 | system user | | ||
+ | | 5 | system user | | ||
+ | | 14507011 | root | localhost | | Query | 0 | Init | show processlist | 0.000 | | ||
+ | +----------+-------------+-----------+----+---------+------+--------------------------+------------------+----------+ | ||
+ | |||
+ | </ | ||
+ | |||
+ |