Connecting Tech Pros Worldwide Help | Site Map

max_connections

  #1  
Old July 23rd, 2005, 07:25 AM
Jay donnell
Guest
 
Posts: n/a

Hi all,

I can't seem to change my max_connections variable in mysql.
If I try to do it through the client I get this.
mysql> set global max_connections=500;
ERROR 1064: You have an error in your SQL syntax near
'max_connections=500' at line 1

Then put
set-variable = max_connections=300
in the my.cnf and restarted mysql.

I did
show variables;
and I get
| max_connections | 100

Why aren't these attempts working?

Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Obtaining parameter MAX_CONNECTIONS through the API P answers 13 May 2nd, 2006 11:15 AM
max_connections doesn't change Jan Josefowicz answers 1 April 25th, 2006 10:45 PM
How do i change max_connections and wait_timeout variables globally (for good) Sami answers 2 July 20th, 2005 01:16 AM
How do i change max_connections and wait_timeout variables globally (for good) Sami answers 0 July 20th, 2005 01:15 AM