Pada kesempatan ini saya akan sharing proses instalasi mysql pada redhat dengan menggunakan repo subcription pada redhat 8, mysql adalah salah satu database machine yang cukup populer digunakan, database digunakan untuk mempermudah penempatan dan manajemen data dengan skala yang kecil hingga besar.
[root@redhat]# subscription-manager repos --list-enable
2. Setelah itu anda dapat cek subcrption repos dengan menggunakan perintah berikut, dan anda dapat melihat repo berikut yang kita akan gunakan nanti.
[root@redhat]# subscription-manager repos --list
Repo ID: rhel-8-for-x86_64-appstream-source-rpms
Repo Name: Red Hat Enterprise Linux 8 for x86_64 - AppStream (Source RPMs)
Repo URL: https://cdn.redhat.com/content/dist/rhel8/$releasever/x86_64/appstream/source/SRPMS
3. Jika repo tersebut belum ada enable, maka anda dapat enable repo tersebut anda dapat menggunakan id repos tersebut untuk melakukan proses enable.
[root@redhat]# subscription-manager repos --enable=rhel-8-for-x86_64-appstream-rpms
4. Berikut setelah itu anda dapat menggunakan perintah yum repolist untuk melihat repo apa saja yang siap untuk digunakan.
[root@redhat]# yum repolist
5. Setelah itu anda dapat menggunakan perintah tersebut untuk melakukan instalasi.
[root@redhat]# yum install @mysql
6. Anda dapat melakukan start service untuk mysqld, untuk start service otomatis ketika sesudah restart anda dapat enable service.
-
[root@redhat]# systemctl enable mysqld
[root@redhat]# systemctl start mysqld
[root@redhat]# systemctl status mysqld
-
7. Setelah service hidup, anda dapat instalasi paket mysql, anda dapat menggunakan perintah tersebut untuk memulai setup.
[root@redhat]# mysql_secure_installation
Securing the MySQL server deployment.
Connecting to MySQL using a blank password.
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: 0
Please set the password for root here.
New password: masukkan password
Re-enter new password: masukkan password
Estimated strength of the password: 50
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL 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? (Press y|Y for Yes, any other key for No) : n
... skipping.
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? (Press y|Y for Yes, any other key for No) : n
... skipping.
By default, MySQL 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? (Press y|Y for Yes, any other key for No) : y
- Dropping test database...Success.
- 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? (Press y|Y for Yes, any other key for No) : y
Success.
All done!
8. Proses setup selesai, setelah itu anda dapat melakukan login mysql dengan user root beserta password dengan menggunakan perintah berikut.
[root@redhat]# mysql -u root -p
9. Anda dapat melakukan cek sederhana dengan melihat isi dari database default mysql.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
10. Untuk keluar dari mysql anda dapat menggunakan exit.
mysql> exitSekian sharing kali ini, semoga bermanfaat dan
terimakasih.
0 Comments