How to setup database file ? This is only a Demo

Create Database, Username, Password & Import SQL file.

  • Step 1: Login to your website CPanel with your Username & Password.


  • Step 2: On Homepage, Scroll Down to Databases & Click on MYSQL Databases option.


  • Step 3: Create New Database, Just write billing_system & press Create Database Button.


  • Step 4: A message appears, Added the database "yupok_billing_system" It means Your Database Name : yupok_billing_system , Note : yupok_ prefix is demo, your website automatic added Prefix to your database name.So copy that name that is your Original Database Name.


  • Step 5: Press Go Back and return to Database Page again.

  • Step 6: Scroll Down the Page, MYSQL Users Add New User, Just fill the details like you want to use Username & Password & keep details in the safe place & Press Create User button.


  • Step 7: A message appears, You have successfully created a MySQL user named "yupok_demo_user". It means Your Database USERName : yupok_demo_user , Note : yupok_ prefix is demo, your website automatic added Prefix to your Username.So copy that name that is your Original Database Username.

  • Step 8: Press Go Back and return to Database Page again.

  • Step 9: Scroll Down the Page again to Add User to Database . Select your Last Created Username & Last Created Database for this billing system & Press Add Button.


  • Step 10: You will redirect to Another Page. Click on ALL PRIVILEGES option, Scroll down & Press Make Changes Button.



  • Step 11: A Success message appears on top right corner. After that scroll down to the page and press Go Back


  • Step 12: Example
    YOUR_HOST_NAME : localhost  Mostly its localhost but if not then contact your website service provide.
    YOUR_DATABASE_NAME : yupok_billing_system  This is demo which we explained above. Your real database name is different.
    YOUR_DATABASE_USERNAME : yupok_demo_user  This is demo which we explained above. Your real database username is different.
    YOUR_DATABASE_Password : password  That is explained in Step 6.
  • Step 13: Import sql file to Database. Go to CPanel homepage scroll down to Database , Click on phpMyAdmin, your database will be open.

  • Step 14: On the left sidebar your Newly Database Option will be shown Just click on that.

  • Step 15: After click see on right side there is Import Option click on that and browse & select sql file from your downloaded database folder and press Go Button on the bottom.


  • Step 16: Your database will be imported and your website is ready to Use.

Open Upload Folder, then open config folder ,then open db.php in any Text Editor Like Notepad++

1) Change your Database Details Carefully.

2) Google Recaptcha V2 Setup

Login to Google Account. After that go to this link - Google ReCaptcha Setup

On Domains Field, It should be your domain name not localhost

After Creating, Save Secret & Site Key at safe place. We will use in db.php file to setup

Open db.php, scroll down after database , change Site Key & Secret Key inside square box only.

Website Base URL setup

3) Open db.php, scroll down after google setup. Define Your Website Address Properly.

First Time Admin Login

  • Assume you make a folder on your server secrets and upload all copied files with correct database configuration.
  • URL for Admin : yourwebsite.com/secrets/boss/
  • Assume you don't make any folder and upload it into root directory i.e. www or public html folder on your server and upload all copied files with correct database configuration.
  • URL for Admin : yourwebsite.com/boss/
  • Default Email : admin@admin.com & Password : 123456
  • Click on Settings => Scroll Down to Last => Update Your Login Email & Password.
  • Old Password = 123456 => Set New Password & Keep in Safe Place