yum install mariadb mariadb-server mysql<\/p>\n
INSTALL MARIA DB<\/p>\n
MariaDB is the default database server in CentOS 7, so go ahead and install it with yum using the following command:<\/p>\n
## yum install mariadb mariadb-server mysql<\/p>\n
Once installed, add bind-address = 127.0.0.1 to \/etc\/my.cnf.d\/server.cnf to bind MariaDB to localhost only:<\/p>\n
## vim \/etc\/my.cnf.d\/server.cnf<\/p>\n
[mysqld]
\n#log-bin=mysql-bin
\n#binlog_format=mixed
\nbind-address = 127.0.0.1<\/p>\n
[root@testserver7 my.cnf.d]# systemctl restart mariadb
\n[root@testserver7 my.cnf.d]# systemctl status mariadb
\nmariadb.service – MariaDB database server
\n Loaded: loaded (\/usr\/lib\/systemd\/system\/mariadb.service; enabled)
\n Active: active (running) since Fri 2015-02-06 09:17:59 SGT; 2s ago
\n Process: 9179 ExecStartPost=\/usr\/libexec\/mariadb-wait-ready $MAINPID (code=exited, status=0\/SUCCESS)
\n Process: 9150 ExecStartPre=\/usr\/libexec\/mariadb-prepare-db-dir %n (code=exited, status=0\/SUCCESS)
\n Main PID: 9178 (mysqld_safe)
\n CGroup: \/system.slice\/mariadb.service
\n ??9178 \/bin\/sh \/usr\/bin\/mysqld_safe –basedir=\/usr
\n ??9348 \/usr\/libexec\/mysqld –basedir=\/usr –datadir=\/var\/lib\/mysql –plugin-dir=\/usr\/lib64\/mysql\/plugin –log-erro…<\/p>\n
Feb 06 09:17:57 testserver7 systemd[1]: Starting MariaDB database server…
\nFeb 06 09:17:57 testserver7 mysqld_safe[9178]: 150206 09:17:57 mysqld_safe Logging to ‘\/var\/log\/mariadb\/mariadb.log’.
\nFeb 06 09:17:57 testserver7 mysqld_safe[9178]: 150206 09:17:57 mysqld_safe Starting mysqld daemon with databases from \/…\/mysql
\nFeb 06 09:17:59 testserver7 systemd[1]: Started MariaDB database server.
\nHint: Some lines were ellipsized, use -l to show in full.
\nHint: Some lines were ellipsized, use -l to show in full.
\n[root@testserver7 my.cnf.d]# systemctl enable mariadb
\nln -s ‘\/usr\/lib\/systemd\/system\/mariadb.service’ ‘\/etc\/systemd\/system\/multi-user.target.wants\/mariadb.service’
\n[root@testserver7 my.cnf.d]#
\n[
\n\/usr\/bin\/mysqladmin -u root password ‘test123’<\/p>\n
\/usr\/bin\/mysqladmin -u root -h testserver7 password ‘test123′<\/p>\n
update mysql.user set password=PASSWORD(“test123”) where User=’root’;<\/p>\n
Reset root password
\n [root@testserver7 my.cnf.d]# mysql -u root
\nWelcome to the MariaDB monitor. Commands end with ; or \\g.
\nYour MariaDB connection id is 1
\nServer version: 5.5.41-MariaDB MariaDB Server<\/p>\n
Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.<\/p>\n
Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/p>\n
MariaDB [(none)]> update mysql.user set password=PASSWORD(“test123”) where User=’root’;
\nQuery OK, 3 rows affected (0.00 sec)
\nRows matched: 3 Changed: 3 Warnings: 0<\/p>\n
MariaDB [(none)]> flush privileges;
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n
MariaDB [(none)]> quit
\nBye
\n[root@testserver7 my.cnf.d]#<\/p>\n
## mysql_secure_installation<\/p>\n
Enter current password for root (enter for none): ENTER
\nSet root password? [Y\/n] Y
\nRemove anonymous users? [Y\/n] Y
\nDisallow root login remotely? [Y\/n] Y
\nRemove test database and access to it? [Y\/n] Y
\nReload privilege tables now? [Y\/n] Y<\/p>\n
root@testserver7 my.cnf.d]# systemctl restart httpd
\n[root@testserver7 my.cnf.d]# systemctl status httpd
\nhttpd.service – The Apache HTTP Server
\n Loaded: loaded (\/usr\/lib\/systemd\/system\/httpd.service; enabled)
\n Active: active (running) since Fri 2015-02-06 09:47:33 SGT; 17s ago
\n Process: 10372 ExecStop=\/bin\/kill -WINCH ${MAINPID} (code=exited, status=0\/SUCCESS)
\n Main PID: 10377 (httpd)
\n Status: “Total requests: 0; Current requests\/sec: 0; Current traffic: 0 B\/sec”
\n CGroup: \/system.slice\/httpd.service
\n ??10377 \/usr\/sbin\/httpd -DFOREGROUND
\n ??10379 \/usr\/sbin\/httpd -DFOREGROUND
\n ??10380 \/usr\/sbin\/httpd -DFOREGROUND
\n ??10381 \/usr\/sbin\/httpd -DFOREGROUND
\n ??10382 \/usr\/sbin\/httpd -DFOREGROUND
\n ??10383 \/usr\/sbin\/httpd -DFOREGROUND<\/p>\n
Feb 06 09:47:28 testserver7 systemd[1]: Starting The Apache HTTP Server…
\nFeb 06 09:47:33 testserver7 httpd[10377]: AH00558: httpd: Could not reliably determine the server’s fully qualified dom…essage
\nFeb 06 09:47:33 testserver7 systemd[1]: Started The Apache HTTP Server.
\nHint: Some lines were ellipsized, use -l to show in full.
\n[root@testserver7 my.cnf.d]# systemctl enable httpd<\/p>\n
\/etc\/httpd\/conf.d<\/p>\n
vi harden.conf<\/p>\n
TraceEnable off<\/p>\n
## Disable Signature
\nServerSignature Off<\/p>\n
## Disable Banner
\nServerTokens Prod<\/p>\n
[root@testserver7 conf.d]# apachectl configtest
\nAH00558: httpd: Could not reliably determine the server’s fully qualified domain name, using 192.168.1.3. Set the ‘ServerName’ directive globally to suppress this message
\nSyntax OK
\n[root@testserver7 conf.d]#<\/p>\n
K, let\u2019s continue with PHP configuration. Edit \/etc\/php.ini and set the following:<\/p>\n
## vim \/etc\/php.ini<\/p>\n
date.timezone = America\/New_York
\nmemory_limit = 64M
\nexpose_php = Off<\/p>\n
restart Apache using systemctl for the changes to take effect:<\/p>\n
## systemctl restart httpd
\n## systemctl status httpd<\/p>\n
Test if PHP module is loaded in Apache using:<\/p>\n
## httpd -M | grep php<\/p>\n
also<\/p>\n
## php -v<\/p>\n
You can create a test info.php script too using the following command:<\/p>\n
## echo -e “ \/var\/www\/html\/info.php<\/p>\n
and access it with the following command:<\/p>\n
## curl -I $(curl -s icanhazip.com)\/info.php<\/p>\n
SET-UP APACHE VHOSTS<\/p>\n
Now, you would have to set-up Apache Virtual Host Directives, to be able to host multiple domains, even SSL powered ones using one IP address. So, create \/etc\/httpd\/conf.d\/vhosts.conf and add the following:<\/p>\n
## cat \/etc\/httpd\/conf.d\/vhosts.conf<\/p>\n
# Load my vhosts
\nIncludeOptional vhosts.d\/*.conf<\/p>\n
This tells Apache, to load the configuration files ending with .conf which reside in \/etc\/httpd\/vhosts.d. As you can guess, this is the place where we put our Virtual Hosts, so let\u2019s set-up one for domain1.com and another for domain2.net
\nVHOST for domain1.com<\/p>\n
## cat \/etc\/httpd\/vhosts.d\/domain1.com.conf<\/p>\n
VHOST for domain2.net<\/p>\n ## cat \/etc\/httpd\/vhosts.d\/domain2.net.conf<\/p>\n Finally, restart Apache for the changes to take effect:<\/p>\n ## apachectl configtest yum install mariadb mariadb-server mysql<\/p>\n INSTALL MARIA DB<\/p>\n MariaDB is the default database server in CentOS 7, so go ahead and install it with yum using the following command:<\/p>\n ## yum install mariadb mariadb-server mysql<\/p>\n Once installed, add bind-address = 127.0.0.1 to \/etc\/my.cnf.d\/server.cnf to bind MariaDB to localhost only:<\/p>\n ## vim \/etc\/my.cnf.d\/server.cnf<\/p>\n [mysqld] #log-bin=mysql-bin #binlog_format=mixed […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4191"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4191"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4191\/revisions"}],"predecessor-version":[{"id":4192,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4191\/revisions\/4192"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n ServerAdmin webmaster@domain1.com
\n DocumentRoot “\/var\/www\/html\/domain1.com”
\n ServerName domain1.com
\n ServerAlias www.domain1.com
\n ErrorLog “\/var\/log\/httpd\/domain1.com-error_log”
\n CustomLog “\/var\/log\/httpd\/domain1.com-access_log” combined<\/p>\n
\n DirectoryIndex index.html index.php
\n Options FollowSymLinks
\n AllowOverride All
\n Require all granted
\n <\/Directory>
\n<\/VirtualHost><\/p>\n
\n ServerAdmin webmaster@domain2.net
\n DocumentRoot “\/var\/www\/html\/domain2.net”
\n ServerName domain2.net
\n ServerAlias www.domain2.net
\n ErrorLog “\/var\/log\/httpd\/domain2.net-error_log”
\n CustomLog “\/var\/log\/httpd\/domain2.net-access_log” combined<\/p>\n
\n DirectoryIndex index.html index.php
\n Options FollowSymLinks
\n AllowOverride All
\n Require all granted
\n <\/Directory>
\n<\/VirtualHost><\/p>\n
\n## systemctl restart httpd
\n## systemctl status httpd<\/p>\n","protected":false},"excerpt":{"rendered":"