menembus batas impian


buka terminal

masuk sebagai root

[root@localhost bmc]#su

[root@localhost bmc]#>>>>masukkan password root

[root@localhost bmc]#mysql -u root -p’password’

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.69 Source distribution

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>  GRANT ALL PRIVILEGES ON *.* to root@’%’ IDENTIFIED BY ‘password’; enter

keluar > Query OK, 0 rows affected (0.00 sec)

ketik lagi

mysql> FLUSH PRIVILEGES; enter

keluar > Query OK, 0 rows affected (0.00 sec)
selesai sudah dan kita bisa akses mysql dr luar server dengan akses ip server

 

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

%d blogger menyukai ini: