MySQL

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 …

MySQL is one of the most widely used open source relational database management tool (RDMS) based on structured query language (SQL). The most common error received while installing MySQL on the server and starting/restarting the MySQL service on a *nix server is: [ERROR] Can't start server: Bind on TCP/IP port: Address already in use [ERROR] Do you already have another …

MySQL root password is important if you want to access phpMyAdmin, secure MySQL command prompt access, etc. In case one forgets the MySQL root password or wants to set root password, following steps should help to achieve the same. 1) Stop the MySQL Server: /etc/init.d/mysql stop/etc/init.d/mysql stop or /etc/init.d/mysqld stop/etc/init.d/mysqld stop 2) Start the MySQL configuration: mysqld --skip-grant-tables &mysqld --skip-grant-tables …

The following MySQL error might occur if you are using MySQL replication and binary logs. mysql> show binary logs; ERROR 1381 (HY000): You are not using binary logging Solution: I have already discussed the same problem here. If you are still facing issues then it might be possibility that problem is with MySQL my.cnf file. The my.cnf file structure for …

In MySQL replication, you setup master and slave MySQL server. On master server, while checking the master status, you might end up with following error message: 1 2 3 4 mysql> SHOW MASTER STATUS; Empty set (0.00 sec) mysql> show binary logs; ERROR 1381 (HY000): You are not using binary loggingmysql> SHOW MASTER STATUS; Empty set (0.00 sec) mysql> show …

Sometimes you need to change the timezone used by MySQL database for some  specific applications or globally. The below steps will guide you to change the MySQL time zone: 1) Check time_zone* tables in mysql database. If it is empty then insert Zone Info data using following command  mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root …