MySQL Forums
Forum List  »  Federated Storage Engine

how to set the socket for connection option of federated table
Posted by: z.. zz
Date: February 23, 2011 04:15AM

Hello,
i want create a fedrated table with following connection option,
problem is, "Access denied for user" because the target dababase requests socket information "/tmp/mysql5.sock", otherweise the connection will be denied.
but for creating a fedrated table, where can i put the socket information?
PS: Mysql Version 5.0.67
---------------------------------------------
CREATE TABLE `xxx_history` (
`id` int(10) unsigned NOT NULL auto_increment,
`clientid` int(11) NOT NULL default '0',
)
ENGINE=FEDERATED
DEFAULT CHARSET=latin1
CONNECTION='mysql://user:passowrt@localhost/databasename/xxx_history';
------------------------------------------------



Edited 1 time(s). Last edit at 02/23/2011 05:07AM by z.. zz.

Options: ReplyQuote


Subject
Views
Written By
Posted
how to set the socket for connection option of federated table
6147
February 23, 2011 04:15AM


Sorry, you can't reply to this topic. It has been closed.

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.