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

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

jfelixstudio/laravel-mysql-encrypt
==================================

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

1.4(4y ago)13.6k1MITPHPPHP ^7.3|^8.0

Since Dec 30Pushed 4y agoCompare

[ Source](https://github.com/JfelixStudio/laravel-mysql-encrypt)[ Packagist](https://packagist.org/packages/jfelixstudio/laravel-mysql-encrypt)[ RSS](/packages/jfelixstudio-laravel-mysql-encrypt/feed)WikiDiscussions master Synced yesterday

READMEChangelog (7)Dependencies (2)Versions (21)Used By (0)

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

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

[![Latest Stable Version](https://camo.githubusercontent.com/5209b2e366bd535bf82398c4b70153ac05abf202d665ba2d141663a7635807fa/68747470733a2f2f706f7365722e707567782e6f72672f4a66656c697853747564696f2f6c61726176656c2d6d7973716c2d656e63727970742f76)](//packagist.org/packages/JfelixStudio/laravel-mysql-encrypt) [![Latest Unstable Version](https://camo.githubusercontent.com/b91db4d6268156306a1e97c8975005e6cd4ffef1641e72de3c5d3033f63d1dab/68747470733a2f2f706f7365722e707567782e6f72672f4a66656c697853747564696f2f6c61726176656c2d6d7973716c2d656e63727970742f762f756e737461626c65)](//packagist.org/packages/JfelixStudio/laravel-mysql-encrypt) [![Total Downloads](https://camo.githubusercontent.com/7d27ff6b8ff5f2ae238522006e3dc54d224c15bd99a48c8fcb9de1f6ff54127a/68747470733a2f2f706f7365722e707567782e6f72672f4a66656c697853747564696f2f6c61726176656c2d6d7973716c2d656e63727970742f646f776e6c6f616473)](//packagist.org/packages/JfelixStudio/laravel-mysql-encrypt) [![License](https://camo.githubusercontent.com/5dc81b13365bb9a298bba9134bf78b377c8e369d89bad4219378eb9714fee280/68747470733a2f2f706f7365722e707567782e6f72672f4a66656c697853747564696f2f6c61726176656c2d6d7973716c2d656e63727970742f6c6963656e7365)](//packagist.org/packages/JfelixStudio/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 JfelixStudio/laravel-mysql-encrypt
```

### 2. Publish config (optional)

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

`Laravel`

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

`Lumen`

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

`Lumen`

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

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

```