Mysql remote connection

ARUN Post in MYSQL
0
To grand remote privilage to a particular database from a particular IP : GRANT ALL PRIVILEGES ON database_name.* TO USERNAME@IP IDENTIFIED BY "PASSWORD";
To grand remote privilege to a particular database from all Ips : GRANT ALL PRIVILEGES ON database_name.* TO USERNAME@'%' IDENTIFIED BY "PASSWORD";
To grand remote privilage to all database on that server from a particular IP : GRANT ALL PRIVILEGES ON database_name.* TO USERNAME@IP IDENTIFIED BY "YOUR_PASSWORD";

Grand remote access from ONE IP to ONE DATABASE on a remote server
GRANT ALL PRIVILEGES ON database_name.* TO USERNAME@IP_ADDRESS IDENTIFIED BY 'YOUR_PASSWORD';
« Prev: :Next »

Leave a Reply

You must be logged in to post a comment.