Difference between revisions of "PhpMyAdmin"

Revision as of 12:36, 16 July 2009

phpMyAdmin is a PHP tool, designed to handle the administration of MySQL databases using a web browser interface. It can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges and export data into various formats.

The phpMyAdmin application is an installation program which will allow you to quickly and easily install phpMyAdmin for use on your website.

Install phpMyAdmin

Step 1: Installation Directory

You will need to select a directory on your website to install phpMyAdmin. You can select a directory path form the list provided (e.g. /public/adirectory/). You can also create a new directory under a given path using the second text box provided at the bottom of the interface. For example, if you want to create a /phpmyadmin/ directory under /public, select /public from the list, then in the second textbox at the bottom, type "phpmyadmin" and click the "create" button. This will create a directory called /phpmyadmin/ under /public.

Once you have selected an installation directory that is acceptable to you, click "Next" towards the top-right corner of the interface to continue to the next step.

Step 2: Database information

If you do not have a database installed on your web space, you will be asked to create a database password, allowing the phpMyAdmin installer to create a database and database user for you.

• Click "next" once you have selected a database password.

If you already have a database user and a database installed on your web space, you can select a database username and database which phpMyAdmin will work with. You must already have a database username and database set up. You can create a database and database username with the Database Manager application.

• Using the dropdown lists, select a database username, then you select a database from the second drop-down menu.

• Click "Next" towards the top-right corner of the interface to continue to the next step.

Step 3: Administration Interface

The administration interface for phpMyAdmin requires a username and password to log in. Provide a username and password in the fields provided. As a precaution, you are required to type your password twice in order to verify your password.

Click "Next" towards the top-right corner of the interface to continue to the next step.

Step 4: Installation Complete

The final step indicates that your installation was successful, and provides the URL you should use in order to login and begin using phpMyAdmin. You can also use the "Go to phpMyAdmin" function to open a new browser window and go directly to the login URL.

Change Password

This option allows you to change the password for your phpMyAdmin login screen. Enter your login username, your new password, and confirm your new password by entering it into the "confirm password" field. Then click "Next" to change your password.

Please note: the password you are changing is the one you use to log in to phpMyAdmin, which can be accessed by clicking on the "Go to phpMyAdmin" button.

Go to phpMyAdmin

Clicking this option will open your phpMyAdmin login screen in a new browser window. The phpMyAdmin login screen will allow you to log in and use the phpMyAdmin database management web application.

Uninstall phpMyAdmin

Clicking this option will uninstall phpMyAdmin. You will need to know your database username password to complete this operation.