IPv6: MySQL instalasi
Jump to navigation
Jump to search
Instalasi MySQL di Ubuntu relatif sederhana hanya menggunakan perintah,
apt-get update apt-get -y install mysql-server mysql-client
Biasanya akan di tanya root password. Jika kita masih belajar dapat memasukan root password
123456
Agar lebih aman lakukan secure installation
mysql_secure_installation
Jawab
Enter current password for root (enter for none): OK, successfully used password, moving on... Change the root password? [Y/n] n ... skipping. Remove anonymous users? [Y/n] ... Success! Disallow root login remotely? [Y/n] Y ... Success! Remove test database and access to it? [Y/n] Y ... Success! Reload privilege tables now? [Y/n] Y ... Success!
Untuk menjalankan MySQL Server cukup menggunakan perintah
/etc/init.d/mysql restart
Test sambungan MySQL dengan IPv6
mysql -u root -h ::1 -p123456
Akan keluar kira-kira:
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 37 Server version: 5.5.35-1ubuntu1 (Ubuntu) Copyright (c) 2000, 2013, 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>
Ketik
mysql> show databases;
Akan keluar
+--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | +--------------------+ 3 rows in set (0.00 sec)
Setup database
mysql -u root -p Enter password:
mysql> create database databasekita;
mysql> grant INSERT,SELECT on root.* to user@localhost;
mysql> SET PASSWORD FOR user@localhost=PASSWORD('passworduser');
mysql> grant CREATE, INSERT, SELECT, DELETE, UPDATE on databasekita.* to user@localhost;
mysql> grant CREATE, INSERT, SELECT, DELETE, UPDATE on databasekita.* to user;
mysql> exit
Referensi
- http://www.mysqltutorial.org/
- http://dev.mysql.com/
- http://ubuntu.flowconsult.at/en/mysql-set-change-reset-root-password/ - Reset Password MySQL