Panduan ini akan membawa Anda melalui cara menginstal MySQL 8 di CentOS 8. MySQL adalah salah satu sistem manajemen basis data relasional opensource yang terkenal.
Instal MySQL 8 di CentOS 8
MySQL 8 tersedia untuk diinstal pada repo AppStream untuk CentOS 8. Repo AppStream diaktifkan secara default.
dnf whatprovides mysql
mysql-8.0.13-1.module_el8.0.0+41+ca30bab6.x86_64 : MySQL client programs and shared libraries Repo : AppStream Matched from: Provide : mysql = 8.0.13-1.module_el8.0.0+41+ca30bab6
Oleh karena itu, server MySQL 8 cukup diinstal dengan menjalankan perintah di bawah ini;
dnf install mysql-server
Untuk menginstal client MySQL 8;
dnf install mysql
Untuk menginstal server dan client MySQL 8;
dnf install @mysql
... ======================================================================================================================================================= Package Arch Version Repository Size ======================================================================================================================================================= Installing group/module packages: mysql-server x86_64 8.0.13-1.module_el8.0.0+41+ca30bab6 AppStream 25 M Installing dependencies: mariadb-connector-c-config noarch 3.0.7-1.el8 AppStream 13 k mecab x86_64 0.996-1.module_el8.0.0+41+ca30bab6.9 AppStream 397 k mysql x86_64 8.0.13-1.module_el8.0.0+41+ca30bab6 AppStream 9.2 M mysql-common x86_64 8.0.13-1.module_el8.0.0+41+ca30bab6 AppStream 142 k mysql-errmsg x86_64 8.0.13-1.module_el8.0.0+41+ca30bab6 AppStream 523 k protobuf-lite x86_64 3.5.0-7.el8 AppStream 150 k Installing module profiles: mysql/server Enabling module streams: mysql 8.0 Transaction Summary ======================================================================================================================================================= Install 7 Packages Total download size: 36 M Installed size: 243 M Is this ok [y/N]: y
Menjalankan MySQL 8 di CentOS 8
Setelah instalasi selesai, mulai dan aktifkan server MySQL 8 untuk berjalan pada boot sistem.
systemctl start mysqld
systemctl enable mysqld
Untuk memeriksa status server MySQL 8;
systemctl status mysqld
● mysqld.service - MySQL 8.0 database server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: active (running) since Wed 2019-10-02 13:19:32 EDT; 42s ago Main PID: 29142 (mysqld) Status: "SERVER_OPERATING" Tasks: 38 (limit: 11512) Memory: 466.4M CGroup: /system.slice/mysqld.service └─29142 /usr/libexec/mysqld --basedir=/usr Oct 02 13:19:20 localhost.localdomain systemd[1]: Starting MySQL 8.0 database server... Oct 02 13:19:20 localhost.localdomain mysql-prepare-db-dir[29057]: Initializing MySQL database Oct 02 13:19:32 localhost.localdomain systemd[1]: Started MySQL 8.0 database server.
Keamanan Awal MySQL 8
Secara default, MySQL dikirimkan dengan skrip keamanan yang digunakan untuk menghapus database server MySQL uji, menghapus user anonim dalam database, menonaktifkan login root jarak jauh, mengatur kekuatan password. Untuk menjalankan skrip, cukup jalankan perintah;
mysql_secure_installation
Saat dijalankan, Anda akan diminta untuk mengaktifkan atau menonaktifkan kebijakan sandi. Jika diaktifkan, atur kebijakan password dan buat password yang cocok dengan kebijakan yang Anda pilih.
VALIDATE PASSWORD COMPONENT can be used to test passwords and improve security. It checks the strength of password and allows the users to set only those passwords which are secure enough. Would you like to setup VALIDATE PASSWORD component? Press y|Y for Yes, any other key for No: y There are three levels of password validation policy: LOW Length >= 8 MEDIUM Length >= 8, numeric, mixed case, and special characters STRONG Length >= 8, numeric, mixed case, special characters and dictionary file Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 2 Please set the password for root here. New password: Re-enter new password: Estimated strength of the password: 100 Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y
Selanjutnya, hapus user anonim, larang login root jarak jauh, hapus database pengujian, dan reload tabel hak istimewa untuk memengaruhi perubahan yang dibuat.
Anda sekarang dapat masuk ke server MySQL 8 Anda sebagai user root dengan password yang ditetapkan di atas.
mysql -u root -p
Untuk menampilkan versi MySQL, Anda dapat menjalankan kueri;
show variables like "version%";
+-------------------------+---------------------+ | Variable_name | Value | +-------------------------+---------------------+ | version | 8.0.13 | | version_comment | Source distribution | | version_compile_machine | x86_64 | | version_compile_os | Linux | | version_compile_zlib | 1.2.11 | +-------------------------+---------------------+
Anda juga dapat menjalankan perintah di bawah ini pada command line untuk menampilkan versi database.
mysql -V
mysql Ver 8.0.13 for Linux on x86_64 (Source distribution)
Itu saja tentang cara menginstal MySQL 8 di CentOS 8.
Tutorial serupa
Instal MySQL 8 di Debian 10 Buster
Instal LEMP Stack dengan MySQL 8 di Fedora 30/Fedora 29
Instal MySQL 8 di FreeBSD 12
Instal MySQL 8 di Debian 9
Instal MySQL 8 di Fedora 30/Fedora 29