how to set the socket for connection option of federated table

[z.. zz]

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.