How to Disable MySQL 7 "Strict Mode" on an Ubuntu 20.04 VPS

uaemasti

Hi Dear,

I install aaPanel on my VPS server with ubuntu 20.04 and I install my PHP script but I can't publish my data through my website panel so when I check there is enable strict mode on the database so please help me how can I disable it through my aaPanel or via SSH?

Thanks

sirfpsycho

uaemasti click on mysql>configuration> find the line sql-mode or sql_mode and remove the part strict-mode and save and restart mysql.

aapanel_power

sirfpsycho Hello, you can see if your profile here has
strict-mode configuration, delete it if you have it, thank you for your answer!

uaemasti

Hello,

sirfpsycho and aapanel_power bundle of thanks I got it and I fix this issue now working fine really I am new on VPS and I install aapnel really I am so happy with this panel.

Thanks