IPv6: MySQL instalasi

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

Pranala Menarik

• MySQL
• MySQL: Instalasi Ulang
• Linux Howto
• Tip Membangun Server Sendiri
• Backup isi database MySQL
• Reset Password MySQL