rianto isaac's Weblog

rianto utomo isaac sahala utomo

linux, mysql klo gak bisa konek dari vb6 ini penyebabnya :D :p :)

leave a comment »

Open Port 3306 (mysql) in ubuntu

Okay, last time I want to access mysql server in ubuntu using my laptop, But I cant access this server because port 3306 in the server to be closed.

okay first step,

> Open your console (terminal), and type

~#sudo nano /etc/my.cnf

 

 

second step

>and now seacrh this word (bind-address=127.0.0.1), make this word tobe command, with add “#” from first word

#bind-address=127.0.0.1

> Save and Quit

third step
> Restart your mysql-server

~# sudo /etc/init.d/mysql restart

> and now open your Port 3306

~#sudo iptables -A INPUT -i eth0 -p tcp –destination-port 3306 -j ACCEPT

Okay, Finish…then try it to access in your laptop

thanks

rianto utomo bole nyontek dari http://hanangpriambodo.wordpress.com/2012/08/01/open-port-3306-mysql-in-ubuntu/

Written by isaaconi

Agustus 6, 2014 pada 5:16 pm

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: