IT Knowledge Base

Technical Repository

HowTo: Enable Remote Connections to MySQL

Open the the MySQL configuration file: nano /etc/mysql/my.cnf and comment out the following line, save the file and then restart the MySQL service. #bind-address = Restart the MySQL service. service mysql restart OR you can run the following command to comment out the same line and then restart the MySQL service. sed -i ‘s/^bind-address.*/#bind-address […]

Read More

HowTo: Force a SQL Server Database Offline

I ran into a problem where I needed to restore a database from backup but was unable to take the database offline due to existing connections. The task would just stay there processing and after an hour, I had enough. I wanted to force the database to go offline regardless of any connections so I […]

Read More