# UPDATED Aug 15 2018 - Script 100% auto install on Debian 9. Apache, MPM Event, php-fpm socket, Redis socket on both local and locking cache, LRU data eviction, LetsEncrypt SSL A+ **URL:** \ **Category:** đź“‘ How to\ **Created:** [October 7, 2017, 11:40pm UTC](https://help.nextcloud.com/t/updated-aug-15-2018-script-100-auto-install-on-debian-9-apache-mpm-event-php-fpm-socket-redis-socket-on-both-local-and-locking-cache-lru-data-eviction-letsencrypt-ssl-a/22054 "2017-10-07T23:40:34Z")\ **Posts on this page:** 4\ **Page:** 2
**Author:** ![onryo](https://help.nextcloud.com/letter_avatar/onryo/32/6_22734026db12803ebb3e059622ac3534.png) [@onryo](https://help.nextcloud.com/u/onryo)\ **Post date:** [August 15, 2018, 1:06am UTC](https://help.nextcloud.com/t/updated-aug-15-2018-script-100-auto-install-on-debian-9-apache-mpm-event-php-fpm-socket-redis-socket-on-both-local-and-locking-cache-lru-data-eviction-letsencrypt-ssl-a/22054/25 "2018-08-15T01:06:13Z")
Thanks for the tip! Really wanted to avoid using backports. Changed the script and improved it a bunch. Should work now! ---
**Author:** ![jas4711](https://help.nextcloud.com/user_avatar/help.nextcloud.com/jas4711/32/7209_2.png) [@jas4711](https://help.nextcloud.com/u/jas4711)\ **Post date:** [August 26, 2018, 3:21pm UTC](https://help.nextcloud.com/t/updated-aug-15-2018-script-100-auto-install-on-debian-9-apache-mpm-event-php-fpm-socket-redis-socket-on-both-local-and-locking-cache-lru-data-eviction-letsencrypt-ssl-a/22054/26 "2018-08-26T15:21:10Z")
Neat trick for mysql\_secure\_installation! However, on modern Debian/Ubuntu systems, the script is no-op. Read the script to see what it does – by default, there is no anonymous user, test database or remote root accounts. Try to run (as you described) “SELECT User, Host, password, plugin from mysql.user;” on a fresh MariaDB installation. ---
**Author:** ![onryo](https://help.nextcloud.com/letter_avatar/onryo/32/6_22734026db12803ebb3e059622ac3534.png) [@onryo](https://help.nextcloud.com/u/onryo)\ **Post date:** [August 31, 2018, 10:27pm UTC](https://help.nextcloud.com/t/updated-aug-15-2018-script-100-auto-install-on-debian-9-apache-mpm-event-php-fpm-socket-redis-socket-on-both-local-and-locking-cache-lru-data-eviction-letsencrypt-ssl-a/22054/29 "2018-08-31T22:27:12Z")
I have not yet tried the script with Ubuntu or Debian Testing. This script is for for Debian stable (aka Debian 9) Have they removed those questions in upstream versions of mysql\_secure\_installation ? Thanks for the heads up. ---
**Author:** ![JasonBayton](https://help.nextcloud.com/user_avatar/help.nextcloud.com/jasonbayton/32/297_2.png) [@JasonBayton](https://help.nextcloud.com/u/JasonBayton)\ **Post date:** [January 26, 2019, 9:30pm UTC](https://help.nextcloud.com/t/updated-aug-15-2018-script-100-auto-install-on-debian-9-apache-mpm-event-php-fpm-socket-redis-socket-on-both-local-and-locking-cache-lru-data-eviction-letsencrypt-ssl-a/22054/30 "2019-01-26T21:30:35Z")
22 posts were split to a new topic: [Failed authorisation procedure](https://help.nextcloud.com/t/failed-authorisation-procedure/46148) at the request of @onryo [Previous page](https://help.nextcloud.com/t/updated-aug-15-2018-script-100-auto-install-on-debian-9-apache-mpm-event-php-fpm-socket-redis-socket-on-both-local-and-locking-cache-lru-data-eviction-letsencrypt-ssl-a/22054.md?page=1)