PhpMyAdmin

From WebHost Wiki

The title of this article should be phpMyAdmin. The initial letter is capitalized due to technical restrictions.

This needs expanding!

Image:Pma.gifphpMyAdmin 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 1 phpMyAdmin 2 Accessing phpMyAdmin 2.1 Via cPanel 2.2 Directly 3 Understanding the interface 4 Creating a table 5 Viewing table data 6 Editing a record 7 Advanced table operations 7.1 Direct SQL input 8 See also

phpMyAdmin

Accessing phpMyAdmin

There are several ways in which you can access the phpMyAdmin application on your 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

• PHP
• MySQL
• cPanel

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