PDA

View Full Version : error: 2002 can't connect to MySQL


teach1st
09-30-2001, 12:14 PM
Not my day. Can anybody tell what I'm doing wrong?

[teach1st@FQ-Six:~/www/vb ]$ mysqldump uxpb5th -p hmysql.pb5th.com xpb5th > pbvb.txt
Enter password:
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '
/tmp/mysql.sock' (111) when trying to connect

and

[teach1st@FQ-Six:~/www/vb ]$ mysqldump -uxpb5th -p hmysql.pb5th.com xpb5th > ./pbvb.txt
Enter password:
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '
/tmp/mysql.sock' (111) when trying to connect

I'm trying to emulate this from the FQ MySQLDump Tutorial (http://www.aota.net/PHP_and_MySQL/mysqldump.php3):
Once you are telneted in, you will type a command like this:
mysqldump -uxyourdomain -p -hmysql.yourdomain.com xyourdomain_2 >./myfile.txt

Thanks

I should have graded papers instead %)

Arthur
09-30-2001, 12:22 PM
You're missing the - in front of the u and the h;
$ mysqldump -uxpb5th -p -hmysql.pb5th.com xpb5th

(-u = user, -h = host)

teach1st
09-30-2001, 12:28 PM
%)

Thanks, Arthur! Worked like a champ...