Onnowpurbo at 09:16, 27 June 2015

2015-06-27T09:16:09Z

← Older revision		Revision as of 09:16, 27 June 2015
Line 39:		Line 39:


			Test sambungan MySQL dengan IPv6

	~~Masuk ke MySQL monitor~~		mysql -u root -h ::1 -p123456

			Akan keluar kira-kira:

	mysql ~~-u root -p123456~~		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		Ketik

Onnowpurbo: New page: 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 k...

2015-06-27T08:59:29Z

New page: 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 k...

New page

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

Masuk ke MySQL monitor

mysql -u root -p123456

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]]

[[Category: Database]]

IPv6: MySQL instalasi - Revision history

Onnowpurbo at 09:16, 27 June 2015

Onnowpurbo: New page: 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 k...