Ch-center
Tutorials for centos 7
User avatar
By adm_3ch
#151
Before we get started you’ll need to login to your server via SSH. If you’re not certain how to do this, don’t worry we’ve got you covered as we have written a guide that will show you the ins and outs of Connecting to Your Server via SSH. Once connected you may move on to the rest of this article. MariaDB is now the preferred database management system for CentOS 7 and as such is very simple to install:
Code: Select all
#  <span style="font-family: 'Open Sans';">yum install mariadb-server</span>
Once you confirm the installation, that one line should take care of everything that is required to install MariaDB in CentOS 7. Once installed you’ll need to start MariaDB and ensure that it always starts at boot by issuing these commands:
Code: Select all
#  <span style="font-family: 'Open Sans';">systemctl start mariadb
#  systemctl enable mariadb</span>
To ensure that MariaDB started successfully it is advised to use the following command to check its status:
Code: Select all
#  <span style="font-family: 'Open Sans';">systemctl status mariadb</span>
Last but not least you’ll need to execute the security script for MariaDB, which allows  you to change the default MariaDB root user password.
Code: Select all
#  <span style="font-family: 'Open Sans';">mysql_secure_installation</span>
Follow the on screen instructions to change the password and finalize your MariaDB installation. If everything completed without any errors, MariaDB should now be fully functional on your server!
a-zet
SPECIAL DEDICATED SERVER OFFER - LIMITED STOCK LEFT

Intel® Xeon 2.53GHz [...]