phpMyAdmin is an open-source, browser-based application designed to manage MySQL databases. Its graphical user interface (GUI) enables you to bypass the traditional command prompt method of managing MySQL and instead use a browser. The navigation options (in the form of tabs) are:

Database-level: Structure, SQL, Export, Search, Query, Operations.
Table-level: Structure, Browse, SQL, Search, Insert, Export, Operations, Empty, Drop.

It's available in the Linux Gold and above hosting plans. There is no fee associated with phpMyAdmin itself, but depending on your hosting plan there may be a fee for the MySQL database. You can compare plan features here. To upgrade your plan, please refer to SiteControl instructions. Unfortunately, phpMyAdmin is not available in the Windows hosting plans.

To access phpMyAdmin, you must first have activated a MySQL database for your domain. Once activated, you can launch phpMyAdmin in SiteControl. Log in to SiteControl, click WebSite Tools, then Manage Features. Now click the database you wish to manage.

You can essentially do everything you used to do with the command prompt, including:

Create, copy, drop, rename and alter tables.
Perform table maintenance.
Delete, add, and edit fields.
Execute any SQL statement and batch queries.
Manage keys on fields.
Create (*) and read dumps of tables.
Export (*) data to CSV, XML, and Latex formats.
Search globally in a database or its subset.
Support InnoDB tables and foreign keys.
Communicate in 47 different languages.

The current installed version is 2.6.2.

No, you do not have access to configuration files for phpMyAdmin as it has been implemented for shared server usage. However, we have configured it for the most optimal and stable operation. If you have any questions regarding its installation or configuration, then please contact our Support Team.

Not at all, the choice is entirely yours. You may continue to manage your database using command prompt.

To create a new table click the database name in the left navigation frame. In the "Create new table" section, enter the name of the table and the number of fields in your table.

To clear the contents of a table (but keep the table itself), locate and click the Empty icon next to the table you wish to clear.

To delete the table entirely, locate and click the Drop icon next to the table you wish to delete.

In the list of tables, locate and click the Insert icon next to the table for which you wish to enter data - unless it's a new table in which case locate and click the Structure icon (and then the Insert tab.) If you are already at the table-level view, then simply click the Insert tab at any time.

To edit or delete any field data, then click either the Structure or Browse tab/icon.

In phpMyAdmin, exporting your data is simple -- just click the Export tab. Select the tables and options (including structure) and then click Go. You can choose to either export to a file or simply display the data in phpMyAdmin, which you can then copy and paste elsewhere.

To import data in phpMyAdmin, click the SQL tab. You have the option of either importing a .sql file (by clicking the Browse button and then Go) or pasting SQL statements into the "Run SQL" text box immediately above the Browse button.

Please note that if you choose to import, the file MUST be a .sql file. If you have a dumped file of any other type (e.g. a tab-delimited file), then you must first convert it into a .sql file.

You have two options in the phpMyAdmin interface for manually entering a SQL query: SQL tab and Query tab. You may run your manual queries in either menu option.

 

The file size limit is 2048 KB (or 2 MB). If you find that your database exceeds this size, then:

Import by manually copying and pasting the contents of your .sql file directly into phpMyAdmin (SQL tab).
Export by not using the "Save as File" option when exporting and instead copy and paste the "dumped" data displayed in phpMyAdmin into a .sql file. Alternatively, you can export by using the mysqldump method via command prompt.

No, you cannot use phpMyAdmin to create or delete a database. You can, however, use it to create and delete tables. In order to create or delete a database you must continue to use SiteControl (Website Tools > Manage Features).

No, you will not be permitted to access multiple servers. You can, however, access multiple databases in the same MySQL server. Please note that even if you have multiple databases owned by the same domain it is not necessarily true that they all reside in the same server.

We support the following:

MyISAM
MERGE
HEAP
MEMORY
BDB
InnoDB
ISAM

No, you cannot. All user and privilege management is performed on the server-side.

No, mysqli is not currently supported.

Yes, in fact, phpMyAdmin supports 47 languages, any one of which you can select with a drop-down menu on the home page.

If you do not use Hostway's nameservers but still use our hosting services, then you must add a CNAME record to your DNS zone record (as managed by your nameserver host). The CNAME must point to the IP address of your Hostway MySQL server; to determine the IP address please contact our Support team.

phpMyAdmin is a well-established open-source application with numerous resources on the Web. As with all third-party tools, Hostway's support and documentation for phpMyAdmin is limited and furthermore restricted to our implementation. Assistance regarding the usage of phpMyAdmin or self-installed phpMyAdmin is beyond the scope of our Support. However, if you are unable to access phpMyAdmin via SiteControl or it fails to connect to your database, then please contact our Support Team.