Mysql Configuration

[mknjhill]

Hey everyone. I have my Directadmin license tied to a In house only webserver. I'm working with an old script on one account and it requires STRICT_TRANS_TABLES and ERROR_FOR_DIVISION_BY_ZERO removed from the mysql configuration file.

I'm not able to find the correct my.cnf file apparently.
anyone have any ideas on how to properly add/edit my mysql configuration to 'sql_mode='?

Thanks.

 

[mknjhill]

directadmin	1.679
httpd	2.4.63
dovecot	2.4.1
exim	4.98.2
pure-ftpd	1.0.52
mysqld	5.7.44
named	9.18.30

 

[zEitEr]

anyone have any ideas on how to properly add/edit my mysql configuration to 'sql_mode='?

Hello,

Usually it is /etc/my.cnf updated over ssh, or directadmin interface.

Check:

- https://docs.directadmin.com/other-hosting-services/mariadb-mysql/general.html#where-is-my-my-cnf
- https://docs.directadmin.com/other-hosting-services/mariadb-mysql/general.html#how-to-optimize-mysql
- https://docs.directadmin.com/operat...naging-with-ssh.html#managing-server-over-ssh

 

[DrWizzle]

I'm using Ubuntu 24.04, and MariaDB. Not sure what you're using. I don't think DA supports a per user custom my.cnf

On my setup, the file /etc/mysql/my.cnf is the file to edit if you need to edit a my.cnf file. Adding these lines removes the STRICT_TRANS_TABLES and ERROR_FOR_DIVISION_BY_ZERO

#nano /etc/mysql/my.cnf

add at the bottom:

[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER

#systemctl restart mysqld

Check your database and it should appear like this:

 

[DrWizzle]

Hello,

Usually it is /etc/my.cnf updated over ssh, or directadmin interface.

Check:

- https://docs.directadmin.com/other-hosting-services/mariadb-mysql/general.html#where-is-my-my-cnf
- https://docs.directadmin.com/other-hosting-services/mariadb-mysql/general.html#how-to-optimize-mysql
- https://docs.directadmin.com/operat...naging-with-ssh.html#managing-server-over-ssh

I keep forgetting about DA's File Editor on the Admin panel. Probably much quicker than spinning up a terminal as well

 

[zEitEr]

I keep forgetting about DA's File Editor on the Admin panel. Probably much quicker than spinning up a terminal as well

SSH terminal is also available for admins, if no-legacy license is used

 

[mknjhill]

I'm using Ubuntu 24.04, and MariaDB. Not sure what you're using. I don't think DA supports a per user custom my.cnf

On my setup, the file /etc/mysql/my.cnf is the file to edit if you need to edit a my.cnf file. Adding these lines removes the STRICT_TRANS_TABLES and ERROR_FOR_DIVISION_BY_ZERO

#nano /etc/mysql/my.cnf

add at the bottom:

[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER

#systemctl restart mysqld

Check your database and it should appear like this:

View attachment 9100

Thank You! That fixed me up..