MySql on debian refuses to accept external connections

djmarkus · 2006-03-09 00:57:13

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?

09-03-2006 12:57AM

#1

djmarkus

Registered Users, Registered Users 2 Posts: 1,606 ✭✭✭

Join Date: January 2005

Posts: 1478

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?

0

Comments

#2 09-03-2006 08:59AM

cgarvey

Registered Users, Registered Users 2 Posts: 3,890 ✭✭✭

Join Date: April 2002

Posts: 3752

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

0
#3 09-03-2006 02:11PM

djmarkus

Registered Users, Registered Users 2 Posts: 1,606 ✭✭✭

Join Date: January 2005

Posts: 1478

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

Thanks a mil

0