syntax error or access violation: 1118 row size too large; In this tutorial, you will learn how to fix/resolve syntax error or access violation: 1118 row size too large.
Syntax Error or Access Violation 1118 Row Size Too Large
Let’s use the following steps to fix/resolve syntax error or access violation: 1118 row size too large:
- Step 1 – Login to Your SSH Server
- Step 2 – Set InnoDB
- Step 3 – Stop and Start MySQL Server
Step 1 – Login to Your SSH Server
First of all, you need to login into your ssh server with username and password.
mysql -u root -p
Step 2 – Set InnoDB
Then execute the following command into your terminal:
SET GLOBAL innodb_strict_mode = 0;
Step 3 – Stop and Start MySQL Server
Finally, execute the following command into your terminal to stop and start your mysql server:
sudo systemctl stop mysql.service ---to shut it down sudo systemctl start mysql.service ---to try and start up and see the reason why it is not starting.
Conclusion
That’s it; In this tutorial, you have learned how to resolve/fix syntax error or access violation: 1118 row size too large.
