Mysql strict Mode centos 7

By default (Cpanel centos 7) enable Mysql strict mode

You can check from SSH by this command :

 

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

 

The result :

+--------------------------------------------+
| @@GLOBAL.sql_mode |
+--------------------------------------------+
| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+--------------------------------------------+

 

If you familiar with Cpanel Mysql configuration location is /etc/my.cnf

BUT in centos 7, the configuration for strict mode is from this location = /usr/my.cnf

NOW you have to edit /usr/my.cnf to

sql_mode=""

After that :

systemctl restart mysql.service

 

 

yum processes hangs

1. Kill all RPM and yum processes

ps aux | grep rpm

 

2. Kill command

kill -9 pid-id

 

3. Kill all up2date

ps aux | grep up2date

 

4. Kill command up2date

kill -9 pid-id

 

5. Remove any RPM lock files

rm -rf /var/lib/rpm/__db*

 

6. Rebuild the rpm database

rpm --rebuilddb

 

7. Cleaning the yum

yum clean all

 

NOW YOU CAN RUN

yum update -y