Connection problem error 1130

This topic is empty.

Viewing 6 reply threads

Author

Posts
- March 16, 2003 at 11:57 pm #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
- March 17, 2003 at 1:37 am #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=
- March 18, 2003 at 3:11 am #13924
  
  adavis4012
  Member
  
  adjust what permissions? on the server or on my computer?
- March 18, 2003 at 3:14 am #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.
- March 18, 2003 at 3:38 pm #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.
- March 18, 2003 at 6:21 pm #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.
- March 18, 2003 at 9:41 pm #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=
Author

Posts