Monitoring Queries in MySQL in real time
Posted inLinux SQL

Monitoring Queries in MySQL in real time

Monitoring queries that are causing system bottlenecks is a common and extremely useful task. MySQL comes by default with the mysqladmin utility, which allows you to perform administrative tasks such…
MySQL: Recovering the root password
Posted inLinux SQL

MySQL: Recovering the root password

Accidents happen. Losing or forgetting a password is not uncommon. In this brief guide, we'll teach you how to change the MySQL root password on Linux servers. First of all,…