Problem
How to install MySQL & phpMyAdmin on SCO OpenServer 6?
Solution
1. Ensure the OpenServer 6 server has the latest patch updates and is at least on MP2.
2. Download the following:a. MySQL-5.0 from:https://downloads.mysql.com/archives/get/p/23/file/mysql-5.0.90-sco-osr6-i686.tar.gz
MD5: 57931e566d3442ee4d83215188d6fa3ehttps://downloads.mysql.com/archives/get/p/23/file/mysql-5.0.90-sco-osr6-i686.pkg.gz
MD5: 6b663d04545f13580332d40caf476990Get the OpenServer 6 (x86, pkgadd)b. phpMyAdmin from SCO Skunkware (phpMyAdmin-VOLS.cpio) from:
ftp://ftp2.sco.com/pub/skunkware/osr6/volsc. Perform this step only if you are on SCO OpenServer 6 MP2 (MP3 includes it) MySQL perl & php modules for MySQL 5 supplement OSS704a from SCO (VOL.000.000):
https://ftp.scoexpert.com/openserver6/600/patches/oss704a3. Extract and install the phpMyAdmin:# cpio -ivI phpMyAdmin-VOLS.cpioIt should extract 4 VOL files.Run custom and install from Media Image using the path where the VOL files exist.
4. Extract and install MySQL perl & php modules
(Skip this step if you have SCO OpenServer 6 MP3 installed)
Run 'custom' and install from Media Image the VOL.000.000 file you downloaded in Step 2c.
5. Extract and install MySQL-5.0.Use 'gunzip' to unzip the pkg file.
# pkgadd -d /PATH_TO_FILE/mysql-5.0.45-sco-osr6-i686.pkg(Change the path name appropriately.)6. Edit the /usr/lib/php/php.iniLook for the line extension=mysql.so if there is a semi-colon preceding it, then remove the semi colon.
If it is not present then continue to step 7.
7. To password protect the phpMyAdmin access from the web
Edit the 'config.inc.php' file located in:/opt/K/SCO/phpmyadmin/2.6.2Sa/usr/lib/apache/htdocs/phpMyAdminChange:$cfg['Servers'][$i]['auth_type'] = 'config';To:$cfg['Servers'][$i]['auth_type'] = 'http'This will now require the mysql username and password to access phpMyAdmin.
8. Edit the httpd.conf filea. If you want to change the location of the default SCO Server webpage
Edit the file /usr/lib/apache/conf/httpd.conf and change the
line:DocumentRoot "/usr/lib/apache/htdocs" to the new location.Also make sure you change the:<Directory "/usr/lib/apache/htdocs">to the new location.Make sure you also add a symbolic link phpMyAdmin in the root directory of the new location:
# ln -s /opt/K/SCO/phpmyadmin/2.6.2Sa/usr/lib/apache/htdocs/phpMyAdm
/path_to_new_location/phpMyAdminb. Uncomment out the ServerName and set it to the name of your web server.
This is very important or a trailing slash will be required on each subdirectory of your website.
9. Restart apache:# /etc/rc2.d/P90apache restart10. Start the mysql daemon:# /etc/init.d /mysql startShould respond with SUCCESS!To have the script auto start when the server boots:
# ln -s /etc/init.d/mysql /etc/rc2.d/S98mysql
# ln -s /etc/init.d/mysql /etc/rc0.d/K43mysql11. Set the new root password for mysql:
# mysqladmin -uroot password new_password12. Create a mysql database if needed:
# mysqladmin -uroot -ppassword_in_step10 create name_of_new_database13. Test the phpMyAdmin by going to:
http://Name_of_your_server.com/phpMyAdminYou should be prompted for a username and password.
Use the mysql user root and the password you assigned in step 10.