Remote mysql access from specific Ip address

Post Reply
a24uall
Site Admin
Posts: 166
Joined: Sun Jul 01, 2012 9:07 am

Remote mysql access from specific Ip address

Post 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'
Arun
WebhostingDevelopment.com
Post Reply

Return to “Mysql Basic Commands”