Manage Your Databases with phpMyAdmin
Posted by H9 Admin on 21 April 2015 03:30 PM
|
||||
phpMyAdmin is a software tool, written in PHP, intended to handle the administration of MySQL via web browser. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations (managing databases, tables, fields, relations, indexes, users, permissions, etc.) are supported by the user interface, while you still have the ability to directly execute any SQL statement. phpMyAdmin can be accessed via your cPanel and is integrated with your hosting account. Let's get started... Access phpMyAdminYou can find phpMyAdmin from within your cPanel dashboard. Just log into cPanel and click the phpMyAdmin icon in the Databases section. Basic Functions of phpMyAdminCreate Databases and UsersBefore you can get started using phpMyAdmin, you must create your first MySQL database. Selecting DatabasesTo view the structure of your databases, simply click on the database name in the left column of the home page. Alternatively, you may click on the databases tab along the top of the screen. Browse Your DatabasesOnce you have selected a database, you can browse it by clicking the Browse option in the Action column, adjacent to the table in question. View MySQL ProcessesYou may view the current MySQL processes by selecting the Status tab while at the home page of phpMyAdmin. To kill a process, click Kill to the left of the process ID number.
| ||||
|