views:

38

answers:

1
mysql> start slave;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> show warnings;
+-------+------+--------------------------+
| Level | Code | Message                  |
+-------+------+--------------------------+
| Note  | 1254 | Slave is already running |
+-------+------+--------------------------+
1 row in set (0.00 sec)

mysql> show slave status\G;
Empty set (0.00 sec)

ERROR:
No query specified

Why???? I did a fresh install of MYSQL. I edited My.cnf. And I restarted the damn things.

This is my slave MY.CNF

server-id               = 2
log_bin                 = /var/log/mysql/mysql-bin.log
master-host     = 68.13.41.41
master-user     = replication
master-password = slave
master-port     = 3306

This is my master MY.cnf:

server-id               = 1
log_bin                 = /var/log/mysql/mysql-bin.log
binlog-do-db=fal

I did this on master:

GRANT ALL ON *.* TO 'replication'@'theip' IDENTIFIED BY 'slave';
A: 

I fixed it by running commands in the MYSQL thing (instead of relying on the config)

TIMEX