How to remote MySQL Server (Cara meremote MySQL Server)

Diasumsikan IP mysql Server Adalah 192.168.1.1
Assumed mysql server IP is 192.168.1.1

Persyaratan yang diperlukan :

• Seperangkat komputer dengan Operating System linux Debian/Ubuntu
• Aplikasi MySQL Server

 Requirements tool:

• A set of computer with Debian or Ubuntu Operating System
• Application MySQL Server

Komputer kami menggunakan Operating System Debian Lenny. Didalamnya terdapat aplikasi MySQL Server.

• Untuk login ke MySQL ketik script berikut pada terminal 
• To log into MySQL in terminal type the following script

mysql -u root -h localhsot -p

• Membuat User Baru
• Creating a New User

Create user 'username'@'192.168.1.1' IDENTIFIED BY 'password';

Grant All Privileges On *.* to 'username'@'192.168.1.1';

FLUSH PRIVILEGES

• Memberi izin akses
• Gives access permission

GRANT ALL ON *.* to 'username'@'192.168.1.%' IDENTIFIED BY 'password';

FLUS PRIVILEGES;

• Merubah IP server yang dikenali mysql
• Changing IP server mysql recognized

Sunting berkas /etc/mysql/my.cnf

Carilah scritp berikut :

Edit the file / etc / mysql / my.cnf
Look scritp following:

bind-address = 172.0.0.1

Rubah menjadi script berikut :
Change to the script:

bing-address = 192.168.1.1

• Restart Mysql Server

sudo /etc/inti.d/mysql restart