Magento instalation

install.sh

# mysql -uroot -p

# CREATE DATABASE `magento_local` CHARACTER SET utf8 COLLATE utf8_general_ci;
# GRANT ALL PRIVILEGES ON  magento_local.* TO magento@localhost IDENTIFIED BY 'magentoPass';
# GRANT SELECT, INSERT, UPDATE, DELETE, \
#       CREATE, DROP, REFERENCES, INDEX, ALTER, \
#       CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, \
#       CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, \
#       EVENT, TRIGGER \
#       ON  `magento_local`.* \
#       TO magento@"localhost" IDENTIFIED BY 'magentoPass';

# php composer install
# sudo chown -R www-data:www-data var generated pub/static pub/media

sudo -H -u www-data php bin/magento setup:install \
--base-url="http://magento.local/" \
--backend-frontname="b" \
--db-host="localhost" \
--db-name="magento_local" \
--db-user="magento" \
--db-password="magentoPass" \
--language="en_US" \
--timezone="UTC" \
--currency="GBP" \
--use-rewrites="1" \
--use-secure="1" \
--admin-user="admin" \
--admin-password="123123q" \
--admin-email="[email protected]" \
--admin-firstname="A" \
--admin-lastname="B" \

post-install.sh

sudo chown -R www-data:www-data \
  app/etc \
  var \
  generated \
  pub/static \
  pub/media

pre-install.sql

 CREATE DATABASE `magento_local` CHARACTER SET utf8 COLLATE utf8_general_ci;
 GRANT ALL PRIVILEGES ON  magento_local.* TO magento@localhost IDENTIFIED BY 'magentoPass';
 GRANT SELECT, INSERT, UPDATE, DELETE, \
       CREATE, DROP, REFERENCES, INDEX, ALTER, \
       CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, \
       CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, \
       EVENT, TRIGGER \
       ON  `magento_local`.* \
       TO magento@"localhost" IDENTIFIED BY 'magentoPass';