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,…
Add Column to Existing MySQL Table
Posted inSQL

Add Column to Existing MySQL Table

To add the"age" column of type "int (11)" to the"student" table, simply use the following SQL query: ALTER TABLE aluno ADD idade int(11) the above query will add the column"age"…