SOLVED Disable MySQL Strict Mode?

[kiopeed]

welcome all
please how i can Disable Strict situation php from whm
Since all my work has been disrupted
Due to the activation of the strict situation
With install cpanel today
Special request and please from the company cpanel.net Stop complications
All users are not experts
I hope to solve this problem and all my work are stopped

please help

 

[Infopro]

Could you please provide a few more details about the issue you’re facing?

 

[kiopeed]

All my work have been disabled due to activation mySQL Strict Mode
i need Disable mySQL Strict Mode
please help me i need stop this from whm
I am not an expert in executing command .
I hope the solution from whm

 

[Infopro]

See if this post is of use to you:
Trying to disable MySQL strict mode

 

[kiopeed]

My language is not English and I am translating you from Google
As much as the volunteer
To show you the correct translation
I do not understand what I sent this
I do not know how to apply this
Is there a simplified explanation from you
Or video please

Why did she cpanel.net Activating this disturbing situation
why cpanel why why why
my work is stop

 

[Infopro]

You'll need to do as explained in that thread, edit this file: /usr/my.cnf
Add this to it (on the last line as suggested): sql_mode=""
Restart MySQL for the system to see the change in that file.

 

[kiopeed]

Sorry I could not find this file my.cnf
In the track /usr/my.cnf
Look at this picture Attachment

Do I put this file manually
Or is located elsewhere
And sorry to bother you

 

[cPanelMichael]

Hello @kiopeed,

Can you let us know the contents of the /etc/my.cnf file on this system?

Thank you.

 

[kiopeed]

yes mr. @cPanelMichael
this file from /etc/my.cnf
I have done this
It was restarted whm

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]
performance-schema=0
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

performance-schema=0
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

performance-schema=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
default-storage-engine=MyISAM
innodb_file_per_table=1
max_allowed_packet=268435456
open_files_limit=10000
sql_mode=""

i put the code sql_mode=""

This does not work

 

[cPanelMichael]

i put the code sql_mode=""

This does not work

Hello @kiopeed,

Did you restart MySQL after making the change? You would do so with the following command:

/scripts/restartsrv_mysql

Once you do that, let us know the output from the following command:

mysql -e 'select @@GLOBAL.sql_mode;'

Thank you.

 

[kiopeed]

wowwwwwwww wow
Very coooooooooooooooooooooooooool
alove mr.cPanelMichael and I am very thankful to you
and thank you mr.Infopro and I am very thankful to you
i done thank you very mutch for help very very thank you .
thank you very mutch