Skip to content

Instantly share code, notes, and snippets.

@michaelbramwell

michaelbramwell/mysqlremoteacess

Created January 4, 2013 01:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save michaelbramwell/4449210 to your computer and use it in GitHub Desktop.
Save michaelbramwell/4449210 to your computer and use it in GitHub Desktop.
Download ZIP
grant remote access to mysql server from mysql shell
Raw
mysqlremoteacess
GRANT ALL PRIVILEGES ON {tablename}.* TO {username}@"{ipaddress}" IDENTIFIED BY "{password}"
e.g
GRANT ALL PRIVILEGES ON tableFoo.* TO wordpressuser@"192.168.1.%" IDENTIFIED BY "secure123"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment