Proposed:PhpMyAdmin

From JumbaWiki

(Redirected from PHPMyAdmin)
Jump to: navigation, search
The title of this article should be phpMyAdmin. The initial letter is capitalized due to technical restrictions.
A sample view of the phpMyAdmin home screen - click to enlarge
A sample view of the phpMyAdmin home screen - click to enlarge
phpMyAdmin is a third-party tool to view and manage your MySQL databases. It offers simple to use interfaces to create/edit and manage tables and data within your databases.

Note: phpMyAdmin is not able to create databases due to a cPanel limitation. To create databases see the MySQL Databases or the MySQL Database Wizard article.

Contents

phpMyAdmin

Accessing phpMyAdmin

There are several ways in which you can access the phpMyAdmin application on your Jumba service.

Via cPanel
To access phpMyAdmin via cPanel:
 Login to your cPanel account @ yourdomain.com/cpanel
 Under the 'Databases' submenu you will see the 'phpMyAdmin' icon. Click on the icon to access phpMyAdmin
 You will see a cPanel page which states that it is redirecting you, wait a moment and the phpMyAdmin main screen should appear
Directly
Direct your browser to: 
 http://www.yourdomain.com:2082/3rdparty/phpMyAdmin/index.php for the unsecured version
 OR
 https://www.yourdomain.com:2083/3rdparty/phpMyAdmin/index.php for the SSL secured version

Understanding the interface

Creating a table

Viewing table data

Editing a record

Advanced table operations

Direct SQL input

See also

Databases (cPanel options)
Image:Mysql.gif
MySQL Databases
Image:MysqlWizard.gif
MySQL Database Wizard
Image:Pma.gif
phpMyAdmin
Image:RemoteMysql.gif
Remote MySQL
Image:Postgresql.gif
PostgreSQL Databases
Image:PostgresqlWiz.gif
PostgreSQL Database Wizard
Image:Pga.gif
phpPgAdmin
Personal tools
Australian Photography | Unique Views of Reality | Daedalus