Tomcat on Debian and Ubuntu Linux – Fix Broken com.mysql.jdbc.Driver Connection | Getting java.lang.ClassNotFoundException: “com.mysql.jdbc.Driver” or similar error on Debian? Debian and Ubuntu provide complete Apache Tomcat packages including the java mysql connector. However, the default Tomcat config does not find the provided mysql connector! Here is a fix.
How to Create MySQL database and user | Here is quick way to create a MySQL database and user. This is useful for WordPress, Drupal, or other LAMP apps. Login to MySQL with the MySQL root password: $ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version:
Monitor MySQL Performance with mytop | mytop is an excellent app to monitor mysql performance. Let’s check it out! Firstly, install mytop: $ sudo apt-get install mytop Run mytop with tack tack prompt to have mytop prompt for the root mysql password: $ mytop –prompt Done! You can now monitor the number of mysql queries the server is processing as well