X

Select Your Currency

Indian rupee $ US Dollar
X

Select Your Currency

Indian rupee $ US Dollar
USD

How To Resolve MySQL Strict Mode Issue ?

HomepageArticlesWebsite SecurityHow To Resolve MySQL Strict Mode Is...

Enabling strict mode can help ensure data consistency and accuracy in the database, but it may also require modifications to existing applications to comply with the stricter validation rules. It's essential to carefully consider the implications before enabling strict mode, especially in environments where legacy applications or third-party software may not be compatible.

To resolve MySQL strict mode issues, you can follow these steps:

  1.  Login In to Your WHM Panel 
  2. Open Terminal
  3. Type Command  nano /etc/my.cnf  Press Enter Key
  4. scrowl down and type their  sql_mode=""
  5. Press CTRL+O key same time
  6. Press Enter Key
  7. Press CTRL+O Key
  8.  Type   /scripts/restartsrv_mysql  And Press Enter Key
  9. SQL server Will Restart & Issue has been fixed.

 


Top