Page 1 of 1

Remote mysql access from specific Ip address

Posted: Sun May 05, 2013 6:33 pm
by a24uall
Remote mysql access to specific databases from all specific address
GRANT ALL PRIVILEGES ON database_name.* TO username@'REMOTE_IP' IDENTIFIED BY 'your_password'
Remote mysql access from all databases from all Ip address
GRANT ALL PRIVILEGES ON *.* TO username@'%' IDENTIFIED BY 'your_password'