Mysql 5 and max connection value.

[ozgurerdogan]

I created a vps but user need many max connection. Creating my.cnf does not help and and causes mysql startup problems. Also loginging via pypmyadmin as da_admin user and set max connections there (default is 151) does not help because restarting mysql makes it default again as 151.

So what is the correct way of setting mysql max connections (also other mysql confs) for mysql MySQL 5.5.31

 

[chatwizrd]

Change the setting in /etc/my.cnf and restart mysql. Add the correct setting if it does not exist in the file.

 

[DirectAdmin Support]

Make sure it's under the [mysqld] section, related:
http://help.directadmin.com/item.php?id=103

John