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

Connecting to MySql remotely

forums › forums › SQLyog › Using SQLyog › Connecting to MySql remotely

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • August 16, 2004 at 2:47 pm #8532
      acco
      Member

      I am trying to connect to MySql through SQLyog using a specific user that exists in the user table in mysql. If I attempt to connect through the command line it all works perfectly. So I know the username and password are correct.

      I then try through SQLyog and it fails. I get the following error.

      Error No. 1045

      Access denied for user: 'xxx@intranet-100' (Using password:YES)

      The website I am working with connects to it perfectly. So I still know that the user 'xxx' is connecting, but SQLyog will not connect. I've had it connected before with no problems, but some reason it just keeps failing.

      Any suggestions??

    • August 17, 2004 at 6:56 am #16184
      Shadow
      Member

      Host name might be a problem. When you connect via command line, which host do you connect from? From localhost (where MySql runs) or from remote host (where SQLyog runs)? Check if xxx@intranet-100 user (or xxx@%) exists at all!

    • August 21, 2004 at 12:09 pm #16185
      just4fun
      Member

      if mysq settings on localhost(where MySql runs) host allow connect from remote host you be connected, else you have error Access denied for user: 'xxx@intranet-100' (Using password:YES)

      And you can't fix it, and not one program runned from remote host can't connect…. fucking Security 😉

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