We will install the packages directly from the repository of Rocky Linux. In this tutorial, I will show you how easily we can install and configure MariaDB on Rocky Linux in just a few steps. But with open-source software, there are often many, many choices for various platforms and operating systems. If you have any questions or feedback, feel free to leave a comment.There are several ways that we can install and maintain the databases, including commercial products like Microsoft SQL Server or Oracle. In this tutorial, we’ve shown you how to install and secure MariaDB on CentOS 8, and how to connect to the MariaDB server from the command line. Type '\c' to clear the current input statement. Server version: 10.4.12-MariaDB MariaDB ServerĬopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
To connect to the MariaDB server through the terminal as the root account type: # mysql -u root -pĮnter the root password when prompted, and you will be presented with the MariaDB shell, as shown below: # mysql -u root -p That’s it! You have installed and secured MariaDB on your CentOS server, and you’re ready to use it. You should answer “Y” (yes) to all questions.
Once you do that, the script will also ask you to remove the anonymous user, restrict root user access to the local machine, and remove the test database. You will be prompted to set a password for the MariaDB root user. Run the script by typing: # mysql_secure_installation MariaDB server package comes with a script called mysql_secure_installation performs several security-related operations, and sets the root password. Loaded: loaded (/usr/lib/systemd/system/rvice enabled vendor preset: disabled)ĭrop-In: /etc/systemd/system/Īctive: active (running) since Thu 19:25:16 UTC 8s ago
0 kommentar(er)
