Portal Home > Knowledgebase > Articles Database > ENSIM mySQL Error - HELP!
ENSIM mySQL Error - HELP!
| Posted by mark1hos, 11-21-2007, 09:35 AM |
| We have created an account on our dedicated server in the Ensim appliance, however, when trying to add a database it fails and says;
mysql - Enable service
( ERROR ):Mysql error: (1226, "User 'root' has exceeded the 'max_connections_per_hour' resource (current value: 1)")
Can anyone help on how to fix this?
Thank you.
|
| Posted by Srv24x7, 11-21-2007, 10:20 AM |
| Hi
You need to increase the current value from 1 to more. Check the setting in /etc/my.cnf file for that and restart mysql service
|
| Posted by Steve_Arm, 11-21-2007, 10:21 AM |
| I'm not familiar with ENSIM, but that isn't an error moreover a security measure.
Maybe you should create a new user that has privileges on th ENSIM database only and not use root. I'm guessing.
|
| Posted by mark1hos, 11-21-2007, 10:48 AM |
| Hi, there is not even that option/variable in the my.cnf, in fact there are only 5 lines of variables.
|
| Posted by Srv24x7, 11-21-2007, 11:35 AM |
| that value is for user specific , you may have to check the limits set for the new user while creating the account.
|
| Posted by david510, 11-21-2007, 08:46 PM |
| Check for the values in the my.cnf file.
max_connections
max_user_connections
If there are small values, try increasing them. You can have a current process status of mysql with the following command.
mysqladmin -i2 processlist.
|
Add to Favourites 
Print this Article
Also Read
