can not connect database server in mysql?
KVK
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
KVK
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
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: try/catch jdbc java can't put jpanel inside jframe
- Next: Yii2:Does login,signup & password reset forms work together in single view
Related
Related Related
- 1
can not connect database server in mysql?
- 2
PHP - Can't connect to a remote MySQL database
- 3
Can't connect to MySQL database using MySQLConnection
- 4
Can't connect to MySQL database - PHP
- 5
Can`t connect MySQL database in phpMyAdmin by python
- 6
Error: Can't connect to MySQL database
- 7
Can't connect to Database-MySQL
- 8
Java can't connect to mysql database
- 9
MySQL workbench - Can't connect to a specific database
- 10
Can't connect to Database-MySQL
- 11
Can not connect to database sonarqube with mysql in docker
- 12
Can't connect to MySQL server on 'domain' (111)
- 13
Can't startup and connect to MySQL server
- 14
Can't connect to MySQL server on 'localhost' (111)
- 15
Can't connect to Remote MySQL Server (10061)
- 16
Can't connect to MySQL server on 'domain' (111)
- 17
MySQL Can't Connect to External Server
- 18
Can't connect to Mysql server with Laravel 5.2
- 19
JDBC - can't connect remotely to MySQL Server
- 20
Can't connect to local MySQL server
- 21
Can't connect to Mysql server with Laravel 5
- 22
Can't connect to SQL Server database server on port 1433
- 23
can AWS Lambda connect to RDS mySQL database and update the database?
- 24
Elastic Beanstalk Application Can't Connect to Database but Server Can
- 25
Failed to connect to a remote MySQL database via an Ubuntu server
- 26
How to connect to a remote MySQL from an Azure SQL server/database
- 27
How do I Connect to My Database Server Using MySQL Workbench?
- 28
How to connect to MYSQL database on server via Terminal on Macbook?
- 29
Can't start MySQL server (database corruption)
Comments