Detect leak DB connections

How to detect leak connections to database in Java ? Of course, one can use particular monitoring tools like  Zabbix, but there is one more...

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:

Recently I have got such error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'someuser'...

Creating MySQL db and granting remote access

First of all use root login and password to run mysql:  mysql -u root -p Create database:  CREATE DATABASE dbname; Set it as acti...