CREATE TABLE `test_fed` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `data` varchar(128) DEFAULT NULL,

  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

  PRIMARY KEY (`id`)

) ENGINE="FEDERATED" DEFAULT CHARSET=latin1

CONNECTION='mysql-57'

;

ERROR 1434 (HY000): Can't create federated table. Foreign data src error:  database: 'test'  username: 'app'  hostname: '127.0.0.1'

SQL> show warnings;

+---------+------+-----------------------------------------------------------------------------------------------------------------+

| Level   | Code | Message                                                                                                         |

+---------+------+-----------------------------------------------------------------------------------------------------------------+

| Error   | 1434 | Can't create federated table. Foreign data src error:  database: 'test'  username: 'app'  hostname: '127.0.0.1' |

| Warning | 1030 | Got error 1 "Operation not permitted" from storage engine FEDERATED                                             |

+---------+------+-----------------------------------------------------------------------------------------------------------------+