Skip to content

Instantly share code, notes, and snippets.

@gufranco-zz
Last active December 20, 2015 15:59
Show Gist options
  • Save gufranco-zz/6157905 to your computer and use it in GitHub Desktop.
Save gufranco-zz/6157905 to your computer and use it in GitHub Desktop.
MySQL - External Access using root user
  1. Edit /etc/mysql/my.cnf;
#bind-address = 127.0.0.1
bind-address  = 0.0.0.0
  1. Restart MySQL;
sudo service mysql restart
  1. Connect to MySQL;
mysql -u root -p mysql
  1. Execute the query
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

Thanks, Hugo!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment