PENGANTAR TEKNOLOGI INFORMASI KOMUNIKASI

Install phpMyAdmin to operate MySQL 5.6 on web browser from Clients. [1] Install and start Apache httpd, refer to here . [2] Install PHP, refer to here . [3] Install phpMyAdmin. # install from EPEL [root@www ~]# yum --enablerepo=epel -y install phpMyAdmin php-mysql php-mcrypt [root@www ~]# vi /etc/httpd/conf.d/phpMyAdmin.conf # line 25: IP address you permit to access Allow from 127.0.0.1 10.0.0.0/24 # line 42: IP address you permit to access Allow from 127.0.0.1 10.0.0.0/24 [root@www ~]# /etc/rc.d/init.d/httpd restart [4] Access to 'http://(your hostname or IP address)/phpmyadmin/' with web browser from Clients, then Login with a user in MySQL on following screen. This example uses root user to proceed. [5] Just logined. You can operate MySQL on here. [6] It's possible to change settings of MySQL on "http://(your hostname or IP address)/phpmyadmin/setup".

Install MariaDB 10.1 2016/08/08 Install MariaDB 10.1 to configure Database Server. [1] It's possible to install from CentOS SCLo Software Collections . It's OK to install it even if Other MySQL or MariaDB is already installed because MariaDB 10.1 is located on another PATH. # install from SCLo [root@www ~]# yum --enablerepo=centos-sclo-rh -y install rh-mariadb101-mariadb-server [2] Packages from Software Collections are installed uder the /opt directory. To use it, Load environment variables like follows. # load environment variables [root@www ~]# scl enable rh-mariadb101 bash [root@www ~]# mysql -V mysql Ver 15.1 Distrib 10.1.14-MariaDB, for Linux (x86_64) using EditLine wrapper [root@www ~]# which mysql /opt/rh/rh-mariadb101/root/usr/bin/mysql [3] To enable MariaDB 10.1 automatically at login time, configure like follows. [root@www ~]# vi /etc/profile.d/rh-mariadb101.sh # create new...