Using MySQL Workbench with GoAutoDial

[fairch]

Installation from GoAutoDial .iso
Webmin 1.530 installed after GoAutoDial installation
(no other software installed after GoAutoDial installation)
Linux 2.6.18-238.9.1.el5.goPAE on i686
CentOS Linux 5.6
GoAutoDial CE 2.1
Default IP Address of 192.168.1.2

Hi,

I want to use "MySQL Workbench" to help in the management and updating of our customer information contained in the GoAutoDial system databases.

I have the "Workbench" software installed on a Windows-based computer. From this same Windows-computer, I am able to log onto the GoAutoDial system using Firefox, and access phpMyAdmin. I am also able to use SSH (using Putty) to gain access to the GoAutoDial box from this computer, and then I can also successfully log on to mysql using the command line interface. So, I presume the appropriate passwords are correct.

However, when I use MySQL Workbench to attempt to connect to the GoAutoDial MySQL server (192.168.1.2) (using the default port 3306), I get an error message that it can't connect.

I checked the iptables file, thinking perhaps that was the problem, and found the entry:

#-A RH-Firewall-1-INPUT -m tcp -p tcp --dport 3306 -j ACCEPT

So, I removed the "#" in front of the line, figuring this was "commenting out" this entry, and then rebooted the system.

But, still no go.

However, I don't know enough about Linux, and CentOS, and iptables to know if that is the right entry in the iptables file. Or, maybe there's something else I'm missing?

Any help would be greatly appreciated.

[williamconley]

password being correct is nice, but when you use "ssh" to get to mysql, you are connecting from LOCALHOST. when you use workbench on your windows box to connect, you are connecting from YOUR IP. if root does not have permission to "log on" from that ip, it will reject the attempt.

turn off your firewall (for testing) (iptables -F)

use "cron" and "1234" for workbench (and make a note to figure out how to change this password moving forward ... LOL). that user generally has permission to log on from any host.

[fairch]

Thank you very much for your help. By the way, it worked without having to disable the iptables. I did not know that a username and password could be allowed to logon only from a certain location. Never encountered that in the Windows world.

I actually do not know how to change that default password...

[williamconley]

then use the workbench or phpmyadmin to create a new user just for you with more power and permission from ONLY your ip address. and change cron to be limited to localhost only until you need it to access from other machines (not a bad idea for it to be localhost AND the local ip address, and add more IPs as you add servers to your cluster).

mysql security isn't perfect, but it ain't bad either.