0

Is there a way to change the SQL_MODE for only one user in MySQL? I know I can change the SQL_MODE for a connection by executing the following query

SET SQL_MODE = '';

But the idea here is to change it always without having to set it every time. I am using a third party program to insert data into MySQL Server. So there is no way I can execute queries like changing the SQL_MODE every time. this is way I am looking for an option where I can permanently set it for a pacific user without having to change the entire server settings.

Thanks

Mike
  • 2,735
  • 11
  • 44
  • 68

0 Answers0