Author archives

SSH Tunnel to MySQL Database

If the MySQL database is running on a different machine (whether real or virtual) from the application, a connection through a network is needed. Assuming the network cannot be assumed to be secure, some kind of encryption is needed. Various alternatives exist, the main ones being and SSH tunnel, TLS connection, VPN. Of these, the …

Restarting MySQL replication after an error

It is easy for replication to be upset slightly, resulting in an error on the slave that stops it operating. It then gets behind the master and manual intervention is needed. Sometimes more substantial intervention is needed, but often bypassing the error is all that is needed. Before you start, check the situation by going …

Configuring MySQL for UTF-8

If you want to run MySQL primarily using UTF-8 then the configuration file my.cnf should contain the following directives: Check that things look right by running this command or by using phpMyAdmin to look at the “Variables” for the server, or some similar technique. which should give a result something like: Then try: which should …

Checking for problems in my.cnf

If you want to check for errors in the MySQL configuration file my.conf you can start the MySQL daemon from a command line with helpful parameters: will provide a lot of information about the available parameters. More useful for diagnosing problems is: which starts up MySQL with a lot of messages – including diagnostics for …

Design by Dave Mcpoland

Supported by Aussie Hosting