postgresql - socket error when logging into mysql using socket rather than login at terminal -


i'm using mysql2pgsql migrate database mysql postgres. can log mysql command line fine. i'm using .yml file make conversion, contains normal login details:

mysql:  hostname: localhost  port: 3306  socket: /tmp/mysql.sock  username: root  password: *************  database: user_data  compress: false destination:  # if file given, output goes file, else postgres  file:  postgres:   hostname: localhost   port: 5432   username: root   password: ************   database: user_data 

for reason i'm getting mysql socket error:

_mysql_exceptions.operationalerror: (2002, "can't connect local mysql server through socket '/tmp/mysql.sock' (2)") 

any ideas how fix this?

check location of socket running

mysqladmin variables

replace socket: returned

you remove socket key config. if remove socket key connect via tcp.