MySQL Administrator

DaiShan

Diamond Member
Jul 5, 2001
9,617
1
0
Ok, I run MySQLD 5.0 on my Gentoo install and I wanted to check out the GUI MySQL Administrator tool on my Ubuntu build. I added a firewall rule to allow access to 192.168.2.* addresses for port 3306 so that machines on my internal network can access the daemon, however I've been unable to connect. A friend of mine at lunch today suggested that I enable networking support in my.cnf, but I couldn't find an option for that, does anyone have any suggestions?
 

Cheetah8799

Diamond Member
Apr 12, 2001
4,508
0
76
Your question is a bit hard to understand, but I think you are saying your database server is outside the firewall, and your GUI admin server is inside. If you think the firewall is the issue, I suggest checking the MySQL web site for what ports need to be open. I'm not sure which are needed, or if the GUI tool needs more than 3306.

I do all my admin work with phpMyAdmin. Maybe you'll have better luck getting that to work.

 

DaiShan

Diamond Member
Jul 5, 2001
9,617
1
0
Originally posted by: Cheetah8799
Your question is a bit hard to understand, but I think you are saying your database server is outside the firewall, and your GUI admin server is inside. If you think the firewall is the issue, I suggest checking the MySQL web site for what ports need to be open. I'm not sure which are needed, or if the GUI tool needs more than 3306.

I do all my admin work with phpMyAdmin. Maybe you'll have better luck getting that to work.

No, I mean MySQL Administrator is a program that connects to a running MySQLD session. Here is a rundown of my set up:

192.168.2.101 - Gentoo box running MySQLD
192.168.2.120 - Ubuntu box running the MySQL administrator program

192.168.2.101 has iptables installed and I've opened port 3306 (the port that MySQL is configured to run on) for all IP's internal to the network (192.168.2.101)


/edit thanks for the response :D
 

kamper

Diamond Member
Mar 18, 2003
5,513
0
0
What sort of permissions do you have set up on mysql itself? Have you issued any GRANT statements saying who can to what databases from where? What connects to the database currently?

A simple test might be to use ssh to forward port 3306 from your ubuntu machine to your gentoo machine and then use the admin client to connect to localhost on ubuntu.
 

DaiShan

Diamond Member
Jul 5, 2001
9,617
1
0
Originally posted by: kamper
What sort of permissions do you have set up on mysql itself? Have you issued any GRANT statements saying who can to what databases from where? What connects to the database currently?

A simple test might be to use ssh to forward port 3306 from your ubuntu machine to your gentoo machine and then use the admin client to connect to localhost on ubuntu.

I figured it out, thanks for all the help, it turns out my Ubuntu machine had reverted to dhcp and the ip did not match the host for my user account, changed back to static and all works well :D