PHPackages                             xandanet/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. xandanet/laravel-mysql-encrypt

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

xandanet/laravel-mysql-encrypt
==============================

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

2.0.0(5y ago)0307[1 PRs](https://github.com/xandanet/laravel-mysql-encrypt/pulls)MITPHPPHP ^7.2.5

Since Jan 4Pushed 5y ago1 watchersCompare

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

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

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

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

[![Latest Stable Version](https://camo.githubusercontent.com/11c02b9200a17d43926e575454869515b0f268818d0f970e340049aef075ad31/68747470733a2f2f706f7365722e707567782e6f72672f78616e64616e65742f6c61726176656c2d6d7973716c2d656e63727970742f76)](//packagist.org/packages/xandanet/laravel-mysql-encrypt) [![Latest Unstable Version](https://camo.githubusercontent.com/282db66a0080d922715a42651e49ab08bcf3b07a65f418f717f1196168eca5f9/68747470733a2f2f706f7365722e707567782e6f72672f78616e64616e65742f6c61726176656c2d6d7973716c2d656e63727970742f762f756e737461626c65)](//packagist.org/packages/xandanet/laravel-mysql-encrypt) [![Total Downloads](https://camo.githubusercontent.com/cbc88a1ab860f26fc1b931f34bae5cdd21c54e3636f2aef49406a9cc1945c5d8/68747470733a2f2f706f7365722e707567782e6f72672f78616e64616e65742f6c61726176656c2d6d7973716c2d656e63727970742f646f776e6c6f616473)](//packagist.org/packages/xandanet/laravel-mysql-encrypt) [![License](https://camo.githubusercontent.com/241f9b7327f7bbb688882c507f5a4d5fad5294ea9bfcea64934b47077ebc9197/68747470733a2f2f706f7365722e707567782e6f72672f78616e64616e65742f6c61726176656c2d6d7973716c2d656e63727970742f6c6963656e7365)](//packagist.org/packages/xandanet/laravel-mysql-encrypt)

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 xandanet/laravel-mysql-encrypt
```

### 2. Publish config (optional)

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

`Laravel`

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

`Lumen`

```
mkdir -p config
cp vendor/xandanet/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(
    XandaNet\\MysqlEncrypt\\Providers\\LaravelServiceProvider::class
);
```

`Lumen`

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

```
$app->register(XandaNet\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)

```