MySQL Add federated engine implements Dblink remote table access

Check to see if the MySQL database federated engine is turned on.

Show engines;

If the federated is not turned on, add federated to mysqld in MySQL configuration file my.cnf. The user who adds the remote Access database in the remote database creates the table "Work_step_apply_check '" (' ID ' varchar () ' Not NULL DEFAULT ', ' client_no ' varchar (23 Default NULL, ' work_id ' varchar (all) default Null,primary KEY (' ID ')) engine=federated connection= "Mysql://cx:[email Protected]_date:3306/order/work_step_apply_check "; After the table is created, the query adds table data with or without an error, check the user permissions or the user who added the connection is correct.

MySQL Add federated engine implements Dblink remote table access