The 4 commands below will create a new database and user with full permissions on MySql: CREATE DATABASE mautic; CREATE USER ‘mautic’@’localhost’ IDENTIFIED BY ‘WowThat’sALongOne!’; GRANT ALL PRIVILEGES ON mautic.* TO ‘mautic’@’localhost’; FLUSH PRIVILEGES;
Quick run through getting NGINX, PHP and MySQL running on FreeBSD 11.1 colin@openproject:~ % sudo pkg install -y nginx mysql56-server php56 php56-mysql … colin@openproject:~ % sudo sysrc mysql_enable=YES; sudo sysrc nginx_enable=YES; sudo sysrc php_fpm_enable=YES colin@openproject:~ % sudo mv /usr/local/etc/php-fpm.conf ./php-fpm.conf.bak colin@openproject:~ % sed s/’listen = 127.0.0.1:9000’/’listen = \/var\/run\/php-fpm.sock’/g ./php-fpm.conf.bak | sed s/’;listen.owner = www’/’listen.owner =[…]
