1432-无法创建联合表.数据源连接字符串％s的格式不正确 [英] 1432 - Can't create federated table. The data source connection string %s is not in the correct format

问题描述

在将数据从远程服务器联合到本地计算机时遇到问题. 当我尝试执行

I am having issue in federating data from remote server into my local machine. My Remote table is MyISAM , when i tried to execute

CREATE TABLE `wtc_test (
    `wtc_companyworkday_id` bigint(20) DEFAULT NULL,
) ENGINE=FEDERATED  DEFAULT CHARSET=latin1
CONNECTION='mysql://pentah:0p@l@192.1**.*.*:3306/replica/wtc_test';

我收到以下错误:-

[Err] 1432 - Can't create federated table. The data source connection string 'mysql://pentah:0p@l@192.1*.*:3306/replica/wtc_test' is not in the correct format

我看到的原因是，我的密码包含'@'字符，有人可以帮助我.

The reason i see is, my password contains '@' character, can some one help me .

推荐答案

MySQL用户名/主机中的通配符为%，而不是*.除此之外，您指定的是目的地，而不是创建用户或授予特权时的来源.因此，最好指定一个主机名或MySQL数据库服务器的静态IP.

The wildcard in MySQL usernames/hosts is %, not *. Apart from that, what you specify there is the destination, not the source like when you create a user or grant privileges. So you better specify a hostname or the static IP of your MySQL database server.

并尝试使用"键入您的密码，因为单引号将终止连接字符串.

And have a try with " around your password, as single quotes would terminate the connection string.

CONNECTION='mysql://pentah:"0p@l"@yourHost:3306/replica/wtc_test';

但是，如果我是您，则只需更改密码即可.密码使用最奇特的符号是不安全的，它的长度很重要.看看此.

But if I were you, I would simply change the password. A password is not safe by using the most exotic symbols, it's the length that matters. Have a look at this.

这篇关于1432-无法创建联合表.数据源连接字符串％s的格式不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！