MariaDB : Install2025/11/17 |
|
Install MariaDB to configure Database Server. |
|
| [1] | Install MariaDB Server. |
|
[root@www ~]#
dnf -y install mariadb-server
[root@www ~]#
vi /etc/my.cnf.d/charset.cnf # create new # set default charaset # if not set, default is [latin1] # for the case of 4 bytes UTF-8, specify [utf8mb4] # for the case of 3 bytes UTF-8, specify [utf8mb3] (deprecated) # [utf8] ⇒ alias of [utf8mb3] [mysqld] character-set-server = utf8mb4 [client] default-character-set = utf8mb4 systemctl enable --now mariadb |
| [2] | If Firewalld is running and also you allow to access MariaDB Server from remote Hosts, allow service. MariaDB uses [3306/TCP]. |
|
[root@www ~]# firewall-cmd --add-service=mysql success [root@www ~]# firewall-cmd --runtime-to-permanent success |
| [3] | Check the operation of MariaDB. |
|
# connect to MariaDB with root [root@www ~]# mariadb Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 10.11.13-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. # [Unix_Socket] authentication for root user is enabled by default MariaDB [(none)]> show grants for root@localhost; +-----------------------------------------------------------------------------------------------------------------------------------------+ | Grants for root@localhost | +-----------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket WITH GRANT OPTION | | GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION | +-----------------------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.000 sec) # show user list MariaDB [(none)]> select user,host,password from mysql.user; +-------------+-----------+----------+ | User | Host | Password | +-------------+-----------+----------+ | mariadb.sys | localhost | | | root | localhost | invalid | | mysql | localhost | invalid | +-------------+-----------+----------+ 3 rows in set (0.002 sec) # show database list MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.000 sec) # create test database MariaDB [(none)]> create database test_database; Query OK, 1 row affected (0.000 sec) # create test table on test database MariaDB [(none)]> create table test_database.test_table (id int, name varchar(50), address varchar(50), primary key (id)); Query OK, 0 rows affected (0.108 sec) # insert data to test table MariaDB [(none)]> insert into test_database.test_table(id, name, address) values("001", "Fedora", "Hiroshima"); Query OK, 1 row affected (0.036 sec) # show test table MariaDB [(none)]> select * from test_database.test_table; +----+--------+-----------+ | id | name | address | +----+--------+-----------+ | 1 | Fedora | Hiroshima | +----+--------+-----------+ 1 row in set (0.000 sec) # delete test database MariaDB [(none)]> drop database test_database; Query OK, 1 row affected (0.111 sec) MariaDB [(none)]> exit Bye |
| [4] | If you'd like to delete all data of MariaDB and initialize it, run like follows. |
|
[root@www ~]# systemctl stop mariadb [root@www ~]# rm -rf /var/lib/mysql/* [root@www ~]# mysql_install_db --datadir=/var/lib/mysql --user=mysql [root@www ~]# systemctl start mariadb |
| Sponsored Link |
|
|