943,731 Members | Top Members by Rank

Ad:
  • Python Discussion Thread
  • Unsolved
  • Views: 1972
  • Python RSS
Oct 24th, 2007
0

error 1130

Expand Post »
Hi,

While connecting to a host computer to access its records from another computer using python. I am getting an error

OperationalError: (1130, "Host '2k.vfx.net' is not allowed to connect to this MySQL server")

There is no firewall. I have installed wampserver 5 on the host pc.

Is it possible to access the data from the host..using mysql

BRgds,

kNish
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
knish is offline Offline
19 posts
since Oct 2007
Oct 24th, 2007
0

Re: error 1130

Looks like either a port is closed or else there's a credentials problem. But that's a guess.

Jeff
Reputation Points: 92
Solved Threads: 156
Practically a Master Poster
jrcagle is offline Offline
608 posts
since Jul 2006
Jan 30th, 2008
0

Re: error 1130

what credentials problem can there be..may I know
This I need to ask for I have the same issue since the server harddisk crashed.

What backup method do u suggested

knish
Reputation Points: 10
Solved Threads: 0
Newbie Poster
knish is offline Offline
19 posts
since Oct 2007
Jan 30th, 2008
0

Re: error 1130

Click to Expand / Collapse  Quote originally posted by knish ...
...
OperationalError: (1130, "Host '2k.vfx.net' is not allowed to connect to this MySQL server")
...
Make sure you have given permission for user, who access the system, like 'allow remote access'. By default when you install MySQL will allow to access db from localhost for user root(default).

What GUI you use to interact with MySQL?
I had used phpMyAdmin as GUI to interact and Navicat some time back. I remember PHP MyAdmin gives good interface to give many credentials or permissions.

Click to Expand / Collapse  Quote originally posted by knish ...
Is it possible to access the data from the host..using mysql
Yes, for sure, provided you have set right permission, and you are not blocked by firewall.
The credentials are stored in a table under some database, which comes default with MySQL, which stores this credentials. But, I dont remember the table name now.

kath.
Last edited by katharnakh; Jan 30th, 2008 at 5:47 am.
Reputation Points: 19
Solved Threads: 34
Posting Whiz in Training
katharnakh is offline Offline
237 posts
since Jan 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Python Forum Timeline: Old Python topics contain 'bad' codetag
Next Thread in Python Forum Timeline: py Files On Mac





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC