Skip to content

Mysql Troubleshutting

ERROR 2026

State: 

mysql -h localhost -P 3306 -u root -p
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it

Solution 

mysql -h localhost -P 3306 -u root -p --skip-ssl

ERROR 1118

MariaDB 11.4

gunzip < database.mysql.gz | mysql
ERROR 1118 (42000) at line 492: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
Solution 1 
# add to config file:
innodb_strict_mode = 0

Solution 2 - CORRECT Review and change table fields for decrease row size.