Category: MySQL
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 MoreGet the MySQL database schema using SQL
A complete database schema can be retrieved using the following MySQL statement from the information_schema database:
Read MoreMove 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 MoreTomcat 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