I changed max_connection value is 1 / hour in mysql server.than I close the mySql workbench and I again try to open.It shows the above error what can I do can any one tell how to fix this.
Thanks in advance
2
-
Did you check the points mentioned in the error? They kind of sum up all the possible issues ;)Aakash– Aakash2014-12-06 07:31:57 +00:00Commented Dec 6, 2014 at 7:31
-
@AsG how can i log in the same connection if i tried to open new connection it is all so says access denied.KVK– KVK2014-12-06 07:32:58 +00:00Commented Dec 6, 2014 at 7:32
Add a comment
|
3 Answers
my problem is solved using following way
Actually what i did wrong is i set max_connection_per_hour=1 in my workbench settings.
that's why i can't open the connection for some period of time .now i solved using terminal with the use of following command
$ mysql -u root -p
then i just enter the password for root user than i use the following command
mysql>$ grant usage on . to 'root'@'localhost' with max_connections_per_hour 0;
after than i can open my connection with out any problem.
i tried this command many times but after one hour only it works for me before that it gives me an error
Comments
You need to give it a reasonable value. To do this login with the sa account. Without any other connections you should be able to do this Then set the parameter to a reasonable value.
Comments
Try to restart the mysql server, from command line as root do mysqld restart. Restarting workbench does not kill the connections.
2 Comments
KVK
how to change the max-connection value with out open a connection
Aakash
Refer: dev.mysql.com/doc/mysql-monitor/2.3/en/… You need to restart the server after editing to apply.