c2d mySQL notes
c2d uses mySQL
as their database. This product is
open source and available in most linux distributions. The webserver
must be able to handle PHP.
Requirements
- Apache webserver, with PHP
- mySQL (we've been using 5.23.54 [rh9 @ UMD] and 5.23.58 [rhel/as3 @ NAU])
Setup
If you are not the system administrator on your machine, and/or not allowed
to be root, you may have to run apache and mysql in local mode. This
should be possible, but we have not tried this out. So, for the remainder
of this we shall assume you have root access.
It is also assumed you have installed apache (or any webserver that is
PHP enabled) and mysq via your local system installation procedures
(e.g. on redhat-like machines you will have used rpm). The actual
incantations how to start/enable. For example, on redhat you can use
the command
chkconfig --list
to confirm if httpd and mysqld are services that have
been started up.
Setting my mySQL
(as root, either the usual)
/etc/rc.d/init.d/mysql start
Setting my apache
(as root, either the usual)
/etc/rc.d/init.d/httpd start
Setting my c2d databases