[How To] Enable MySQL Event Scheduler status

mysql logo

The event scheduler in MySQL needs to be enabled for some applications to work flawlessly. In this case, a small change is required in the MySQL configuration file my.cnf. Steps: 1. Open my.cnf file in your favourite editor vi /etc/my.cnfvi /etc/my.cnf 2. Add following line event_scheduler=onevent_scheduler=on This will enable MySQL event scheduler on the server. 3. Restart MySQL service /etc/init.d/mysql …

Read More »

[How To] Allow htaccess override in Apache

apache logo

The htaccess override is by default disabled in the Apache Webserver. If you wish to enable htaccess override then small change is required in the Apache configuration file. 1) CentOS/RHEL: Backup the Apache configuration file "http.conf" Open the "http.conf" file in your favourite editor and look for the string "AllowOverride". Change it from "AllowOverride None" to "AllowOverride All". Make sure …

Read More »

[Solved] Another mysqld server running on port: 3306

mysql logo

MySQL service may start throwing errors as below while starting/restarting the MySQL service on a Linux server [ERROR] Can't start server: Bind on TCP/IP port: Address already in use [ERROR] Do you already have another mysqld server running on port: 3306 ? [ERROR] Aborting Looking at the error, it seems to be an issue with the MySQL port 3306. Solution …

Read More »