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:

  • Create and delete databases
  • Create, copy, delete and alter tables
  • Execute any SQL-statement, including batch-queries
  • Export and import databases
  • use many other advanced features

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

Instructions

  1. Log into your web development server using a terminal emulator. If you're not sure how to do this, click here for instructions.

  2. Change directories by typing the following at the command prompt: cd public_html

  3. Download the latest version of phpMyAdmin with wget by typing this command at the terminal:

    wget http://washington.edu/computing/forms/web/phpMyAdmin-3.5.2.2-english.tar.gz

  4. Unzip the file you just downloaded by typing this command at the terminal:

    tar zxvf phpMyAdmin-3.5.2.2-english.tar.gz

  5. Create a shortcut to phpMyAdmin by typing this command at the terminal:

    ln -s phpMyAdmin-3.5.2.2-english phpmyadmin

  6. Open the file that controls access to your phpMyAdmin install by typing the following commands into the terminal:

    cd phpmyadmin
    pico .htaccess

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

  8. Save and close the file using Pico. (Click for instructions on how to use pico).

  9. Create a directory for the script to write the config into:

    mkdir config

  10. 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
    • There may be errors, ignore them for now.

  11. 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
  12. 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
  13. 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.
  14. Click the "Save" button at the bottom of the "Configuration File" section.

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

  16. 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/

Resources

Official phpMyAdmin documentation

Last modified: July 16, 2013