Using MySQL Administrator from Remote Windows Based system

FreePBX Tips and Tricks
1

I am trying to connect to the MySQL database server of my asterisk box. I assume that I just use the i.p. address of the asterisk server, and port 3306 for the MySQL database.

I have tried this and get an error. I can ping it successfully.

I am using the following:

Server Host: i.p. address of the asterisk server
Port: 3306
Username: root
Password: my password

2

You need to make sure the port is MySQL is configured to run though the remote port, Firewall/iptables is not blocking it and permissions inside of MySQL allow the particular user to access MySQL remotely.

Philippe Lindheimer - FreePBX Project Lead
http//freepbx.org - IRC #freepbx

3

I wouldn’t recommend doing this. It is certainly possible, but it means one more service exposed to the world. A better way to go is with something like phpmyadmin, which is a web-based GUI for mysql. It connects to mysql locally, and runs over the (probably existing) web server.

Greg MacLellan - Core FreePBX Developer
http//freepbx.org - irc.freenode.net #freepbx

4

I do agree with Greg on the recommendation not to do it.

Philippe Lindheimer - FreePBX Project Lead
http//freepbx.org - IRC #freepbx

5

I second that, don’t publish to the outside world. But if you are just trying to access your MySQL server from inside the network I have found that you have to allow access for username@[location] where location = either your machines name or internal IP address. IE: root@‘192.168.1.50’ and then grant the necessary permissions to the database you want access to. Then (if you have the necessary mysql configurations in place) you should be able to connect.

Hope that helps!