3.691
Bearbeitungen
Änderungen
Zur Navigation springen
Zur Suche springen
Zeile 23:
Zeile 23: + + + + + + + + + +
→Nur-Root-Login
(als root)# mysql -u root
(als root)# mysql -u root
> grant all on *.* to root2@localhost identified by 'geheim' with grant option;
> grant all on *.* to root2@localhost identified by 'geheim' with grant option;
== Verbose Logging in MariaDB ==
Zur Fehlersuche kann man in MariaDB folgendermaßen alle Abfragen loggen:
cat > /etc/mysql/conf.d/verboselogging.cnf <<EOF
[mysqld]
general-log
general-log-file=/var/log/mysql/queries.log
log-output=file
EOF
------
------