Fedora36: Database settings

Installing MariaDB.

Install MariaDB.

[root@www ~]# dnf -y install mariadb-server

Configure MariaDB.

[root@www ~]# vi /etc/my.cnf.d/mariadb-server.cnf

Add to [mysqld].


start up.

[root@www ~]# systemctl start mariadb

Set auto start.

[root@www ~]# systemctl enable mariadb


[root@www ~]# mysql_secure_installation

After the following is displayed, press “Enter”.

Enter current password for root (enter for none):

Set the root password.

Set root password? [Y/n] y
New password:
Re-enter new password:

Reply with ‘y’.

Remove anonymous users? [Y/n] y

Reply with ‘y’.

Disallow root login remotely? [Y/n] y

Reply with ‘y’.

Remove test database and access to it? [Y/n] y

Reply with ‘y’.

Reload privilege tables now? [Y/n] y

Connect to MariaDB as root user.

[root@www ~]# mysql -u root -p
Enter password:

Display the user information list.

MariaDB [(none)]> select user,host,password from mysql.user;
| user | host      | password                                  |
| root | localhost | ***************************************** |
| root | | ***************************************** |
| root | ::1       | ***************************************** |
3 rows in set (0.00 sec)

Display the database list.

MariaDB [(none)]> show databases;
| Database |
| information_schema |
| mysql |
| performance_schema |
3 rows in set (0.00 sec)


MariaDB [(none)]> exit

Install phpMyAdmin

Install and start httpd.


Have PHP installed.


Download phpMyAdmin and unzip it.

[root@www ~]# dnf -y install phpMyAdmin php-mysqlnd php-mcrypt php-php-gettext

Configure phpMyAdmin.

[root@www ~]# vi /etc/httpd/conf.d/phpMyAdmin.conf

Line 13: Add access permission IP.

Require ip

Line 19: Add access permission IP.

Require ip


[root@www ~]# systemctl restart httpd

Start a web browser, access the following URL, authenticate as a registered user, and log in. (You can operate MariaDB from the management screen.)