Rolly Maulana Awangga :: Catatan Ngoprek IT

Pakar dan Awam sama saja, sama sama belajar

Enable Remote Access To MySQL Database Server

Enable Remote Access To MySQL Database Server

I have ubuntu 12.04 mysql server and installed phpmyadmin to in that server. When i edit previledge of user to give remote connection to this server by editing host to become %, still cannot connect. so i search the answer of remote mysql to my database server by login via ssh or terminal if u use desktop version, and login to yout root password by command :

mysql -u root -p

so there is show mysql prompt, and select your database. ie. userhost_table

mysql>connect userhost_table

and then you can add this sql command

GRANT ALL PRIVILEGES ON `userhost\_table` . * TO ‘userhost_table’@’localhost’ IDENTIFIED BY ‘passwordnya’;
GRANT ALL PRIVILEGES ON `userhost\_table` . * TO ‘userhost_table’@’localhost.localdomain’ IDENTIFIED BY ‘passwordnya’;
FLUSH PRIVILEGES;
QUIT;

Done, u can connect to mysql server remotely now.

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: