Enable MySQL Remote Access

Enable MySQL Remote Access

Remote access to the MySQL database server is usually disabled for security reasons. Yet, there are occasions when you require remote access to a database server from either home or a web server.  This article will explain how to setup a user on your MySQL server to...
How to Kill MySQL Queries

How to Kill MySQL Queries

MySQL queries can sometimes be long-running and may prevent transactions from accessing necessary tables to complete a request. This will put your users on hold. In order to kill these long-running queries, you must access the environment’s MySQL database. Correcting...