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>

Install XRDP in Centos 7

rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm yum update yum groupinstall "GNOME Desktop" ...