1) Database setup

Export Local Server Database
local host -> phpmyadmin ->your database ->Export

2) Live Server setup

Create DB
Cpanel -> MySQL Database -> Create New Database & Add User then Select add user DB details
Manage User Privileges -> select All Privileges ->Make Changes.
Cpanel ->phpMyAdmin ->select Created database -> Import Sql (which is before we export from local server and modified)

3) upload

Cpanel ->file manager -> upload all files

4) Config

uploaded files – > wp-config ->edit->enter created database details

Example.

/** The name of the database for WordPress */
define(‘DB_NAME’, ‘yourDB ‘);

/** MySQL database username */
define(‘DB_USER’, ‘yourDB_user’);

/** MySQL database password */
define(‘DB_PASSWORD’, ‘)DB_password ‘);

/** MySQL hostname */
define(‘DB_HOST’, ‘localhost’); /**