Mysql Error 1429
Contents |
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
Unable To Connect To Foreign Data Source Host Is Not Allowed To Connect To This Mysql Server
with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack unable to connect to foreign data source access denied for user Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign
Mysql Federated Table
up Accessing data with FEDERATED error #1429 up vote 1 down vote favorite 1 I am currently trying 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 =) 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 a comment| 1 Answer 1 active oldest votes up vote 0 down vote I got the same error message before I executed this command on the remote (source) server: mysqladmin flush-hosts share|improve this answer answered Apr 1 '15 at 16:31 rantanplan 245421 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email an
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Federated Storage Engine :: ERROR 1429 : Unable to connect to foreign data source: Can't connect to MySQL seto New Topic Advanced Search ERROR 1429 : Unable to connect to foreign data source: Can't connect to MySQL seto Posted by: Pradeep Ganapathy () Date: February 16, 2013 12:33AM While i am using 'FEDERATED' Engine to sync with remote server, i am http://stackoverflow.com/questions/5251147/accessing-data-with-federated-error-1429 getting this following error. "ERROR 1429 : Unable to connect to foreign data source: Can't connect to MySQL server" Source Database version: mysql 5.5 Remote Database version: mysql 5.6 (Enterprise edition) port # : 3306 Thanks, Edited 1 time(s). Last edit at 02/16/2013 12:34AM by Pradeep Ganapathy. Navigate:Previous Message•Next Message Options:Reply•Quote Subject Views http://forums.mysql.com/read.php?105,579276,579276 Written By Posted ERROR 1429 : Unable to connect to foreign data source: Can't connect to MySQL seto 2405 Pradeep Ganapathy 02/16/2013 12:33AM 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 USA: +1-866-221-0634 Canada: +1-866-221-0634 Germany: +49 89 143 01280 France: +33 1 57 60 83 57 Italy: +39 02 249 59 120 UK: +44 207 553 8447 Japan: 0120-065556 China: 10800-811-0823 India: 0008001005870 More Countries» Contact Us Online» Products MySQL Enterprise Edition MySQL Standard Edition MySQL Classic Edition MySQL Cluster CGE MySQL Embedded (OEM/ISV) Services Training Certification Consulting Support Downloads MySQL Community Server MySQL Cluster MySQL Fabric MySQL Utilities MySQL Workbench About MySQL Contact Us How to Buy Partners Job Opportunities
2011 16:36 Reporter: Santo Leto Email Updates: Status: Closed Impact on me: None Category:MySQL https://bugs.mysql.com/bug.php?id=35333 Server: Information schema Severity:S1 (Critical) Version:5.1.23-beta, 5.0.58, 5.0.60-BK, 5.1.25-BK OS:Any Assigned to: Christopher Powers Tags: federated, metadata Triage: Triaged: D2 (Serious) / R3 (Medium) / E3 https://mariadb.com/kb/en/mariadb/spider-storage-engine-overview/ (Medium) View Add Comment Files Developer Edit Submission View Progress Log Contributions [17 Mar 2008 11:59] Santo Leto Description: If a Federated Table can't connect unable to to the remote host, can't select over the local table information_schema.tables. How to repeat: We will use 2 servers: a 'remote' server and a local server. First we create a table on the remote server and then we create a federated table on the local server and we make sure all unable to connect is working fine. Then we'll shutdown the remote server and we'll use the Test Script to simulate the bug. *** PRELIMINARY SCRIPT *** Remote Server: SELECT CURRENT_USER(), VERSION(); DROP DATABASE IF EXISTS `federated`; CREATE DATABASE `federated`; DROP TABLE IF EXISTS `federated`.`test_table`; CREATE TABLE `federated`.`test_table` ( `id` int(20) NOT NULL AUTO_INCREMENT, `name` varchar(32) NOT NULL DEFAULT '', `other` int(20) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `name` (`name`), KEY `other_key` (`other`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO `federated`.`test_table` (`name`,`other`) VALUES ('remote_value1', '1'); SELECT * FROM `federated`.`test_table`; Local Server: SELECT CURRENT_USER(), VERSION(); DROP TABLE IF EXISTS `test`.`federated_table`; CREATE TABLE `test`.`federated_table` ( `id` int(20) NOT NULL AUTO_INCREMENT, `name` varchar(32) NOT NULL DEFAULT '', `other` int(20) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `name` (`name`), KEY `other_key` (`other`) ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://sleto@localhost:6004/federated/test_table'; INSERT INTO `test`.`federated_table` (`name`,`other`) VALUES ('local_value1', '1'); SELECT * FROM `test`.`federated_table`; *** END PRELIMINARY SCRIPT *** *** TEST SCRIPT *** Local