Most often, we come across the WISECP MySQL Strict Mode Issue due to the rules in SQL mode definitions.

As part of our Server Management Services, we assist our customers with several MySQL queries.

Today let us see how we can resolve this issue.

WISECP MySQL Strict Mode Issue

Since MySQL version 5.7+, there came a few strict mode rules as standard for SQL mode definitions. At times, they may interfere with the operation of the software.

Generally, WISECP automation is not compatible with the “SQL Strict Mode” rules.

Therefore, we need to remove the strict mode rules from the “SQL Mode” definitions of the MySQL server.

Moving ahead our Support Techs recommend the steps below regarding how to perform this.

1. Initially we access the server via SSH or SFTP with root authority to open the /etc/my.cnf file.

It is important that these processes must be provided by people who are authorized to access the server root.

2., Then to the bottom of the file “my.cnf” we add the following definition:

sql_mode=”NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

In case the server does not accept “, we can define without “.

And again if this doesn’t work, we can just define it as sql_mode=

However, make sure the definition we add is under the [mysqld] line.

If the file does not contain the line [mysqld], we can add it manually.

3. Finally we restart the MySQL server.

This should resolve the Mode Issues.

[Need further assistance? We are here for you]

Conclusion

In short, we saw how our Support Techs resolve the strict node rule issue for our customers.