Many people use phpmyadmin, but we’re going to do this properly to add users, databases and privileges. Heres how I did it.
Please note that this is a work in progress and is not finished yet .
Install httpd and mysql-server
yum install httpd mariadb-server php php-mysql
What you might find is that drupal 8 requires php5.5.9 lets install that;
[root@web-test-centos7 html]# yum install centos-release-scl [root@web-test-centos7 html]# yum install php55-php-mysqlnd
Open Firewall port 80 http for CentOS
sudo iptables -I INPUT 1 -p tcp --dport 80 -j ACCEPT sudo iptables -I INPUT 1 -p tcp --dport 443 -j ACCEPT
Save firewall rules in CentOS
/etc/init.d/iptables save
Alternatively, save firewall rules Ubuntu
iptables-save > /etc/iptables.rules
Save firewall rules for all other distros
iptables-save > /etc/sysconfig/iptables
Connect to MysQL to configure database user ‘drupal’
# mysql -u root Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 5.5.47-MariaDB MariaDB Server Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Create Drupal database
MariaDB [(none)]> create database drupal;
Grant ability to connect with drupal user
MariaDB [(none)]> grant usage on *.* to drupal@localhost identified by '@#@DS45Dfddfdgj334k34ldfk;DF'; Query OK, 0 rows affected (0.00 sec)
Grant all Privileges to the user drupal for database drupal
MariaDB [(none)]> grant all privileges on drupal.* to drupal@localhost; Query OK, 0 rows affected (0.00 sec)