Installing phpMyAdmin on Shared UW Hosting

About phpMyAdmin

phpMyAdmin provides an easy-to-use Web interface for most of the features of MySQL's command-line client. With phpMyAdmin you can:

Tip: Use a shell with tab-completion, such as bash or zsh, to help you enter the commands described in this document.

StepsActions
Log into your web development server using a terminal emulator. If you're not sure how to do this, click here for instructions.
Change directories by typing the following at the command prompt: cd public_html
Download the latest version of phpMyAdmin with wget by typing this command at the terminal:

wget http://washington.edu/itconnect/web/publishing/phpMyAdmin-3.5.2.2-english.tar.gz
Unzip the file you just downloaded by typing this command at the terminal:

tar zxvf phpMyAdmin-3.5.2.2-english.tar.gz
Create a shortcut to phpMyAdmin by typing this command at the terminal:

ln -s phpMyAdmin-3.5.2.2-english phpmyadmin
- If you are upgrading an existing version of phpMyAdmin, you may wish to wait to create a symbolic link until you've verified that your new phpMyAdmin installation is working.
Open the file that controls access to your phpMyAdmin install by typing the following commands into the terminal:

cd phpmyadmin
pico .htaccess
Enter the following lines to password-protect the phpMyAdmin directory with your account's UW NetID, replacing accountname with the UW NetID of your account:

AuthType UWNetID
require user accountname
Save and close the file using Pico. (Click for instructions on how to use pico).
Create a directory for the script to write the config into:

mkdir config

Start a Web browser and enter the URL that the table shows for your website affiliation.

Affiliation	URL
Student	students.washington.edu/Your NetID/phpmyadmin/setup
Faculty	faculty.washington.edu/Your NetID/phpmyadmin/setup
Staff	staff.washington.edu/Your NetID/phpmyadmin/setup
Department Shared NetID	depts.washington.edu/Your NetID/phpmyadmin/setup
Course Shared NetID	courses.washington.edu/Your NetID/phpmyadmin/setup

Click on the "New Server" button in the "Servers" section and fill in the following fields:

Field Data

Verbose name: Leave Blank

Server hostname:

Affiliation	Hostname
Student	`vergil.u.washington.edu`
Faculty, Staff, Department or Course	`your_netid.ovid.u.washington.edu`

Server port: The port number your MySQL server is configured to use

Use SSL Checked

Click on the "Authentication" tab and fill in the following fields.

Field	Data
Authentication type (you will need to change this!):	config
User for config auth:	root
Password for config auth:	The root password for your MySQL server

Click the button at the bottom of the screen that says "Save" in green.
- You may get a "warning" regarding a connection error to the MySQL server. This is a known bug: click on "ignore errors" to continue.
Click the "Save" button at the bottom of the "Configuration File" section.
Copy the configuration file into the main directory and delete the config directory by typing these commands into the terminal:

cp config/config.inc.php ./
rm -rf config
You are now ready to connect to MySQL and administer it with phpMyAdmin.

Start a Web browser and enter the following URL, replacing depts.washington.edu/accountname with the base URL to your Web site:

https://depts.washington.edu/accountname/phpmyadmin/

Reviewed 2/4/13 | News Feed