If you want to delete a row from MySQL database in cPanel, you need to log in with the admin link, like https://example.com:2083. You can then access the various database management tools through the cPanel dashboard once you log in. Enter “php” in your cPanel search bar to find “phpMyAdmin.” Click the “+” icon next to the database and select the row you wish to delete. After you confirm the deletion in the dialog box, you will receive a notification indicating that the row has been successfully removed.
cPanel Dashboard
After clicking “Login,” you’ll be taken directly to the cPanel dashboard, where you can manage your website and hosting settings. The dashboard provides easy access to all the tools and features you need.
Search phpMyAdmin
In the cPanel dashboard, enter “php” in the search bar to locate “phpMyAdmin” in the dropdown menu. Click on “phpMyAdmin” to open the tool for managing MySQL databases.
Expand Database
In the phpMyAdmin screen, click the “+” icon next to “helpvoxfor_test” to expand and access the database. This will allow you to view and manage its tables.
Drop Selected Table
In the phpMyAdmin screen, select the row you wish to delete by checking the corresponding checkbox. Then, click on the “Drop” option to remove the selected row, as illustrated in the image below.
Confirm Delete Table
After clicking “Drop”, a confirmation dialog box will appear. Click “OK” in the dialog box to confirm and proceed with the deletion of the row from the MySQL database in cPanel.
After clicking “OK,” you will see a notification stating that MySQL returned an empty result set. This indicates that the row has been successfully deleted and no results were returned from the database query.
Conclusion:
Now that we’ve covered how to delete a row from MySQL Database in cPanel, you can also check out our installation guide in the video we created for additional help.