s50
Installing MariaDB.
Install MariaDB.
[root@www ~]# 50_1dnf -y install mariadb-server
s51Configure MariaDB.
[root@www ~]# 51_1vi /etc/my.cnf.d/mariadb-server.cnf
s52Add to [mysqld].
[mysqld] 52_1character-set-server=utf8
s53start up.
[root@www ~]# 53_1systemctl start mariadb
s54Set auto start.
[root@www ~]# 54_1systemctl enable mariadb
s55Initialize.
[root@www ~]# 55_1mysql_secure_installation
s56After the following is displayed, press “Enter”.
Enter current password for root (enter for none):
s57Set the root password.
Set root password? [Y/n] 57_1y New password: Re-enter new password:
s58Reply with ‘y’.
Remove anonymous users? [Y/n] 58_1y
s59Reply with ‘y’.
Disallow root login remotely? [Y/n] 59_1y
s60Reply with ‘y’.
Remove test database and access to it? [Y/n] 60_1y
s61Reply with ‘y’.
Reload privilege tables now? [Y/n] 61_1y
s62Connect to MariaDB as root user.
[root@www ~]# 62_1mysql -u root -p Enter password:
s63Display the user information list.
MariaDB [(none)]> 63_1select user,host,password from mysql.user; +------+-----------+-------------------------------------------+ | user | host | password | +------+-----------+-------------------------------------------+ | root | localhost | ***************************************** | | root | 127.0.0.1 | ***************************************** | | root | ::1 | ***************************************** | +------+-----------+-------------------------------------------+ 3 rows in set (0.00 sec)
s64Display the database list.
MariaDB [(none)]> 64_1show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | +--------------------+ 3 rows in set (0.00 sec)
s65Exit.
MariaDB [(none)]> 65_1exit
s66
Install phpMyAdmin
Install and start httpd.
s67Have PHP installed.
s68Download phpMyAdmin and unzip it.
[root@www ~]# 68_1dnf -y install phpMyAdmin php-mysqlnd php-mcrypt php-php-gettext
s69Configure phpMyAdmin.
[root@www ~]# 69_1vi /etc/httpd/conf.d/phpMyAdmin.conf
s70Line 13: Add access permission IP.
70_1Require ip 127.0.0.1 192.168.1.1/24
s71Line 19: Add access permission IP.
71_1Require ip 127.0.0.1 192.168.1.1/24
s72Restart.
[root@www ~]# 72_1systemctl restart httpd
s73Start a web browser, access the following URL, authenticate as a registered user, and log in. (You can operate MariaDB from the management screen.)
http://fedoraserver.jp/phpmyadmin/
コメント