> For the complete documentation index, see [llms.txt](https://android-ebook-app.gitbook.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://android-ebook-app.gitbook.io/docs/admin-panel/database-configuration.md).

# Database Configuration

### **Create Database**

* Login to your cpanel hosting and open **MySQL Databases**
* Create database and give database name like you want, as example : ‘**solodroid\_myapp\_db**’
* Create user for your database
* Add user to your database and check **ALL PRIVILEGES**

<div align="left"><img src="/files/YViXk2DboFVEIt2rB20Y" alt=""></div>

<div align="left"><img src="/files/ZeioffVwsPUDH4Jbjv3l" alt=""></div>

<div align="left"><img src="/files/H5wUhaDhBJT6wWaaJHPg" alt=""></div>

### Import Database

* Open **phpMyAdmin** and select your database
* Import database file “ **android\_ebook\_app\_db.sql**” from download package inside ‘**admin\_panel**‘ folder

### Upload PHP Scripts

* Open **File Manager** via cpanel or ftp server
* Upload **“android\_ebook\_app.zip**” inside “**admin\_panel**” folder to your folder destination on your hosting, then extract it

### Database Connection

* to change configuration please see **includes/config.php** file
* you must edit this data with your own data.

{% code title="config.php" %}

```php
//database configuration
$host       = "localhost";
$user       = "root";
$pass       = "";
$database   = "android_ebook_app_db";

$connect = new mysqli($host, $user, $pass, $database);

if (!$connect) {
   die ("connection failed: " . mysqli_connect_error());
} else {
   $connect->set_charset('utf8mb4');
}
```

{% endcode %}

### Default Admin Panel Login detail

Username : admin\
Password : admin