MySQL ERROR Unable to create or change a table without a primary key
When trying to restore a database backup to Managed DigitialOcean MySQL 8 database, i get following error root@ocp:~# mysql -u doadmin -p’BKwsQcqEGbSV3w’…
MySQL
ERROR 1118 Row size too large Changing some columns to TEXT or BLOB may help.
When restoring a MySQL database, i get error root@server:~# mysql production < db.sql ERROR 1118 (42000) at line 733: Row size too…
MariaDB ERROR 1524 Plugin unix_socket is not loaded
After upgrading MariaDB on Ubuntu server, i got following error root@server:~# mysql ERROR 1524 (HY000): Plugin ‘unix_socket’ is not loaded root@server:~# Users…
MySQL Initialize Data Directory
To initialize the MySQL data directory, run This will create /var/lib/mysql directory. For some versions of MySQL you can use Example See…
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 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…
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…