Instalasi MySQL pada CentOS

Setelah melakukan Instalasi NGINX Web Server pada CentOS, service pendukung lainnya yang mesti ada pada suatu Web Server ialah Database. Kali ini kita akan menggunakan Database Application yang paling umum digunakan yaitu MySQL.

MySQL Logo

MySQL

MySQL (officially pronounced as /maɪ ˌɛskjuːˈɛl/ "My S-Q-L", and unofficially as /maɪ ˈsiːkwəl/ "My Sequel") is an open-source relational database management system (RDBMS); in July 2013, it was the world's second most widely used RDBMS, and the most widely used open-source client–server model RDBMS. It is named after co-founder Michael Widenius's daughter, My. The SQL acronym stands for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation. For proprietary use, several paid editions are available, and offer additional functionality.

Instalasi MySQL

Instalasi MySQL Database pada CentOS dapat dilakukan dengan langkah-langkah sebagai berikut, namun kali ini kita menggunakan MariaDB yang merupakan aplikasi pengganti MySQL. Lakukan instalasi MariaDB dengan menjalankan perintah berikut,

# yum install mariadb-server mariadb

Kemudian jalankan service mariadb

# systemctl start mariadb

# systemctl enable mariadb

Setelah service MariaDB jalan. Lakukan konfigurasi awal MariaDB dengan menjalankan perintah berikut,

# mysql_secure_installation

Akan muncul beberapa perintah, ikuti sebagai berikut.


NOTE:       RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB                   SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current password for the root user. If you've just installed MariaDB, and you haven't set the root password yet, the password will be blank, so you should just press enter here. 

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

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

You already have a root password set, so you can safely answer 'n'.

Change the root password? [Y/n] Y
New password: (masukkan password)
Re-enter new password: (masukkan password)
... success.

By default, a MariaDB installation has an anonymous user, allowing anyone to log into MariaDB without having to have a user account created for them. This is intended only for testing, and to make the installation go a bit smoother. You should remove them before moving into a production environment.

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

Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the network. Disallow root login remotely? [Y/n] Y
... Success!

By default, MariaDB comes with a database named 'test' that anyone can access. This is also intended only for testing, and should be removed before moving into a production environment. Remove test database and access to it? [Y/n] Y
Removing privileges on test database...
... Success!

Reloading the privilege tables will ensure that all changes made so far will take effect immediately. 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!.
Setelah itu, MariaDB telah dapat digunakan, untuk masuk kedalam aplikasi database mariadb ketikkan perintah berikut,

# mysql -u root -p
Lalu masukkan password root yang telah disetting tadi, kemudian anda dapat menambahkan database atau melakukan hal lainnya dengan command mysql.