Difference between revisions of "PhpMyAdmin"

From Help
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
−
=Overview=
+
= 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.
+
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.  
  
−
=Install phpMyAdmin=
+
The phpMyAdmin application is an installation program which will allow you to quickly and easily install phpMyAdmin for use on your website.
  
 +
[[File:Overview.PNG]]
  
−
==Installation Directory==
+
= Install phpMyAdmin =
  
−
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.
+
To begin you must install phpMyAdmin onto your website.  
  
−
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.
+
== Installation Directory ==
  
−
==Database information==
+
To install phpMyAdmin please follow these directions. 1.Select or create a directory on your website to install phpMyAdmin.
  
−
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.
+
*You can select a directory path form the list provided (e.g. /public/adirectory/).
  
−
*Click '''Next''' once you have selected a database password.
+
OR
  
−
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.  
+
*You can also create a new directory under a given path using the second text box provided at the bottom of the interface.
  
−
*Using the dropdown lists, select a database username, then you select a database from the second drop-down menu.
+
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.
 +
 
 +
2.Once you have selected an installation directory that is acceptable to you, click '''Next''' towards the top-right corner of the app to continue to the next step.
 +
 
 +
[[File:Directory.png]]
 +
 
 +
== Database information ==
 +
 
 +
You must have a database installed on your website. If you do not:
 +
 
 +
#You will be asked to create a database password
 +
#Enter a password
 +
#Click '''Next'''.
 +
 
 +
If you already have a database user and database installed on your site you can:
 +
 
 +
#Select the database username and database which phpMyAdmn will work with.
 +
 
 +
*Please note: You must already have both these 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.
 
*Click '''Next''' towards the top-right corner of the interface to continue to the next step.
  
−
==Administration Interface==
+
[[File:Info.jpg]]
 +
 
 +
<br> '''*Please Note: You will need your password to uninstall phpMyAdmin'''
 +
 
 +
== Administration Interface ==
 +
 
 +
To use phpMyAdmin you must have a username and password combination. You will have to fill out all fields. Click '''Next''' when completed.
 +
 
 +
[[File:Admin.jpg]]
 +
 
 +
<br>
 +
 
 +
== Installation Complete ==
 +
 
 +
Your installation has completed. Here you can view the data. Click Next to complete the installation. You can then either exit or go to your phpMyAdmin.
 +
 
 +
[[File:Installationcomplete.png]]
 +
 
 +
= Uninstall =
 +
 
 +
To uninstall phpMyAdmin:
 +
 
 +
#Enter '''Password'''
 +
#Click '''Next'''
 +
#Confirm you want to uninstall by pressing '''Yes''' or '''No'''.
  
−
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.
+
[[File:Uninstall.PNG]]
  
−
Click '''Next''' towards the top-right corner of the interface to continue to the next step.
+
= Change Password =
  
−
==Installation Complete==
+
Here is where you can change the password for your phpMyAdmin login screen.
  
−
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.
+
#Enter your username
 +
#Enter new password
 +
#Confirm new password
 +
#Click '''Next'''
  
−
=Change 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.
  
−
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.
+
[[File:Changepassword.png]]
  
−
'''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=
  
−
=Go to phpMyAdmin=
+
Clicking this option will open your phpMyAdmin login screen in a new browser window. Enter the '''username''' and '''password''' you used to create your phpMyAdmin. This will allow you to use your database 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.
+
[[File:Login.png]]
  
−
=Uninstall phpMyAdmin=
+
Once you have logged in you will have access to phpMyadmin where you can:
 +
*Create tables
 +
*Edit any work
 +
*View your databases
 +
*Import and Export data and plenty more!
  
−
Clicking this option will uninstall phpMyAdmin. You will need to know your database username password to complete this operation.
+
[[File: Php.jpg]]
  
 
[[Category:Setup]]
 
[[Category:Setup]]

Latest revision as of 11:23, 21 February 2014

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.

Overview.PNG

Install phpMyAdmin

To begin you must install phpMyAdmin onto your website.

Installation Directory

To install phpMyAdmin please follow these directions. 1.Select or create a directory on your website to install phpMyAdmin.

  • You can select a directory path form the list provided (e.g. /public/adirectory/).

OR

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

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

Directory.png

Database information

You must have a database installed on your website. If you do not:

  1. You will be asked to create a database password
  2. Enter a password
  3. Click Next.

If you already have a database user and database installed on your site you can:

  1. Select the database username and database which phpMyAdmn will work with.
  • Please note: You must already have both these 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.

Info.jpg


*Please Note: You will need your password to uninstall phpMyAdmin

Administration Interface

To use phpMyAdmin you must have a username and password combination. You will have to fill out all fields. Click Next when completed.

Admin.jpg


Installation Complete

Your installation has completed. Here you can view the data. Click Next to complete the installation. You can then either exit or go to your phpMyAdmin.

Installationcomplete.png

Uninstall

To uninstall phpMyAdmin:

  1. Enter Password
  2. Click Next
  3. Confirm you want to uninstall by pressing Yes or No.

Uninstall.PNG

Change Password

Here is where you can change the password for your phpMyAdmin login screen.

  1. Enter your username
  2. Enter new password
  3. Confirm new password
  4. Click Next

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.

Changepassword.png

Go to phpMyADMIN

Clicking this option will open your phpMyAdmin login screen in a new browser window. Enter the username and password you used to create your phpMyAdmin. This will allow you to use your database web application.

Login.png

Once you have logged in you will have access to phpMyadmin where you can:

  • Create tables
  • Edit any work
  • View your databases
  • Import and Export data and plenty more!

Php.jpg

Retrieved from "http://websupportwiki.com/en/index.php?title=PhpMyAdmin&oldid=793"