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:Prevent cron job from sending out the mail
To view if upcp is still running:Next »