How to create a MySQL database
- Log in to cPanel.
- Look for the Databases section, then click MySQL Databases.
- In the New Database field, type a name for your database.
- Click Create Database.
- Under Add User to Database, select a user from the User dropdown menu.
- From the Database dropdown menu, select the database you wish to allow the user access to.
- Click Add.
- Select the privileges you wish to grant the user or select ALL PRIVILEGES on the next page.
- Click Make Changes, then click Go Back.
How to Import or restore a database or table
- Log into phpMyAdmin through your cPanel dashboard
- Select the destination database on the left pane.
- Click on the Import tab in the top center pane.
- Under the ‘File to import’ section, click Browse and locate the file with the .sql extension you wish to import.
- Click the Go button at the bottom to import the database.
*If you imported a database, all tables will show when selecting the database in the left panel of phpMyAdmin.
*If you imported a table, the newly-imported table will appear in the list of tables.
How to edit HTML wp-config.php database name
- Log into File Manager through your cPanel dashboard
- public_html > wp-config.php right click edit
- change the DB_NAME to new database name after edit the database name click to Save Changes.
