How to Fix Error Forcing close of thread 310 user: 'root' in MySQL?

Problem Statement

MySQL server keeps on shutting down.

Error Message

C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Forcing close of thread 310 user: 'root'

Solution

You can resolve this issue by increasing maximum connection to MySQL server.

  1. Login to MySQL server and navigate to /etc/my.cnf file.
  2. Find & increase max_connections value and save the my.conf file.
  3. Restart MySQL service.

  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

How to Administrate MySQL Server with mysqladmin commands?

By using mysqladmin commands, you can perform basic MySQL tasks very easily, such as...

How to Fix MySQL Error "The server quit without updating PID file"?

MySQL server plays a vital role for your Linux Server. It runs all of your website's databases,...

How to enable the slow query log in MySQL?

Slow MySQL queries can significantly lower down the performance of your web application and eat...

How to Backup and Restore MySQL Databases From Command Line?

mysqldump is an easy and quick tool to create backup of MySQL databases. It creates a dump file...

Fix :: Unable to login at phpMyadmin after revoking MySQL root user

Problem Statement I am not able to login into phpMyadmin after revoking root user. Solution...