MySQL client does not use the port parameter

It will happen if you use localhost as the server address. The client will then use the Unix sockets. Use 127.0.0.1 instead. This issue is common when using SSL tunnels.

Read More

Get the MySQL database schema using SQL

A complete database schema can be retrieved using the following MySQL statement from the information_schema database:

Read More

Move and secure the MySQL data directory

By default, the data directory of MySQL is /var/lib/mysql. This can be a security issue, especially on a laptop. If your home directory is encrypted, you can easily secure you

Read More

Tomcat and MySQL benchmarks

Benkmarks made using a Tomcat and a MySQL database. These figures are provided to give you an idea of the performance you should expect. The tests were done in the

Read More