Fedora36: Database settings - Recommended for beginners! How to make a home server Fedora36 that can be copied and pasted.

s50

🔗

Installing MariaDB.
Install phpMyAdmin

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.

httpd

s67Have PHP installed.

PHP

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/