MySQL 8

MySQL

MySQL 8 use caching_sha2_password as default autentication method. Many mysql clients still not support this method. If you need to use old method, you can set autentication plugin as mysql_native_password. You can also set this as default method by editing my.cnf file.

To change a user to use mysql_native_password, run

[…]

Read More…

Disable MySQL bin log on Bitnami

MySQL

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.

Find

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

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

Add

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

MySQL

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

MySQL

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

MySQL

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…