RE: [cobalt-developers] Beginner wanting MySQL on Qube3

["Andy Brown" <andy.brown@xxxxxxxxxxxxx>]

<snip>
> AFAIUI MySQL is already installed.  I want to be able to use 
> a web based
> administration and client applications.  Then later use PHP4 
> myself for
> using MySQL databases in my own pages and applications.
</snip>

Correct, it is already installed, as the cobalt gui uses it AFAIK. But to enable it for YOUR applications to work does involve using SSH/Telnet to go in there.
Login as root, and edit the php.ini file like this:
pico -w /etc/httpd/php.ini
scroll down and look for the commented line:
;extension==mysql.so
Take the semi-colon off the front, save then exit pico (editor). Restart httpd by issuing:
/etc/rc.d/init.d/httpd restart

You can now access mysql via PHP in the usual manner.

Since you'd like web-based administration of MySQL, phpMyAdmin is probably what you need. I've seen it mentioned in the lists before, so do a quick search and see if anyone has a PKG to install. If not, its very straight forward to install over ftp to the default web directory on the Qube.


<snip>
> Finally will there be any problem using MySQL through a 
> firewall if the
> normal http and ftp ports are open?
</snip>

Confused now!! How are you going to be using MySQL, are you going to access it via scripts (perl/php) and serve the results via the web server?? If so, then MySQL doesn't go anywhere else apart from within the Qube itself.
If you are wanting to use remote client tools (Such as the windows MySQL client) then you will have to allow port 3306 tcp & udp through the firewall for MySql (Don't forget, this needs different user permissions if you are defining hosts that users can connect to in MySQL access permissions)

Hope that helps you out.

Regards,

Andy
andy@xxxxxxxxxx
http://www.raqpak.com/ <-- Raq/Qube unofficial PKGs and support advice