does any one knows hot to set up mysql to higher connections, i am getting too many connections errors

i need to set up max_connections = 1000

appreciated
Abner

in your my.cnf file, under the mysqld groups settings, this is where you would setup your max_connections = 1000 then restart MySQL to take affect. the my.cnf is normally located in the /etc folder by default.

Mickalo

thanks for your reply mikalo, but i get this

[root@plesk ~]# /etc/my.cnf
-bash: /etc/my.cnf: Permission denied

is that how i should do??

thanks
Abner

if your logged in as root, you shouldn't get that error. But to edit the file, use either pico -w or nano -w to edit the file, IE: pico -w /etc/my.cnf

Mickalo

if that still doesnt work ls -l /etc/my.cnf and paste it here

thanks alot guys, some how the problem was with php, i had to recompile php, and now it runs fast and no errors of too many connectios, before i was getting over 3000 guests on my adminpanel. now it only show about 500 at time average.

thanks again

Abner

What server are you using? Ram, processor etc?