Page 1 of 1
Can I use MySQL on Amahi for apps not hosted on my HDA?
Posted: Fri Sep 25, 2009 11:19 pm
by Jh60082
So basically I tried installing a PHP app on my other computer and wanted to use the MySQL on my HDA, but when I tried connecting it said it couldn't connect to it, I'm pretty sure I was typing in all the right stuff, what gives??
Re: Can I use MySQL on Amahi for apps not hosted on my HDA?
Posted: Sat Sep 26, 2009 12:46 pm
by cpg
it's your box!
mysql is there, you can use it to do whatever you want!
to do what you want, we have the concept of
amahi webapps.
the mysql user/password is root/hda.
Re: Can I use MySQL on Amahi for apps not hosted on my HDA?
Posted: Wed Sep 30, 2009 2:33 pm
by Jh60082
well see that is the thing, I do use a bunch of those apps but on my other computer, i want to install applications on that computer like Moodle but use MySQL on Amahi. But my problem is, my computer won't connect to the database on my Amahi server. am I missing some settings here?
Re: Can I use MySQL on Amahi for apps not hosted on my HDA?
Posted: Thu Oct 01, 2009 9:41 pm
by error10
The firewall built into Fedora doesn't allow connections to MySQL by default. To enable this, follow these steps:
1. From your HDA desktop, go to System > Administration > Firewall. Enter your root password when prompted.
2. On the Firewall screen, choose Other Ports on the left side, and then Add on the right side.
3. Scroll down to 3306/tcp/mysql and select it, then click OK at the bottom. (You don't need to add 3306/udp/mysql as this is not used.)
4. Click Apply, then close the window.
This should allow remote connections to your MySQL server.