Skip to content

MySQL Troubleshooting

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 Add value to config file 
innodb_strict_mode = 0

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

MySQL 5.5.17, FreeBSD 10 Error mysql_install_db

Start from home directory: 

mysql_install_db
Got error: 
FATAL ERROR: Could not find ./bin/my_print_defaults
Solution 
cd /usr/local
mysql_install_db --user=mysql --ldata=/var/db/mysql

ERROR 1728 Cannot load from mysql.proc. The table is probably corrupted

Solution 

mysql_upgrade