Aria engine is not enabled or did not start
When starting MaraDB, i got error root@localhost:/var/log/mysql# cat error.log 2020-01-19 6:18:46 0 [ERROR] mysqld: Can’t lock aria control file ‘/var/lib/mysql/aria_log_control’ for exclusive…
MySQL
Install MariaDB 10.3 on CentOS 7
MariaDB is an Open Source MySQL drop-in replacement. MariaDB provides a repository for various operating systems at https://mariadb.org/download/?tab=repo-config To install MariaDB 10.3…
MySQL ERROR Access denied you need SUPER privilege for this operation
WHen restoring a MySQL database, i get following error root@ns3043014:~# mysql -u NEW_DB_USER -p’PASSOWRD_HERE’ DB_NAME < BACKUP_FILE.sql ERROR 1227 (42000) at line…
MySQL Recovering after a crash using tc.log
After MySQL upgrade from MraiaDB 10.1 to 10.3, MySQL failed to start. On checking log, found root@localhost:/var/log/mysql# cat error.log 2019-09-23 6:30:10 0…
MariaDB DEFAULT NULL ERROR 1064 (42000)
When trying to restore a MySQL databse bakcup taken on MySQL 5.7 server to MairaDB 10.1 server i get following error. root@server:~#…
Install MySQL as Service in Windows
When you manually install MySQL from zip, no MySQL service get created. To run MySQL Server as a service in windows, go…
MySQL 8 apt Error The following signatures were invalid
When trying to install MySQL 8 on Ubuntu 18.04, i get following error root@ssdnodes-45790:~# apt update Ign:1 http://download.webmin.com/download/repository sarge InRelease Hit:2 http://download.webmin.com/download/repository…
MySQL Got error 24 Too many open files
For ubuntu, see Ubuntu 18.04 MariaDB 10.2 Too many open files On taking MySQL backup with mysqldump, i get following error mysqldump:…
MySQL Out of resources when opening file
On a MySQL server got the error Out of resources when opening file ‘/tmp/#sql_318d_0.MAD’ (Errcode: 24 “Too many open files”) This is…
mysqldump packet bigger than max_allowed_packet
When backing up a MySQL database using mysqldump command, got following error [root@vps189 ~]# mysqldump sok_main > sok_main.sql mysqldump: Error 2020: Got…
Reset MySQL 5.7 root password on Ubuntu 16.04
First stop MySQL with command service mysql stop Now run mysqld_safe –skip-grant-tables On Ubuntu 16.04 server with MySQL 5.7, when i run,…
Extract Backup of one database from mysqldump all databases
When you backup MySQL Server with command mysqldump –all-databases > all-db.sql You get a MySQL backup file containing all databases. If you…