2. Navigate to MySQL Databases<\/strong> icon.<\/p>\n\n\n\n 3. Create a database.<\/p>\n\n\n\n 4. Create a user<\/strong> and select a password<\/strong> for the database user. Save these somewhere as you will need it for your configuration file.<\/p>\n\n\n\n 5.Give the user permissions to manage the database.<\/p>\n\n\n\n – Go to Add User to Database<\/strong> section and select the database name, and user you would like to access the database then click Add<\/strong><\/p>\n\n\n\n -Select ALL PRIVILEGES<\/strong> then click Make Changes.<\/strong><\/p>\n\n\n\n 6. Go back to cPanel main page and navigate to phpMyAdmin<\/strong>.<\/p>\n\n\n\n 7. Your database will display there. Select it first then click Import<\/strong><\/p>\n\n\n\n 8. Click Browse<\/strong> and select your .sql<\/strong> file from your computer and click Go at the bottom of the page<\/strong>. Allow it to complete upload.<\/p>\n\n\n\n 9. Now, navigate to your configuration<\/strong> file. This depends on what you named it e.g config.php, database.php, configuration.php, connect.php etc<\/p>\n\n\n\n 10. Fill in the details, with the correct hostname, <\/strong>database, <\/strong>username <\/strong>andpassword<\/strong> as follows:<\/p>\n\n\n\n Hostname<\/strong><\/em>: this is always localhost<\/strong><\/p>\n\n\n\n Username<\/strong><\/em>: username of your database as created in step4 e.g truehost_user<\/strong><\/p>\n\n\n\n Password<\/strong><\/em>: password selected in step 4<\/p>\n\n\n\n Database<\/strong><\/em>: the name of the database as created truehost_database<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" If you have created your database driven website on localhost and want to upload the database to cPanel, there are a number of easy steps to take to successfully connect your database. Please read along 1. Login to cPanel 2. Navigate to MySQL Databases icon. 3. Create a database. 4. Create a user and select […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_eb_attr":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"doc_category":[],"doc_tag":[],"class_list":["post-5852","docs","type-docs","status-publish","hentry"],"year_month":"2026-06","word_count":224,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"w m","author_nicename":"wm","author_url":"https:\/\/www.truehost.com\/support\/author\/wm\/"},"doc_category_info":[],"doc_tag_info":[],"yoast_head":"\n![\"\"](\"https:\/\/truehost.co.ke\/support\/wp-content\/uploads\/2020\/08\/How-to-upload-and-configure-MySQL-database-into-cPanel1.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/truehost.co.ke\/support\/wp-content\/uploads\/2020\/08\/How-to-upload-and-configure-MySQL-database-into-cPanel2-1024x246.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/truehost.co.ke\/support\/wp-content\/uploads\/2020\/08\/How-to-upload-and-configure-MySQL-database-into-cPanel3-1024x401.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/truehost.co.ke\/support\/wp-content\/uploads\/2020\/08\/How-to-upload-and-configure-MySQL-database-into-cPanel4-1024x258.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/truehost.co.ke\/support\/wp-content\/uploads\/2020\/08\/How-to-upload-and-configure-MySQL-database-into-cPanel5.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/truehost.co.ke\/support\/wp-content\/uploads\/2020\/08\/How-to-upload-and-configure-MySQL-database-into-cPanel6.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/truehost.co.ke\/support\/wp-content\/uploads\/2020\/08\/How-to-upload-and-configure-MySQL-database-into-cPanel7-1024x471.png\")
<\/figure>\n\n\n\n