Instal Database di CentOS 7

 

Install Database Server

Server database yang digunakan pada cara install phpMyAdmin dengan Apache di CentOS 7 ini adalah MariaDB, karena MariaDB adalah server database paling up-to-date dan kompatibel saat ini. 

$ yum install mariadb-server mariadb -y

 

Start dan enable on-boot layanan MariaDB kemudian lakukan secure installation.

$ systemctl enable mariadb
$ systemctl start mariadb

$ mysql_secure_installation

Enter current password for root (enter for none): 
OK, successfully used password, moving on...


Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n] y
New password: 
Re-enter new password: 
Password updated successfully!
Reloading privilege tables..
 ... Success!

Remove anonymous users? [Y/n] y
 ... Success!

Disallow root login remotely? [Y/n] y
 ... Success!

Remove test database and access to it? [Y/n] y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!


Reload privilege tables now? [Y/n] y
 ... Success!

Cleaning up...

All done! If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!