Amahi Forums

Hello everyone, once again I post to ask yet another question.
Searching all the forums for "MYSQL" only one page of results show up.
I have managed to collect some useful info from those posts but unfortunately that is not enough...

I am trying to setup a deferred database for XBMC, you can see the post here:
http://forum.xbmc.org/showthread.php?t=70603

I need to tell the program to access AMAHI's MYSQL SERVER and recover the following data:
1. host
2. username
3. port
4. password

I found that username is "hda" and the password is "root" (please correct me if I'm wrong)
but I still have no idea what the hostname and port are. Any help?

Here is the xml I have to fill in:
<videodatabase>
<type>mysql</type>
<host>localhost</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>

I can then create the database named "xbmc_video".

-gg

I have found the info installing phpmyadmin.
Now I have the firewall on fedora not allowing me to connect.

I tried to follow this hint:

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.

But I see no such option.

- gg

Edit: actually the firewall is disabled.

Were you able to figure this out?

I am trying to do the same thing with XBMC. When I open the port up through the firewall it kills my phpmyadmin usage. I can still use mysql through the terminal though. My other computers are still not able to reach the mysql databases though. Any suggestions?