hi ,

can I please know how to change a system variable ?
I gave a query like this :

set GLOBAL max_connections=500;

but this is not working out . The mysql front end that I use reports that I have an error in this statement . Am I missing any thing here ?

Selin

should max_connections not be

MAX_CONNECTIONS or $max_connections

Thanks pal,
I did try this one but it didn't work out . I am able to view these variables but I have a requirement that needs me to change the max_connections variable ..
Is it possible for me to directly go and edit it in some file ?

Hi,

You could edit your /etc/my.cnf file (you may need to create this), adding something along the lines of (under the [mysqld] group of the file)...

[mysqld]
max_connections=500

Just change the 500 value to whatever you want.

http://www.mysql.com/doc/en/Option_files.html

Cheers,
Ash

Hi,
It worked . Thanks a lot Pal .
Selin