- Joined
- Mar 22, 2015
- Messages
- 16
- Points
- 3
How can I disable MySQL strict mode in WHM/cPanel or do I have to do so via ssh? I want to disables this to make a couple of applications work properly. How can I do that?
Thank you for your comments but we like to help members here instead of referring them to the documentation. Members are free to post any question they wish.I'm sorry but please make an effort and do a google search before asking these kind of questions. Please don't post everything that comes to your mind.
cp -rp /etc/my.cnf /etc/my.cnf.backup
cp -rp /usr/my.cnf /usr/my.cnf.backup
vim /etc/my.cnf
[mysqld]
sql_mode=â€NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIONâ€
:wq
vim /usr/my.cnf
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
sql_mode=â€NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIONâ€
service mysql restart
mysql -e 'select @@GLOBAL.sql_mode;'
Oh I'm all for helping and you would know that if you look at the history of my posts. What I clearly meant was for questions that have answers which are couple of lines long and thoroughly well documented already for several years now, its easier to find answers by a simple search. If OP had the questions as "I tried to disable it this way and it didn't work", then that's a different story and obviously anyone is free to post any question they have but in the long run it reduces the quality of the forum. My apologies if you or the OP felt offended in any way.Thank you for your comments but we like to help members here instead of referring them to the documentation.
Your question only asked how to do it, not how to check post doing it.I also want to check its status is ON or OFF on my hosting? how can your link answer that?
ForumWeb.Hosting is a web hosting forum where you’ll find in-depth discussions and resources to help you find the best hosting providers for your websites or how to manage your hosting whether you are new or experienced. You’ll find it all here. With topics ranging from web hosting, internet marketing, search engine optimization, social networking, make money online, affiliate marketing as well as hands-on technical support for web design, programming and more. We are a growing community of like-minded people that is keen to help and support each other with ambitions and online endeavors. Learn and grow, make friends and contacts for life.
The world's smartest hosting providers come here to discuss & share what's trending in the web hosting world!