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_installationEnter 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!
