In phpmyadmin, perform the following: select @@GLOBAL.sql_mode Copy this result and remove STRICT_TRANS_TABLES. Then perform the following: set GLOBAL sql_mode=’ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’
Archive for April 2021
Ubutu View da admin Run ssh: cat /usr/local/directadmin/conf/mysql.conf Run mysql: mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,’ONLY_FULL_GROUP_BY’,”));
Q When cding into one of my directories called openfire the following error is returned: bash: cd: openfire: Permission denied A sudo su cd directory Then, to exit out of “super user” mode, just type exit.