Tuesday, 1 October 2013

master status empty set 0.00 sec

Error :
mysql> SHOW MASTER STATUS;
Empty set (0.00 sec)

Soluton :
#touch /var/lib/mysql/mysql-bin.log
#vi /etc/my.cnf
log-bin = /var/lib/mysql/mysql-bin.log

save and exit.
#service mysqld restart
#mysql –u root –p    (login in mysql and run command)
mysql> SHOW MASTER STATUS;
+----------------+----------+--------------+------------------+
| File           | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+----------------+----------+--------------+------------------+
| mysql-bin.000001 |      107 | xyzdb        |                  |
+----------------+----------+--------------+------------------+
1 row in set (0.00 sec)

 mysql>

Reset Grace Period of Windows Server 2012 RDS

Error: the remote session was disconnected because there are no remote desktop license servers available to provide license in aws Solu...