MySQL Database Character Set and Collation
To change MySQL database char set and collation, run ALTER DATABASE DB_NAME_HERE CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; To usee current…
mysql
MySQL cannot connect via localhost
On an Apache server, MySQL can’t connect when you use localhost, but it work when you chane to IP address 127.0.0.1 When…
Install LAMP Server on Ubuntu/Debian
To install LAMP (Apache, MySQL, PHP) on Ubuntu/Debian web server, run apt-get install lamp-server^ This use meta package install LAMP. If you…
EasyEngine Connect to MySQL Database
To Find MySQL root password on EasyEngine, run cd /opt/easyengine/services && docker-compose exec global-db bash -c ‘echo $MYSQL_ROOT_PASSWORD’ Or cat /opt/easyengine/services/docker-compose.yml |…
MySQL ERROR 1193 Unknown system variable GTID_PURGED
When restoring MySQL backup taken on Amazon RDS, i get error root@PRD-50ml:~# mysql sok_db2 < db.sql ERROR 1193 (HY000) at line 24:…
MySQL create database
To create a database, you can use create database DB_NAME; Example To create a database with specific charset use create database DB_NAME…
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 cat /usr/local/vesta/conf/mysql.conf
MySQL 8
MySQL 8 use caching_sha2_password as the default authentication method. Many MySQL clients still do not support this method. If you need to…
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…
MySQL server has gone away
When restoring a MySQL database, i get error “MySQL server has gone away”. # mysql -u root -p’serverok123′ sok_wp < backup.sql ERROR…
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…
Ubuntu 18.04 MariaDB 10.2 Too many open files
On my computer running Ubuntu 18.04, MriaDB stopped working. PHP application i run on my computer failed with error SQLSTATE[42S02]: Base table…