Difference between revisions of "PhpMyAdmin"
(Created page with '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, dele…') |
|||
| Line 1: | Line 1: | ||
| + | =Overview= | ||
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. | 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. | The phpMyAdmin application is an installation program which will allow you to quickly and easily install phpMyAdmin for use on your website. | ||
| + | =Install phpMyAdmin= | ||
| − | + | ==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. | 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. | ||
| Line 16: | Line 13: | ||
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. | 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. | ||
| − | + | ==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. | 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. | 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. | ||
| − | + | ==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. | 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 | + | Click '''Next''' towards the top-right corner of the interface to continue to the next step. |
| − | |||
| − | |||
| − | |||
| − | |||
| + | ==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. | 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. | 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. | ||
| Line 59: | Line 40: | ||
'''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. | '''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. | 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. | Clicking this option will uninstall phpMyAdmin. You will need to know your database username password to complete this operation. | ||
[[Category:Setup]] | [[Category:Setup]] | ||
Revision as of 11:37, 29 March 2012
Contents
Overview
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
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.
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.
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.
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.