[SOLVED] mysql_mode="" works but not when using mysql command line
by Red Squirrel from LinuxQuestions.org on (#5CC8S)
In Debian there is this weird thing where any commands to a database that does not have explicit default values for every field will fail. I found that you can add
mysql_mode="" in the /etc/mysql/my.cnf
That seems to work, however when using the command line mysql it errors out saying it's an unknown command.
Is there a way to get this to work properly? I use phpmyadmin to manage stuff after fighting with the fact that they disabled the root account from being able to login to it... but sometimes I do need to use mysql command line directly.
EDIT:
Further googling and I found an answer. Have to put [mysqld] header before the command in the /etc/my.cnf file.
mysql_mode="" in the /etc/mysql/my.cnf
That seems to work, however when using the command line mysql it errors out saying it's an unknown command.
Is there a way to get this to work properly? I use phpmyadmin to manage stuff after fighting with the fact that they disabled the root account from being able to login to it... but sometimes I do need to use mysql command line directly.
EDIT:
Further googling and I found an answer. Have to put [mysqld] header before the command in the /etc/my.cnf file.