Error 1429 Hy000 Unable To Connect To Foreign Data Source
Contents |
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Newbie :: Unable to connect to foreign data source New Topic Advanced Search Unable to
Error Code 1429. Unable To Connect To Foreign Data Source
connect to foreign data source Posted by: Jacek Szymanski () Date: unable to connect to foreign data source access denied for user May 24, 2013 01:01PM Hi, I am trying to set up a FEDERATED table between two MySQL unable to connect to foreign data source host is not allowed to connect to this mysql server servers. I have created a separate user for this and enabled remote connection to the host server. On the client server (meaning on the one where I create the
Mysql Federated Table
FEDERATED table that connects to a table on the host server) I have enabled the FEDERATED enginge. From the client server I can connect to the host database if I run mysql -h myhost -u myuser -p. I can select from all tables without issue. Now the problem is that I can not access the data via the FEDERATED table. I can create it without problem and I get no error message. However, when I try SELECT * from myfederatedtable; then I get: ERROR 1429 (HY000): Unable to connect to foreign data source: Can't connect to MySQL server on '196.168.2.224' (110) What can be the reason for this? Best regards Jacek Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted Unable to connect to foreign data source Jacek Szymanski 05/24/2013 01:01PM Re: Unable to connect to foreign data source Peter Brawley 05/24/2013 01:55PM Re: Unable to connect to foreign data source Jacek Szymanski 05/25/2013 05:01AM Re: Unable to connect to foreign data source Peter Brawley 05/25/2013 01:07PM Re: Unable to connect to foreign data source Jacek Szymanski 05/25/2013 09:41AM Sorry, you can't reply to this topic. It has been closed. powered by phorum Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party. Contact Sales
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it http://forums.mysql.com/read.php?10,587287 works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top MySQL error 1429, federation up vote 1 down vote favorite 1 I use MySQL federation to let one MySQL database access another's data tables. This has worked fine for more than a year, but today (from out of the blue) a http://serverfault.com/questions/474116/mysql-error-1429-federation stored routine reported this MySQL error: Error Code: 1429. Unable to connect to foreign data source: Too many connections If I try to access the federated table with a SELECT, I get Error Code: 1030 Got error 1 from storage engine Moving on to the MySQL server which hosts the data, I can actually SELECT the desired data, so it seems to be working. The server accessing the data is version 5.0.51a24 and the host server is 5.0.96-0. Old stuff, that is. How do I solve the problem? Couldn't find much help in the MySQL documention. mysql federated share|improve this question edited Feb 1 '13 at 7:40 asked Jan 31 '13 at 8:26 Gruber 1319 1 Check the following bug reports to see if these are the cases with you bugs.mysql.com/bug.php?id=27180 (querying a big table) bugs.mysql.com/bug.php?id=28269 (use of a reserve word in table definition) –Wasif Feb 1 '13 at 6:46 @mwasif: Thanks a lot. I've updated the question to include the versions of MySQL I use. Apparently those old versions may have some bugs. One (tedious and
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow http://stackoverflow.com/questions/5251147/accessing-data-with-federated-error-1429 the company Business Learn more about hiring developers or posting ads with us Stack http://osdir.com/ml/mysql/2014-03/msg00080.html Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Accessing data with FEDERATED error #1429 up vote 1 down vote favorite 1 I am currently trying to unable to establish a connection from one database to another on the same hostname(mysql.stud.ntnu.no) with FEDERATED, however, when the table is created(no problem), I get this errorcode beneath: #1429 - Unable to connect to foreign data source: Access denied for user.... ... being hostname and the rest. I have checked that the mysql version is above 5.0, so it does support the FEDERATED function Appreciate any help or tips you got on this =) unable to connect mysql database-connection federated federated-table share|improve this question asked Mar 9 '11 at 19:32 Stian Krey 612 If it's on the same host, is there a reason why you aren't using select column from db.tablename instead of federated tables? –sreimer Mar 9 '11 at 19:47 I was thinking about it, since I'm building it in Codeigniter. Might be a whole lot easier.. By the way, they are on the same hostname, but the logincredentials for the two databases are different(they contain different tables) –Stian Krey Mar 9 '11 at 20:33 To select or join across databases, the user you are using needs access to both. –sreimer Mar 9 '11 at 20:40 The user indeed has the right to perform those operations, anything else I'm missing? –Stian Krey Mar 9 '11 at 20:48 If the same user is failing with a direct cross database query and with the federated table connection, I'm guessing it's still a permissions error. Can't really say for sure as I have limited insight into your setup (some sort of educational institute?) I would verify that the same user/password works from the command line to both databases. mysql -h mysql.stud.ntnu.no database_name -u username -p –sreimer Mar 9 '11 at 21:08 add
"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 the system. And I'm using 'root' user with all privileges. I can't seem to find a solution at any sites. Anyone with suggestion for this problems? The problem could be recreated as the code below. drop table if exists test001 ; create table test001 ( xx bigint(20) unsigned ) ENGINE=InnoDB DEFAULT CHARSET=utf8; drop table if exists test001FE ; create table test001FE ( xx bigint(20) unsigned ) ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION = 'mysql://root:root@192.168.0.11:3306/Prelude_copy/test001'; insert into test001FE(xx) values (12); Thread at a glance: Previous Message by Date: Re: Help with cleaning up data On 3/29/2014 2:26 PM, william drescher wrote: I am given a table: ICD9X10 which is a maping of ICD9 codes to ICD10 codes. Unfortunately the table contains duplicate entries that I need to remove. CREATE TABLE `ICD9X10` ( `id` smallint(6) NOT NULL AUTO_INCREMENT, `icd9` char(8) NOT NULL, `icd10` char(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `icd9` (`icd9`,`id`), UNIQUE KEY `icd10` (`icd10`,`id`) ) ENGINE=InnoDB AUTO_INCREMENT=671 DEFAULT CHARSET=ascii id icd9 icd10 25 29182 F10182 26 29182 F10282 27 29182 F10982 I just can't think of a way to write a querey to delete the duplicates. Does anyone have a suggestion ? bill Thanks for all the suggestions. I learned a lot, which is the most important part of the exercise. bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql Previous Message by Thread: Help with cleaning up data I am given a table: ICD9X10 which is a maping of ICD9 codes to ICD10 codes. Unfortunately the table contains duplicate entries that I need to remove. CREATE TABLE `ICD9X10` ( `id` smallint(6) NOT NULL AUTO_INCREMENT, `icd9` char(8) NOT NULL, `icd10` char(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `icd9` (`icd9`,`id`), UNIQUE KEY `icd10` (`icd10`,`id`) ) ENGINE=InnoDB AUTO_INCREMENT=671 DEFAULT CHARSET=ascii id icd9 icd10 25 29182 F10182 26 29182 F10282 27 29182 F10982 I just can't think of a way to write a querey to dele