PHPackages                             prajapatidhara1510/laravel-mysql-encrypt - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. prajapatidhara1510/laravel-mysql-encrypt

ActiveLibrary[Database & ORM](/categories/database)

prajapatidhara1510/laravel-mysql-encrypt
========================================

Laravel 5.x | 6.x | 7.x | 8.x Database encryption mysql side

v1.0.3(2y ago)035MITPHPPHP ^7.2.5|^8.0

Since Dec 15Pushed 2y agoCompare

[ Source](https://github.com/PrajapatiDhara1510/laravel-mysql-encrypt)[ Packagist](https://packagist.org/packages/prajapatidhara1510/laravel-mysql-encrypt)[ RSS](/packages/prajapatidhara1510-laravel-mysql-encrypt/feed)WikiDiscussions master Synced 2d ago

READMEChangelog (4)Dependencies (2)Versions (6)Used By (0)

Laravel/Lumen MySql AES Encrypt/Decrypt
=======================================

[](#laravellumen-mysql-aes-encryptdecrypt)

Laravel/Lumen database encryption at database side using native AES\_DECRYPT and AES\_ENCRYPT functions. Automatically encrypt and decrypt fields in your Models.

Install
-------

[](#install)

### 1. Composer

[](#1-composer)

```
composer require PrajapatiDhara1510/laravel-mysql-encrypt
```

### 2. Publish config (optional)

[](#2-publish-config-optional)

`Laravel`

```
php artisan vendor:publish --provider="PrajapatiDhara1510\MysqlEncrypt\Providers\LaravelServiceProvider"
```

`Lumen`

```
mkdir -p config
cp vendor/prajapatidhara1510/laravel-mysql-encrypt/config/config.php config/mysql-encrypt.php
```

### 3. Configure Provider

[](#3-configure-provider)

`Laravel`

- For Laravel 5.5 or later, the service provider is automatically loaded, skip this step.
- For Laravel 5.4 or earlier, add the following to `config/app.php`:

```
'providers' => array(
    PrajapatiDhara1510\\MysqlEncrypt\\Providers\\LaravelServiceProvider::class
);
```

`Lumen`

- For Lumen, add the following to `bootstrap/app.php`:

```
$app->register(PrajapatiDhara1510\MysqlEncrypt\Providers\LumenServiceProvider::class);
```

### 4. Set encryption key in `.env` file

[](#4-set-encryption-key-in-env-file)

```
APP_AESENCRYPT_KEY=yourencryptionkey

```

Update Models
-------------

[](#update-models)

```