Skip to content

Instantly share code, notes, and snippets.

@abdes-zakari

abdes-zakari/mysql_enable_remote_access.sql

Created December 17, 2021 12:24
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 abdes-zakari/a511e9ea2865e08b30e443dc1b9f2b92 to your computer and use it in GitHub Desktop.
Save abdes-zakari/a511e9ea2865e08b30e443dc1b9f2b92 to your computer and use it in GitHub Desktop.
Download ZIP
MySql: Enable access for the remote user
Raw
mysql_enable_remote_access.sql
-- MySql: Enable access for remote user
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.7' IDENTIFIED BY 'my_password';
flush privileges;
-- or for specfic user and database
GRANT ALL ON fooDatabase.* TO fooUser@'192.168.1.7' IDENTIFIED BY 'my_password';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment