To use phpMyAdmin in cPanel, follow these steps:
-
Log in to your cPanel account.
-
In the "Databases" section, click on the "phpMyAdmin" icon.
-
You will be taken to the phpMyAdmin dashboard.
-
To create a new database, click on the "New" button in the sidebar and enter a name for the database.
-
To create a new table, click on the database name in the sidebar and then click on the "Create table" tab. Enter a name for the table and specify the number of columns.
-
To add data to a table, click on the table name in the sidebar and then click on the "Insert" tab. Enter the data for each column and click on the "Go" button to save the data.
-
To query the database, click on the SQL tab and enter a valid SQL statement. Click on the "Go" button to execute the query.
-
You can use the other tabs and options in phpMyAdmin to manage and manipulate your databases and tables as needed.
That's it! You should now be able to use phpMyAdmin to manage your MySQL databases in cPanel.