Help on the external connection of mysql

Results 1 to 6 of 6
  1. #1
    Apprentice fenixpotter is offline
    MemberRank
    Apr 2011 Join Date
    19Posts

    Help on the external connection of mysql

    HI ^ ^
    I do not quite know how to say I rode a more perfect world of server-based tutorial
    das7002 http://forum.ragezone.com/f452/serve...-4-2-a-698047/
    now I need more help on a mysql.
    MySQL is not accepting connections eg es out of my stay, I was wondering how
    make him accept this Connection it. ?
    I believe that other people do not understand much about mysql also want to know how to fix this please help me ^ ^
    thanks: D


  2. #2
    Account Upgraded | Title Enabled! fluxbox is offline
    MemberRank
    Sep 2004 Join Date
    KanagawaLocation
    303Posts

    Re: Help on the external connection of mysql

    MySQL's default config is binded to 127.0.0.1, which is the most secure way. If you require to connect from another IP comment this out in your config file. I recommend securing the access via iptables, only allowing your IP to connect to your MySQL port (3306).

  3. #3
    Apprentice fenixpotter is offline
    MemberRank
    Apr 2011 Join Date
    19Posts

    Re: Help on the external connection of mysql

    sure, tell me how to make this process of iptables?

  4. #4
    Account Upgraded | Title Enabled! fluxbox is offline
    MemberRank
    Sep 2004 Join Date
    KanagawaLocation
    303Posts

    Re: Help on the external connection of mysql

    There's a lot of nice tutorial out there:
    Google

    or an old thread here:
    http://forum.ragezone.com/f452/iptables-693240/

  5. #5
    Banned coolgirlpwns is offline
    BannedRank
    May 2010 Join Date
    BrazilLocation
    513Posts

    Re: Help on the external connection of mysql

    Quote Originally Posted by fenixpotter View Post
    HI ^ ^
    I do not quite know how to say I rode a more perfect world of server-based tutorial
    das7002 http://forum.ragezone.com/f452/serve...-4-2-a-698047/
    now I need more help on a mysql.
    MySQL is not accepting connections eg es out of my stay, I was wondering how
    make him accept this Connection it. ?
    I believe that other people do not understand much about mysql also want to know how to fix this please help me ^ ^
    thanks: D
    I had the same problem when i was trying to connect to batGM tool.

    You have to unbind it from 127.0.0.1 to accept any connections witch i think is in the my.cnf or something. Then i had to make a sperate user account in phpmyadmin with all permisions and also with the ability to connect from "any host". That may help you a bit :)

  6. #6
    Apprentice fenixpotter is offline
    MemberRank
    Apr 2011 Join Date
    19Posts

    Re: Help on the external connection of mysql

    well, I'll try to do something more would be great a clearer guide in relation to this, thanks

    ---
    edit|
    ---

    here's what I tried still can not connect to batgm, aff someone please make a guide that is more clear I'm still lost in relation to that
    Last edited by fenixpotter; 18-04-11 at 12:54 AM.



Advertisement