مرکز آموزش

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. cPanel integrates phpMyAdmin, allowing users to easily manage their databases through a graphical interface. This guide will cover the basics of managing databases using phpMyAdmin in cPanel, from accessing it to performing common database operations.

Accessing phpMyAdmin in cPanel

1. Log in to cPanel: Begin by logging into your cPanel account. This is usually done by appending "/cpanel" to your website's URL and entering your credentials.

2. Find phpMyAdmin: Scroll to the "Databases" section in your cPanel dashboard and click on "phpMyAdmin". This action will open phpMyAdmin in a new tab or window, giving you access to your databases.

Exploring phpMyAdmin Interface

• Left Sidebar: Displays a tree of your databases. Clicking on a database will show its tables.
• Top Menu: Offers options such as SQL, Export, Import, and more, applicable to the selected database or table.
• Main Window: Shows details of the selected database or table, including rows, structures, and SQL commands.

Creating a New Database

While database creation is typically handled in cPanel's MySQL Databases section, phpMyAdmin can also be used for this purpose if your user privileges allow it.

• Go to the "Databases" tab in phpMyAdmin, enter a name for your new database, and click "Create".

Creating Tables

After selecting a database in the left sidebar:

1. Enter the name of your new table and the number of columns you need.
2. Click "Go" to define the columns, their types, and other attributes.
3. Click "Save" when finished to create the table.

Importing Data

To import data into a database:

1. Select the database or table in the left sidebar.
2. Click the "Import" tab at the top.
3. Choose the file to import, set the format (usually SQL), and click "Go".

Exporting Data

To export a database or table:

1. Select the database or table you want to export.
2. Click on the "Export" tab.
3. Choose the export format (e.g., SQL for databases) and options.
4. Click "Go" to download the exported data.

Executing SQL Queries

• Navigate to the "SQL" tab after selecting a database or table.
• Enter your SQL query in the provided field.
• Click "Go" to execute the query. This is useful for creating, updating, or deleting records, among other operations.

Best Practices for Database Management

• Regular Backups: Use the Export function regularly to back up your databases.
• Security: Keep your phpMyAdmin and cPanel passwords secure. Consider changing them regularly.
• Optimization: Regularly check your databases for overhead and use the "Optimize table" feature to improve performance.