Connecting to Microsoft SQL Server using jTDS
Here's how we are able to connect to Microsoft SQL Server using the jTDS JDBC driver. This is a local development environment using a newly installed SQL Server Express 2012.…
Automated MySQL Backup
Here's one way to create an automated MySQL backup process. 1. Login as root. 2. Create the MySQL option file /root/.my.cnf with the following contents. This will allow you to…
Cannot Connect Remotely to a New MySQL Installation
We recently installed MySQL on an Ubuntu box for testing purposes. Setup was done by simply running the following as root. Here's what we did so we could connect remotely…