Installing phpMyAdmin

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.

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 https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.tar.gz
```
Unzip the file you just downloaded by typing this command at the terminal:
```
tar zxvf phpMyAdmin-latest-all-languages.tar.gz
```
Create a shortcut to phpMyAdmin by typing this command at the terminal:
```
ln -s phpMyAdmin-latest phpmyadmin
```
(replace phpMyAdmin-latest with the name of the package unpacked in step 4, should be something like

phpMyAdmin-4.8.0.1-all-languages)
- 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
nano .htaccess
```
Follow steps 4 or 5 (depending on your server) from the following, Authorizing a Short list of UW Netids, to password-protect the phpMyAdmin directory with your account’s UW NetID, replacing the samples with the UW NetID of your account.
Save and close the file using Pico. (Click for instructions on how to use pico)

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: Your MySQL port

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: password for your MySQL server
Click the button at the bottom of the screen that says “Apply” 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 “Download” button at the bottom of the “Configuration File” section. This will copy the config file to your local machine.
Copy the configuration file into the main phpmyadmin directory and name it ‘config.inc.php’. This directory is usually ‘phpmyadmin’ from step 6 above.
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 website:
https://depts.washington.edu/accountname/phpmyadmin/

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