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

1045 Error – Help Please!

forums › forums › SQLyog › Using SQLyog › 1045 Error – Help Please!

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • January 13, 2007 at 7:46 am #10127
      ChrisLees
      Member

      I've set up SQLyog previously and managed to use it to connect to a local instance of MySQL running on my development machine. Now that I've got hosting, I'm transferring the MySQL database to the web host, and trying to use SQLyog to connect to that external machine.

      The host IP address is 87.117.200.71, but when I try to connect, I get a 1045 error suggesting that access is denied for user 'myuser'@'ip-81-117-200-71.cust.homechoice.net'. Homechoice is my ISP, but I can't see how / why they are appearing as part of this SQLyog connection here. I suspect that the automatic additon of this information is causing the connection to fail.

      Any suggestions?

      Thanks

      Chris

    • January 15, 2007 at 6:01 am #23231
      peterlaursen
      Participant

      Please first read: http://webyog.com/faq/23_18_en.html

      Basically the error message “access denied ..”  tells that connection details are OK, but authentication details are not!

      Probably the user is not configured to allow connections from remoste hosts. Only 'this_user'@'localhost' is defined – not 'this_user'@'some_remote_host(s)'!

      But maybe your ISP will not allow for that and maybe you have no option to define such remote user (check your COntrol Panel!).  Maybe you will need to use tunnelling!  With tunnelling you connect from 'localhost'.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.