We have a delphi made application that uses mysql 4.1.15
We will first get it upgraded to Mysql 5 in some month
All users are logged onto mysql using root (this happens in the background coding)
When about 30 are logged in we get a ERROR 1040 : Too Many Connections
In my.ini file i have set:
max_connections = 500
I still get the problem
I have read some more about max_user_connections but not sure if this can be used with MYSQL 4.1.15?
I tried to to add the follwing statement:
SELECT max_user_coennections FROM mysql.user
WHERE user='db_user' AND host='localhost';
Hoping to see what the max_user_connection setting was but it return the error
ERROR 1054: Unknown column 'max_user_connections' in 'field list'
My question is
Should i be able to use 'max_user_connection' with MYSQL 4.1.15?
If not is there a work around I can use