Error 1130 - what is the cure? - Forums

This topic is empty.

Viewing 4 reply threads

Author

Posts
- April 28, 2005 at 7:24 pm #8942
  
  uk_martin
  Member
  
  I am using SQLYog 3.71 to try to establish a connection to the test database in mySQL Server on my local network server. (OS = Windows Server 2003)
  
  I'm using the following:
  
  IP – 192.168.0.1
  
  User – administrator
  
  Password – myPassword
  
  Database – test
  
  Port 3360
  
  MySQL on the Windows Server is a fresh installation of version 1.4
  
  When I click to connect, I get an Alert Box popping up, with the following error message:
  
  “Error 1130
  
  Host pcName is not allowed to connect to the mySQL Server”
  
  Is this a genuine mySQL issue or one with the SQLYog settings?? More to the point, how is the problem resolved?
  
  Thanks in advance for any help on offer
  
  Martin
- April 28, 2005 at 7:26 pm #17567
  
  CalEvans
  Member
  
  MySQL has rejected the combination of your login and host. You need to change the user settings on the server before you will be able to connect.
  
  =C=
- April 28, 2005 at 7:46 pm #17568
  
  uk_martin
  Member
  
  Any suggestions what in mySQL I need to change to accommodate the connection please?
- April 29, 2005 at 2:52 am #17569
  
  Ritesh
  Member
  
  This should help http://dev.mysql.com/doc/mysql/en/user-acc…management.html.
- April 29, 2005 at 4:26 am #17570
  
  peterlaursen
  Participant
  
  1) port 3360 .. I guess you mean 3306 ??
  
  2) version 1.4 .. I guess you mean 4.1 ??
  
  Can you log on as ROOT ?
  
  Maybe this is trivial to you (and maybe it is not) but MySQL does not use the Windows User Management.
  
  It operates its own user accounts.
Author

Posts