7 lines
424 B
Plaintext
7 lines
424 B
Plaintext
|
|
## - ----------------------------------------------------------------
|
|
## - 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
|
|
|