How to Grant Permission to Remote Access in MySQL

If you are using Client Server architecture with MySQL database,you cant directly access MySQL database which is in the server.

To Access MySQL Database thought the network,you have to grant the permission to each database.to do that you have to follow following steps.

Ex :- Create a database "WSO2"

1. Open MySQL Command Prompt

2. Type Following Command to grant usage permission to access MySQL

Syntax -

mysql> GRANT USAGE ON *.* TO username@[Client_IP] IDENTIFIED BY 'password';

Ex :-

mysql> GRANT USAGE ON *.* TO Chamara@10.100.1.149 IDENTIFIED BY 'chamara123';

3. Then Type following command to Grant database Permission

Syntax -

GRANT ALL PRIVILEGES ON database_name.* TO username@[Client_IP];

Ex :-

GRANT ALL PRIVILEGES ON WSO2.* TO chamara@10.100.1.149;

Now you can access WSO2 Database from anywhere.