Knowledgebase von Gerald Allerstorfer
mysql -V Instructions for MariaDB 10.1 vi /etc/mysql/mariadb.conf.d/50-server.cnf service mysqld restart mysql -u root -p Show databases MariaDB [(none)]> show databases; Display file format MariaDB [(none)]> SELECT NAME, SPACE, FILE_FORMAT
WeiterlesenAnacron job ‚cron.daily‘ on Ubuntu /etc/cron.daily/logrotate: mysqladmin: connect to server at ‘localhost’ failed error: ‘Access denied for user ‘root’@’localhost’ (using password: NO)’ error: error running shared postrotate script for ‘/var/log/mysql/mysql.log
WeiterlesenDatenbank sichern mysqldump –default-character-set=utf8mb4 -h localhost -uroot -ppassword db_name | gzip > db_name.sql.gz Datenbank wiederherstellen mysql -h localhost -u root -ppassword db_name < db_name.sql Siehe auch Enabling MySQL 4-byte support
Weiterlesen