I had a problem why trying Federated Engine.
Creating tables generate no problems but trying inserting raise an error as
Error 1429 (HY000): Unable to connect to a foreign data source: Can't
connect to MySQL server on '192.168.0.11' (111).
My OS is newly install with no firewall restriction on
CONNECTION = 'mysql://root:root@*stripped*:3306/Prelude_copy/test001';
Should be more like:
CONNECTION = 'mysql://root:stripped_password@localhost/penrepository/test001';
Just seems word if you're showing us your password is root but not host...
I ran your example just fine against localhost
