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

Can't Connect

forums › forums › SQLyog › Using SQLyog › Can't Connect

  • This topic is empty.
Viewing 7 reply threads
  • Author
    Posts
    • August 9, 2005 at 9:30 am #9159
      Obiraptor
      Member

      Well I have the SQLyog Enterprise trial version and I'm getting crazy.

      I can't connect with Direct connection

      I get the Error No 1045

      With phpMyAdmin all works fine so I don't understand!

    • August 9, 2005 at 9:51 am #18894
      peterlaursen
      Participant
      Quote:
      With phpMyAdmin all works fine so I don't understand!

      phpMyAdmin is running on the server itself so when connecting to MySQL with phpMyAdmin you are NOT connecting from a remote host! The user that you are connecting with maybe has no privilige to connect from remote.

      Note that MySQL by default only gives access for users to connect from localhost. If you want to give some user access to the server from another host you must specify the hostname (an ip or a URL). You can use the SQL wildcards “%” and “_” (but not windows wildcards like “*”). Simply giving permission for a user to access the server from “%” means from everywhere.

      There must be som kind of “Control Panel” application at your webhost from where to configure users.

    • August 9, 2005 at 9:58 am #18895
      peterlaursen
      Participant
      Quote:
      I can't connect with Direct connection

      I get the Error No 1045

      I don't remember error no.'s!

      What is error msg in txt?

      If could also be that your webhosting has blocked the MySQL port.

      Then you cant connect directly from remote.

      Then you must use either HTTP- or SSH-tunnelling

    • August 9, 2005 at 10:00 am #18896
      peterlaursen
      Participant

      seems to be this one.

      It sure is a user-authentification or -privilege problem

    • August 9, 2005 at 11:12 am #18897
      Obiraptor
      Member
      peterlaursen wrote on Aug 9 2005, 11:00 AM:
      seems to be this one.

      It sure is a user-authentification or -privilege problem

      [post=”6822″]<{POST_SNAPBACK}>[/post]

      Yes is that one the messege I get

      I checked in my control panel MySQL Account Maintenance.

      In Access Hosts: % is allowed

    • August 9, 2005 at 11:18 am #18898
      Obiraptor
      Member
      peterlaursen wrote on Aug 9 2005, 11:00 AM:
      seems to be this one.

      It sure is a user-authentification or -privilege problem

      [post=”6822″]<{POST_SNAPBACK}>[/post]

      Ok it works, I solved the problem

      Thanks

    • August 9, 2005 at 11:23 am #18899
      Ritesh
      Member

      What was the issue?

    • August 9, 2005 at 11:29 am #18900
      peterlaursen
      Participant

      hmmm …

      it could be that you must use a suffix with the user name.

      For instance at my webhosting let's say my userid is 'asdfgh'. The name of the users at my DB is prefixed with that. I can create user 'peter' in control panel but to connect with that user I must use string 'asdfgh_peter'. Database names must be prefixed the same way.

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