Workbook on Digital Private Papers > Setting up the Paradigm Digital Repository
Installing - MySQL and phpMyAdmin
From the Desktop
Start up YaST (Yet another Setup Tool) by clicking the SUSE toolbar's "Start" button (the green button with the smiling gecko) => System menu => Control Center (YaST):
The YaST dialog opens telling you that you need to enter root's password before you can continue.
Enter the root password.
In the YaST window that opens, click the Software icon in the left menu and then the Software Management icon to the right.
YaST takes a moment to inventory what you already have installed and what you can install. Then it opens a window with a search dialog.
Installing phpMyAdmin
Search for phpmyadmin.
Select components as required and the select Accept.
YaST will automatically include any necessary packages - select Continue.
YaST updates the system configuration files. Select Install More as we will install MySQL next.
Search for mysql - add additional components as required:
YaST will automatically include any necessary packages - select Continue.
YaST updates the system configuration files. Select Finish as we will configure PHP before installing any further applications.
Starting the MySQL Service
We want MySQL to start up when we boot. To enable this, click the System icon in the left pane of the YaST window. Then click the System Service (Runlevel) in the right pane.
Select the Expert mode radio button at the top of the dialog.
Scroll through the list of Services to find the MySQL service entry.
Select mysql from the scrolling list.
Under the Set/Reset dropdown in the lower-right corner, choose Enable the Service.
This should automatically select the appropriate runlevels to use when starting the service.
Under the Start/Stop/Refresh dropdown, select Start now ...
If we have avoided any missteps, the MySQL service will start.
Click Finish.
Save the changes.
We are returned to the YaST Control Center Main panel.
Testing MySQL
If you installed phpMyAdmin, you can test your MySQL installation by going to http://localhost/phpMyAdmin/. With Linux, URLs are case sensitive so it is important to capitalise the "M" and the "A" in phpMyAdmin or you'll get an error.
At the foot of the page you will see a warning message about securing the system. This nag message will continue to be displayed until corrective action is taken.
Selecting the Privileges - should bring up the following screen - where new users can be registered, etc.
Selecting Databases should show the dummy databases test and tmp. The mysql database contains control information and is not for general use. Most applications will install in their own database.
Previous section <<
Install PHP
Next section >> Install Postgresql
