In this article I’m explaining the usage of a smart command-line tool “mytop.” Which is similar in look to the basic resource monitoring tool “top.” By using this command, you can monitor the MySQL queries lively. There are a lot…
MySql
List all MySQL databases from Linux command line
Is it possible to get databases details from server command line? Yeah!! if there is a way to list and sort out the database details from server CLI (command line interface), it’ll speedup your troubleshooting procedure. We can use the…
Databases showing 0MB in cPanel
OMG! My databases got zero size 🙁 The databases in cPanel aren’t showing its actual size, but it contains tables and contents. There is an option in cPanel configuration to include MySQL databases disk usage. We can simply enable this…
How to install MariaDB in cPanel CloudLinux based server
MariaDB is an enhanced drop-in replacement for MySQL. Latest stable version of MariaDB is 10.0. First of all, we need to take the backup of all the databases in the server and then we can safely proceed with the MariaDB…
Upgrade MySQL and MySQL Governor in cPanel CloudLinux based server via command line
MySQL governor is a sofware to monitor and restrict MySQL resource usage in a CloudLinux based server. MySQL is an open source RDBMS (Relational Database Management System) and its using the SQL Language(Structured Query Language). A database is a structured…
[Solved] “Ftp connection refused” error in Kloxo
If you are getting “Ftp connection refused” error in Kloxo, then you can follow this post. Error: ftp xxx.xx.xx.xx ftp: connect: Connection refused ftp> # netstat -plan | grep :21 Solution: Make sure you are running pure-ftpd service. If so,…
How to change MySQL root password from Kloxo Panel
You can change MySQL root password from Kloxo panel by following the steps below: Step 1 : Login to Kloxo control panel, Click here for “How to access kloxo control panel” IP.ADDRESS:7778 Step 2 : Do the following steps: Admin…