I'm trying to delete all connections to a database, because I made a mistake and forgot to place mysqli_connect($con) in a number of pages.
On StackOverflow I found the following question: How do you kill all current connections to a SQL Server 2005 database?
However, when I use the following query, I get an error in phpMyAdmin:
ALTER DATABASE `dotnettv_db` SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
Error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[`dotnettv_db`] SET SINGLE_USER WITH ROLLBACK IMMEDIATE' at line 1
I would appreciate it if you could tell me what I am doing wrong. Thanks!
EDIT: This is what I am getting in phpMyAdmin: http://oi43.tinypic.com/2v0k8rc.jpg - one process, around 50 connections. The biggest problem is with the traffic associated with these connections - 3.3 Terabytes and counting in 6 days: http://oi41.tinypic.com/2lj6n9t.jpg