MySQL root password in VestaCP

MySQL root password in VestaCP

In VestaCP server, MySQL root password is stored in file /usr/local/vesta/conf/mysql.conf, to find MySQL root password, run

MySQL

MySQL 8

MySQL 8 use caching_sha2_password as the default authentication method. Many MySQL clients still do not support this method. If you

MySQL

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

MySQL server has gone away

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.

Aria engine is not enabled or did not start

Aria engine is not enabled or did not start

When starting MaraDB, i got error To fix error, remove the file

MariaDB

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

MySQL

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,

MySQL

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

MariaDB DEFAULT NULL ERROR 1064 (42000)

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

MySQL

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

MySQL 8 apt Error The following signatures were invalid

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

MySQL Got error 24 Too many open files

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