Technical article 126932

How to install MySQL & phpMyAdmin on SCO OpenServer 6?

OpenServer 6.0.0

Written · Last revised

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: 57931e566d3442ee4d83215188d6fa3e
https://downloads.mysql.com/archives/get/p/23/file/mysql-5.0.90-sco-osr6-i686.pkg.gz
MD5: 6b663d04545f13580332d40caf476990
Get the OpenServer 6 (x86, pkgadd)

b. phpMyAdmin from SCO Skunkware (phpMyAdmin-VOLS.cpio) from:

ftp://ftp2.sco.com/pub/skunkware/osr6/vols

c. 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/oss704a
3. Extract and install the phpMyAdmin:
# cpio -ivI phpMyAdmin-VOLS.cpio
It 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.ini

Look 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/phpMyAdmin
Change:
$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 file

a. 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/phpMyAdmin

b. 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 restart
10. Start the mysql daemon:
# /etc/init.d /mysql start
Should 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/K43mysql

11. Set the new root password for mysql:

# mysqladmin -uroot password new_password

12. Create a mysql database if needed:

# mysqladmin -uroot -ppassword_in_step10 create name_of_new_database

13. Test the phpMyAdmin by going to:

http://Name_of_your_server.com/phpMyAdmin

You should be prompted for a username and password.

Use the mysql user root and the password you assigned in step 10.

From the Xinuos technical article database, record 126932. Reproduced with permission. The original is at www.sco.com/ta/126932, which is reachable but blocked from search engines.

Next step

Need this fixed rather than explained?

Tell us the release, what the system runs and what it is doing. We will reply by email with what we would do next.

  • You deal with the people who do the work
  • No obligation, and no upgrade required before we will help
  • We tell you plainly if something is not worth doing

Send an enquiry

We reply by email. If a server is down, say so in the first line. You can also write to help@scoexpert.com.