Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

MySql on debian refuses to accept external connections

  • 09-03-2006 01:57AM
    #1
    djmarkus
    Registered Users, Registered Users 2 Posts: 1,606 ✭✭✭


    No matter how i try i cant connect to my MySQL database over my local LAN, it doesnt even seem to get to user authentication, just wont connect. i've set up users and hosts in the mysql.users table using the % host wildcard.

    i can connect locally no problem.

    Anyone know what i could be doing wrong?


Comments

  • #2
    cgarvey
    Registered Users, Registered Users 2 Posts: 3,890 ✭✭✭cgarvey


    I have a vague recollection of MySQL on Debian defaulting to binding only on 127.0.0.1.. so have a look at your bind-address in /etc/mysql/my.cnf .. or do a netstat to see what addresses are listening on 3306. Assuming it's not a firewall issue!

    .cg


  • #3
    djmarkus
    Registered Users, Registered Users 2 Posts: 1,606 ✭✭✭djmarkus


    Heres my my.cnf, your right, the bind address was localhost, should have copped that!

    Thanks a mil


Advertisement