Assumed mysql server IP is 192.168.1.1
Persyaratan yang diperlukan :
- Seperangkat komputer dengan Operating System linux Debian/Ubuntu
- Aplikasi MySQL Server
- A set of computer with Debian or Ubuntu Operating System
- Application 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:
Edit the file / etc / mysql / my.cnf
Look scritp following:
bind-address = 172.0.0.1
Rubah menjadi script berikut :
Change to the script:
Change to the script:
bing-address = 192.168.1.1
- Restart Mysql Server
sudo /etc/inti.d/mysql restart
