Disable MySQL bin log on Bitnami


if you have cloud sevrer with less disk space, it is better disable MySQL bin log as it take approx 3 GB of disk space on bitnami server. To disable MySQL binlog, edit mysql config file.


Add below

Here is what i have in the my.cnf

Now restart MySQL


Read More…

MySQL server has gone away

When restoring a MySQL database, i get error “MySQL server has gone away”.

To fix this, edit MySQL configuration file. Add following line under [mysqld] section.

Restart MySQL

If you use MariaDB

Related Posts MySQL […]

Read More…

Aria engine is not enabled or did not start

When starting MaraDB, i got error

To fix error, remove the file


Read More…

Install MariaDB 10.3 on CentOS 7


MariaDB is an Open Source MySQL drop in replacement. MariaDB provides repository for various operating systems at http://downloads.mariadb.org/mariadb/repositories/ To install MariaDB 10.3 on CentOS 7, create file


Install MariaDB server and client with

Enable MariaDB start on boot

Start MariaDB


Read More…

MySQL ERROR Access denied you need SUPER privilege for this operation


WHen restoring a MySQL database, i get following error

I opened the file in vim editor. On checking line 4382, i found following

This is because some stored procedures use old database user as definer. To fix you need to find and replace all entry for old username with new username. In vim, […]

Read More…

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

On /var/lib/mysql folder, there is a tc.log file with 0 size. The error is solved by removing this file.


Read More…

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.

Source server

Destination server

I opend the SQL file in editor and checked line 287, i run the SQL in mysql, that resulted in error

I run the command on […]

Read More…

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 to the folder where “mysqld.exe” is located and run following command

If you want a differnt name for service, run

You can delete service with command


Read More…

MySQL 8 apt Error The following signatures were invalid

When trying to install MySQL 8 on Ubuntu 18.04, i get following error

To fix this error, run

Now apt update will work. To list keys, run


Read More…

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

This is because open_files_limit limit in MySQL. To verify login to MySQL server and run

This will give you current value of open_files_limit. To increase, edit /etc/my.cnf file, add

Add under […]

Read More…