MySQL cannot Connect Error 10061

error mysql tidak bisa di koneksi dari komputer lain didalam local network

solved

sudo nano /etc/mysql/my.cnf

cari line

bind-address = 127.0.0.1

ubah jadi

#bind-address = 127.0.0.l

restart dengan mysql

sudo /etc/init.d/mysql restart

atau dengan restart service mysql

sudo service mysql restart

setelah itu pastikan bahwa sudah ada user yg di privilage untuk dapat dikeneksi dari jaringan

buka http://localhost/phpmyadmin

klik privilage -> add new user

user name = root
host = *
password = no password

lalu tekan go untuk menyimpan

masuk kembali ke privilage

klik flush atau reload privilage

Published by

G3n1k

just to remember what i had known :)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s