CentOS Linux release 8.0.1905 (Core) Minimal install with gcc related, vim, git
web
Install_and_configure_apache2.4.37
[[email protected] ~]# dnf install httpd httpd-devel httpd-tools mod_ssl -y
[[email protected] ~]# httpd -v
Server version: Apache/2.4.37 (centos)
Server bui lt: Oct 7 2019 21:42:02
[[email protected] ~]# cd /etc/httpd/conf/
[[email protected] /etc/httpd/conf]# cp httpd.conf httpd.conf.bk
[[email protected] /etc/httpd/conf]# cat httpd.conf.bk | egrep -v "(\#|^$)" > httpd.conf
[[email protected] /etc/httpd/conf]# vim httpd.conf
-:Listen 80
+:Listen 0.0.0.0:80
-: DirectoryIndex index.html
+: DirectoryIndex index.php index.html index.cgi
(Added at the end)
ServerTokens Prod
[[email protected] /etc/httpd/conf]# cd
[[email protected] ~]# firewall-cmd --list-all
services: cockpit dhcpv6-client ssh
[[email protected] ~]# firewall-cmd --remove-service={dhcpv6-client,cockpit} --zone=public --permanent
[[email protected] ~]# firewall-cmd --add-serevice={http,https} --zone=public --permanent
[[email protected] ~]# firewall-cmd --reload
[[email protected] ~]# firewall-cmd --list-all
services: http https ssh
[[email protected] ~]# echo "test page" > /var/www/html/index.html
[[email protected] ~]# chmod -R apache:apache /var/www
[[email protected] ~]# systemctl start httpd
[[email protected] ~]# systemctl enable httpd
Access http: // server IP / with a browser, and if it is displayed, it is OK.
PHP
Install_and_configure_php7.2.11
[[email protected] ~]# dnf install php php-fpm php-mbstring \
php-devel php-mysqlnd -y
[[email protected] ~]# php -v
PHP 7.2.11 (cli) (built: Oct 9 2018 15:09:36) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
[[email protected] ~]# vim /etc/php.ini
-:;date.timezone =
+:date.timezone = Asia/Tokyo
-:expose_php = On
+:expose_php = Off
-:;mbstring.language = Japanese
+:mbstring.language = Japanese
-:;mbstring.internal_encoding =
+:mbstring.internal_encoding = UTF-8
-:;mbstring.http_input =
+:mbstring.http_input = UTF-8
-:;mbstring.http_output =
+:mbstring.http_output = UTF-8
-:;mbstring.encoding_translation = Off
+:mbstring.encoding_translation = On
-:;mbstring.detect_order = auto
+:mbstring.detect_order = auto
-:;mbstring.substitute_character = none
+:mbstring.substitute_character = none
[[email protected] ~]# echo -n '<?php\nphpinfo();\n?>' > /var/www/html/index.php
[[email protected] ~]# cp /etc/php-fpm.d/www.conf /etc/php-fpm.d/www.conf.bk
[[email protected] ~]# vim /etc/php-fpm.d/www.conf
-:;listen.owner = nobody
+:listen.owner = apache
-:;listen.group = nobody
+:listen.group = apache
-:;listen.mode = 0660
+:listen.mode = 0660
[[email protected] ~]# systemctl restart httpd
Access http: // server IP / index.php with a browser, and if phpinfo () is displayed, it's OK.
mysql
Install_and_configure_mysql8.0
[[email protected] ~]# dnf install mysql-server mysql-devel -y
[[email protected] ~]# vim /etc/my.cnf.d/mysql-server.cnf
(Added at the end)
+:character-set-server=utf8
+:bind-address=0.0.0.0
#+:collation-server=utf8_unicode_ci
[[email protected] ~]# vim /etc/my.cnf
([client]Added directly below)
+:default-character-set=utf8
+:[mysql]
+:default-character-set=utf8
[[email protected] ~]# cp /usr/lib/systemd/system/mysqld.service \
/etc/systemd/system/
[[email protected] ~]# vim /etc/systemd/system/mysqld.service
-:ExecStart=/usr/libexec/mysqld --basedir=/usr
+:ExecStart=/usr/libexec/mysqld --basedir=/usr --skip-mysqlx
[[email protected] ~]# systemctl daemon-reload
[[email protected] ~]# systemctl start mysqld.service
[[email protected] ~]# systemctl status mysqld.service
Active: active (running)
[[email protected] ~]# netstat -ant
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
[[email protected] ~]# mysql -u root
(* Uppercase letters below are optional)
mysql> create database DBNAME;
mysql> create user [email protected];
mysql> grant all privileges on DBNAME.* to [email protected];
mysql> alter user [email protected] identified by 'PASSWORD';
mysql> quit;
[[email protected] ~]# vim test.php
<?php
try {
$dbcon = new PDO('mysql:host=localhost;dbname=DBNAME','USERNAME','PASSWORD');
printf("success\n");
}
catch(PDOException $e){
printf("failure\n");
exit;
}
?>
[[email protected] ~]# php test.php
success
[[email protected] ~]# firewall-cmd --add-service=mysql --zone=public --permanent
[[email protected] ~]# firewall-cmd --reload
[[email protected] ~]# firewall-cmd --list-all
services: http https mysql ntp samba samba-client ssh
So far for the time being. I'm not good at SQL so I always search I wonder why it is often all capitalized.
Recommended Posts