Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Remote Connection

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Remote Connection

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • January 12, 2004 at 11:06 pm #8297
      DonT55
      Member

      I am attempting to connect to a MySQL database at a remote location. The MySQL database has a row in the user database for host=”%”, user=”root”, password=”” but each time I attempt to connect remotely, I receive the following error:

      error 2003

      Can't connect to MySQL server on '66.112.212.210' (10061)

      Can anyone help me create this connection?

      Thanks in advance for your help.

    • January 13, 2004 at 2:51 am #15396
      Ritesh
      Member

      The error means that the MySQL server has not been started 🙂

    • January 13, 2004 at 1:41 pm #15397
      DonT55
      Member

      I have double checked and MySQL Server is started on the remote server. I can connect to that MySQL Server directly from the remote server with SQLyog but not remotely from my computer. Any other thoughts?

    • January 13, 2004 at 2:46 pm #15398
      Ritesh
      Member

      You dont have permission to connect from a REMOTE host to your MySQL server.

      In MySQL, you can provide privileges depending upon user connecting from specific hosts.

      The following query will allow only the user to access from “localhost” ( this is probably your case )

      GRANT ALL PRIVILEGES ON *.* TO user@localhost

      IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

      You have to issue a GRANT stmt like

      GRANT ALL PRIVILEGES ON *.* TO a@%

      IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.