All articles in Virtual Private Servers

We’ve already covered basic monitoring of MySQL on cPanel/WHM servers. However, sometimes it may be necessary to perform advanced in-depth analysis of what’s going on behind the scenes of MySQL operations. Right, when mytop is not an answer – innotop comes to play. What is innotop innotop is a MySQL . . . Read more

You’re probably already aware of a great alternative to native ‘top’ utility called ‘htop’. In short – it provides a better top-like experience. Now what if one needs a similar tool for MySQL specifically? The answer is called ‘mytop’. Background cPanel does not provide any tools for monitoring MySQL. In . . . Read more

In some cases you may need to enable non-localhost connections to MySQL database. It’s easy to do on any Linux-based VPS or dedicated server. Follow these steps: 1. Connect to your server via SSH as root: 2. Log into MySQL as root: mysql -uroot -p Enter the following command: GRANT . . . Read more