> For the complete documentation index, see [llms.txt](https://phoenixcoded.gitbook.io/able-pro/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://phoenixcoded.gitbook.io/able-pro/vue-laravel/development/database-connection.md).

# Database Connection

Here are a few options for database connections. Although provided for demonstration purposes, using one of them is not required.

{% hint style="success" %}
**Note:** Since the template is a Vue integration and all of the data is displayed using **fake-db** inside <mark style="color:red;">`resources\ts`</mark> , we haven't provided any migrations with it.
{% endhint %}

### MySQL <a href="#for-mysql" id="for-mysql"></a>

Copy file ".env.example", and change its name to "**.env**". Then in file ".env" complete this database configuration:

```batch
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=
```

If you want to check **php migration** on database then **connect database** with your database name

1. open phpmyadmin
2. create new database which is "**test**" name (example here)
3. go to **.env** file and
4. change database configuration

<pre class="language-birb"><code class="lang-birb"><strong>DB_DATABASE=test // set as per your database name 
</strong>DB_USERNAME=root // add your database username
DB_PASSWORD=     // add your database password if you want
</code></pre>