Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2004

    Exclamation Unanswered: Problem using mysqldump remotely

    Hi dear!

    Here is my problem:

    I got 2 computers, running for one under Win 2K server and the other under Linux Mandrake 9.2.

    I got a HTTP server with a Mysql DB running on XP computer and i'd like to use Linux machine as Backup machine for my site.

    So my wish is to import MySql DB on Linux and from Linux (Remotely).

    So I type these command:

    [root@linux_web root]# mysqldump --verbose --user=Linux -p --host=easytrading --add-drop-table --complete-insert easytrading > /easytrading.sql
    Enter password:
    -- Connecting to easytrading...
    mysqldump: Got error: 2003: Can't connect to MySQL server on 'easytrading' (111) when trying to connect

    But i still don't understand the error!

    I created Linux User on my DB, with ALL GRANT PRIVILEGES.

    I verified the port 3306 is open on the local computer by processing an telnet cmd: it's all ok

    So could somebody tell me what happened when i use mysqldump remotely


  2. #2
    Join Date
    Jun 2002
    Have u tried using the IP address instead of the host name?

  3. #3
    Join Date
    Dec 2004
    sure, it doesn't still work

  4. #4
    Join Date
    Dec 2004
    You should give user "Linux" access to mysql *from all servers*, quite a common problem with mysql.

    Try these 2 before re-issuing mysqldump on W2K System :
    (mysql command line on server "easytrading")

    grant all on easytrading.* to Linux@'%' identified by "<passwd_goes_here>";
    grant all on easytrading.* to Linux@'localhost' identified by "<passwd_goes_here>";

    Quite a common hassel wih mysql authorizations when connection remotely ...

    Let us know if this did the trick

    You might have addtional issues with codepages etc... when copying DBs form X to W

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts