Difference between revisions of "IPv6 Database: MySQL Server"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 4: | Line 4: | ||
apt -y install mysql-server mysql-client | apt -y install mysql-server mysql-client | ||
| − | Agar lebih aman lakukan secure installation | + | Restart MySQL Server |
| + | |||
| + | /etc/init.d/mysql restart | ||
| + | |||
| + | Untuk test IPv6. Edit | ||
| + | |||
| + | vi /etc/hosts | ||
| + | |||
| + | Edit | ||
| + | |||
| + | ::1 localhost | ||
| + | ::1 localhost6 | ||
| + | |||
| + | Test sambungan MySQL ke localhost (localhost) dengan IPv6 | ||
| + | |||
| + | mysql -u root -h ::1 -p123456 | ||
| + | |||
| + | Jika berhasil maka akan keluar kira-kira: | ||
| + | |||
| + | mysql: [Warning] Using a password on the command line interface can be insecure. | ||
| + | Welcome to the MySQL monitor. Commands end with ; or \g. | ||
| + | Your MySQL connection id is 5 | ||
| + | Server version: 5.7.25-0ubuntu0.18.04.2 (Ubuntu) | ||
| + | |||
| + | Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. | ||
| + | |||
| + | Oracle is a registered trademark of Oracle Corporation and/or its | ||
| + | affiliates. Other names may be trademarks of their respective | ||
| + | owners. | ||
| + | |||
| + | Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. | ||
| + | |||
| + | mysql> | ||
| + | |||
| + | Coba Ketik | ||
| + | |||
| + | mysql> show databases; | ||
| + | |||
| + | Akan keluar kira-kira: | ||
| + | |||
| + | +--------------------+ | ||
| + | | Database | | ||
| + | +--------------------+ | ||
| + | | information_schema | | ||
| + | | mysql | | ||
| + | | performance_schema | | ||
| + | | sys | | ||
| + | +--------------------+ | ||
| + | 4 rows in set (0.00 sec) | ||
| + | |||
| + | |||
| + | |||
| + | ==Instalasi Lebih Aman== | ||
| + | |||
| + | Agar instalasi lebih aman, kita bisa menambahkan langkah berikut. Agar lebih aman lakukan secure installation | ||
mysql_secure_installation | mysql_secure_installation | ||
| Line 23: | Line 77: | ||
... Success! | ... Success! | ||
| − | + | ||
| + | ==Tambahan untuk IPv6== | ||
| + | |||
| + | Jika di perlukan, edit Konfigurasi MySQL agar bisa di sambung dari IPv4 dan IPv6 | ||
vi /etc/mysql/my.cnf | vi /etc/mysql/my.cnf | ||
vi /etc/mysql/mysql.conf.d/mysqld.cnf | vi /etc/mysql/mysql.conf.d/mysqld.cnf | ||
| − | |||
Pastikan | Pastikan | ||
| − | bind-address = : | + | bind-address = :: |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | Ini hanya tambahan, tapi tidak terlalu banyak berefek. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 13:55, 3 February 2019
Instalasi dengan menggunakan perintah
apt update apt -y install mysql-server mysql-client
Restart MySQL Server
/etc/init.d/mysql restart
Untuk test IPv6. Edit
vi /etc/hosts
Edit
::1 localhost ::1 localhost6
Test sambungan MySQL ke localhost (localhost) dengan IPv6
mysql -u root -h ::1 -p123456
Jika berhasil maka akan keluar kira-kira:
mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.7.25-0ubuntu0.18.04.2 (Ubuntu) Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
Coba Ketik
mysql> show databases;
Akan keluar kira-kira:
+--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.00 sec)
Instalasi Lebih Aman
Agar instalasi lebih aman, kita bisa menambahkan langkah berikut. Agar lebih aman lakukan secure installation
mysql_secure_installation
Jawab “Y” untuk banyak pertanyaan berikut
Securing the MySQL server deployment. Press y|Y for Yes, any other key for No: New password: Re-enter new password: Remove anonymous users? (Press y|Y for Yes, any other key for No) : Y ... Success! Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y ... Success! Remove test database and access to it? (Press y|Y for Yes, any other key for No) : Y ... Success! Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y ... Success!
Tambahan untuk IPv6
Jika di perlukan, edit Konfigurasi MySQL agar bisa di sambung dari IPv4 dan IPv6
vi /etc/mysql/my.cnf vi /etc/mysql/mysql.conf.d/mysqld.cnf
Pastikan
bind-address = ::
Ini hanya tambahan, tapi tidak terlalu banyak berefek.