BobFranz's questions

Ok I have searched google for two days trying to get this to work. Here are the steps I have taken so far:

1. Clean install of Ubuntu 10.10
2. Install mysql 5.1 as well as admin
3. Comment out the bind address in the config file
4. Create a new database
5. Create a new user that is username@% to allow remote connections
6. Grant all access to this user to the new database EXCEPT the grant option
7. Login on the server is ok using this new user and database on the localhost
8. Login on the server is ok using this new user and database on the server internal network ip
9. Login from a remote computer is ok using this new user and database using the internal network ip
10. Login is not working when logging in with this username and database using the external ip address from the server or the remote computer.
11. I have port forwarding enabled for this port and it is viewable from outside as confirmed by canyouseeme.org

12. I have nmap'd using the following command on the internal ip and get the below result:

    nmap -PN -p 3306 192.168.1.73

    Starting Nmap 5.21 ( http://nmap.org ) at 2011-02-19 13:41 PST Nmap scan report for computername-System-Name (192.168.1.73) Host is up (0.00064s latency). PORT STATE SERVICE 3306/tcp open mysql

    Nmap done: 1 IP address (1 host up) scanned in 0.23 seconds

13. I have nmap'd using the following command on the internal ip and get the below result(I have hidden ip for obvious reasons):

    nmap -PN -p 3306 xxx.xxx.xx.xxx

    Starting Nmap 5.21 ( http://nmap.org ) at 2011-02-19 13:42 PST Nmap scan report for HOSTNAME (xxx.xxx.xx.xxx) Host is up (0.00056s latency). PORT STATE SERVICE 3306/tcp closed mysql

    Nmap done: 1 IP address (1 host up) scanned in 0.21 seconds

I am completely stuck here and need some help. I have tried everything under the moon and still can not connect from a remote external ip address. Any help is greatly appreciated and I need to do anything to help find the problem let me know and I will post the results here.

Well honestly the title says it all. I am new to server install and stuff and basically want this for testing purposes for a web app I am building. I have ubuntu up and running but want to get mysql running with the federated storage engine enabled by default. Any help is greatly appreciated.

Aron

Is it possible to create a MySQL stored procedure that can execute a given insert or update and then also have it connect to a 2nd server and run the same commands? I want to basically call one server and in real-time have it backup to the second server. Just a yah or ney would suffice unless you have a link or two handy or another solution.

Thank you for your time. Aaron