Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Remote Connection to a MySQL DB through MySQLcc??

  • 09-08-2005 9:54pm
    #1
    pbarry
    Registered Users, Registered Users 2 Posts: 194 ✭✭


    Hey,

    I have a hosted database that I want to remotely connect to through MySQLcc.

    However I keep getting this error in MySQLcc:

    ERROR 1130: Host '83-70-33-59.b-ras1.prp.dublin.eircom.net' is not allowed to connect to this MySQL server

    Is this due to me having Eircom Broadband that probably does't allow this type of remote connection??

    Cheers....

    pb


Comments

  • #2
    Baz_
    Registered Users, Registered Users 2 Posts: 2,660 ✭✭✭Baz_


    Id say that the access table (in the mysql server that is) is only set up to allow your account to access the server from localhost. i.e. you may not be able to login from anywhere except on that machine. Accounts access can be restricted by IP address, and I would say simply that the ip address you connect to the internet with just isn't authorised.


  • #3
    pbarry
    Registered Users, Registered Users 2 Posts: 194 ✭✭pbarry


    Cheers for that Baz_. I just had to create a new user with full privileges and use my IP as the HostName. Worked like a charm.

    Nice1


  • #4
    Baz_
    Registered Users, Registered Users 2 Posts: 2,660 ✭✭✭Baz_


    no problems, glad I could help.


Advertisement