... 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.
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.
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.