MySQL

MariaDB is an Open Source MySQL drop-in replacement. MariaDB provides a repository for various operating systems … Install MariaDB 10.3 on CentOS 7Read more

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 engine is not enabled or did not startRead more

When restoring a MySQL database, i get error “MySQL server has gone away”. # mysql -u … MySQL server has gone awayRead more

if you have cloud sevrer with less disk space, it is better disable MySQL bin log … Disable MySQL bin log on BitnamiRead more

MySQL 8 use caching_sha2_password as the default authentication method. Many MySQL clients still do not support … MySQL 8Read more

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

To create a database, you can use create database DB_NAME; Example To create a database with … MySQL create databaseRead more

When restoring MySQL backup taken on Amazon RDS, i get error root@PRD-50ml:~# mysql sok_db2 < db.sql … MySQL ERROR 1193 Unknown system variable GTID_PURGEDRead more

On an Apache server, MySQL can’t connect when you use localhost, but it work when you … MySQL cannot connect via localhostRead more

To change MySQL database char set and collation, run ALTER DATABASE DB_NAME_HERE CHARACTER SET = utf8mb4 … MySQL Database Character Set and CollationRead more