I guess you can do this in your my.cnf. Depending on your distribution, it's either /etc/mysql/my.cnf or /etc/my.cnf.