install/mysql
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
master
mysql/DOC
History
Christoph e09a181e77 Add '-DWITH_JEMALLOC=OFF' to cmake options if debian 10 (buster) and MariaDB.
2019-06-15 01:41:44 +02:00
..
mysql.txt Initial import 2017-02-19 12:27:15 +01:00
README.error.mariadb Add '-DWITH_JEMALLOC=OFF' to cmake options if debian 10 (buster) and MariaDB. 2019-06-15 01:41:44 +02:00
Readme.PASSWORD_EXPIRED Initial import 2017-02-19 12:27:15 +01:00
README.percona.debian Some minor changes. 2018-02-27 04:31:04 +01:00
README.performance.reload-dump Add file 'README.performance.reload-dump'. 2018-12-05 12:51:48 +01:00
README.save-grants Initial import 2017-02-19 12:27:15 +01:00

README.save-grants 

## - ----------------------------------------------------------------
## - Datenbank User und deren Rechte auslesen
## - ----------------------------------------------------------------
mysql -uroot -pbuz111 mysql --skip-column-name -A -e"SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') FROM mysql.user WHERE user<>'';" | mysql -uroot -pbuz111 mysql --skip-column-name -A  | sed 's/$/;/g' > ~/mysql-grants.sql