IT Connect

Connecting You to Information Technology at the UW

Need Help?

Contact Us

Resources

Accessibility Accounts and Passwords Administrative Systems Appropriate Use Computer Labs Connecting Consulting Email Emergency Phones Questions & Ordering Printing Research Resources for IT Support Staff Safe and Secure Computing Skill Development Software and Hardware Teaching and Learning Teamwork Tools TV and Video Web Publishing

UW-IT

UW-IT Service Catalog UW-IT Billing

Installing phpMyAdmin

IT Connect > Web > Publishing > Using MySQL > Installing phpMyAdmin

phpMyAdmin is a popular and free PHP application used for administering one or more MySQL servers. While UW Information Technology does not support MySQL or phpMyAdmin, this article briefly describes phpMyAdmin, outlines the steps for installing and configuring phpMyAdmin on your UW account, and provides links to additional phpMyAdmin resources.

The instructions on this page will show you how to:

• Download and install the latest version of phpMyAdmin.
• Configure phpMyAdmin so that it can connect to your MySQL server.
• Password-protect your copy of phpMyAdmin with your UW NetID.

Note: You must set up and start your MySQL server before you can use 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:

• create and delete databases
• create, copy, delete and alter tables
• delete, edit and add fields
• execute any SQL-statement, including batch-queries
• manage keys on fields
• load text files into tables
• use many other advanced features

Instructions

1. StepsActions

1. Log into your web development host using a terminal emulator. Not sure how to do this? Click here for directions.

2. cd into your Web directory:

   cd public_html

3. Download the latest version of phpMyAdmin with wget.

   wget http://washington.edu/itconnect/web/publishing/phpMyAdmin-3.4.3.2-english.tar.gz

4. Unzip the file you just downloaded:

   tar zxvf phpMyAdmin-3.4.3.2-english.tar.gz

5. If this is the first time you are installing phpMyAdmin, create a symbolic link to the phpMyAdmin directory:

   ln -s phpMyAdmin-3.4.3.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.

6. Since phpMyAdmin is typically used with MySQL root privileges for administration purposes, you should password-protect the phpMyAdmin directory:

   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).

   Tip: If you're interested in learning more about controlling access to your website, see Controlling Access to Web Pages.

7. First create a directory for the script to write the config into:

   mkdir config

   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/setup

   There may be errors, ignore them for now. Click on the "New Server" button in the "Servers" section and fill in the following fields:

   Verbose name:	Leave Blank
   Server hostname:	ovid01.u.washington.edu This is the host that your MySQL server is running on. If your Web site is hosted on students.washington.edu, use vergil instead of ovid.
   Server port:	the port your MySQL server is configured to use
   Use SSL	Checked

8. Now click on the "Authentication" tab and fill in the following fields.

   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

9. Press the button at the bottom of the screen that says "Save" in green. You may get a "Warning" at this point claiming that it cannot connect to the MySQL server. This is a known bug: click on "ignore errors" to continue.

10. You will now be at the main "overview" page. You now need to save the configuration file itself. Press the button at the bottom of the "Configuration File" section that says "Save."

11. Now copy the configuration file into the main directory and delete the config directory:

    cp config/config.inc.php ./
    rm -rf config

12. Assuming your MySQL server is running, you are now ready to connect to it 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/

Resources

• Official phpMyAdmin documentation.

---

About IT Connect | News Feed | News Archive | Contact ITC