MySQL

The category contains posts related to MySQL database.

Abhijit Sandhan June 25, 2014

[How To] Enable MySQL Event Scheduler status

The event scheduler in MySQL needs to be enabled for some applications to work flawlessly. In this case, a small…
Read More »
Abhijit Sandhan June 19, 2018

[Solved] Another mysqld server running on port: 3306

MySQL is one of the most widely used open source relational database management tool (RDMS) based on structured query language…
Read More »
Abhijit Sandhan May 7, 2014

[How To] Reset MySQL root password

MySQL root password is important if you want to access phpMyAdmin, secure MySQL command prompt access, etc. In case one…
Read More »
Abhijit Sandhan July 21, 2013

MySQL ERROR 1381 (HY000): You are not using binary logging [Resolved]

The following MySQL error might occur if you are using MySQL replication and binary logs. mysql> show binary logs; ERROR…
Read More »
Abhijit Sandhan October 26, 2015

MySQL replication problem: ‘show master status’ shows ‘Empty set (0.00 sec)’

In MySQL replication, you setup master and slave MySQL server. On master server, while checking the master status, you might…
Read More »
Abhijit Sandhan August 7, 2019

[How To] Update or Change MySQL Server Time Zone

In this article will, we will go through the various options to change or update the MySQL server database timezone…
Read More »