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

Connection problem error 1130

forums forums SQLyog Using SQLyog Connection problem error 1130

  • This topic is empty.
Viewing 6 reply threads
  • Author
    Posts
    • #7765
      beachboy
      Member

      Hi,

      I'm getting a error 1130

      host '12-210-33-182.client.attbi.com' is not allowed

      to connect to this MySQL server,

      Host Address = beachboy.net (192.220.91.23)

      user name = beachboy (my server login)

      Password = (server password)

      database = ban (do I need to install a database

      first?)

      port = 3306

      what am I doing wrong? 🙁

      Dennis

    • #13923
      CalEvans
      Member

      This is a mysql error. You are not allowed to connect to this server from your client. Adjust your user permissions and try again.

      =C=

    • #13924
      adavis4012
      Member

      adjust what permissions? on the server or on my computer?

    • #13925
      adavis4012
      Member

      I guess i could of been more specific…

      My server is on a UNIX box and I am trying to connect to it… I really only have 'root' user set up now but i thought that the root has complete access.

    • #13926
      Ritesh
      Member

      Just change the value of Host field in mysql.user table to `%` for the username root . This allows root to connect to the MySQL server from any location.

    • #13927
      beachboy
      Member

      Hi Gang, 😆

      I finaly got it to work!

      the % does not seem to work on my FreeBSD server ver of mysql in the command.

      GRANT ALL ON *.* TO root@% IDENTIFIED BY “password”;

      I got an sintax error starting at %

      The info I got back from the server was that it refused the connection from '12-210-33-182.client.attbi.com'

      So I created a new root level login

      GRANT ALL ON *.* TO [email protected] IDENTIFIED BY “password”;

      and now can get access but this may change as the it is dynanically allocated by ATT.

      Good luck All.

    • #13928
      CalEvans
      Member
      Quote:
      the % does not seem to work on my FreeBSD server ver of mysql in the command.

      GRANT ALL ON *.* TO root@% IDENTIFIED BY “password”;

      Sorry I missed the conversation. Glad you got it working. I have found on the Linux version of MySQL that I usually have to use:

      Code:
      GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY “password”;

      Note the quotes around the login name and the % .

      I'm not sure why but sometimes it works without it and sometimes it does not. however, it always works for me with the quotes.

      =C=

Viewing 6 reply threads
  • You must be logged in to reply to this topic.