Skip to content

Instantly share code, notes, and snippets.

@fabianoalmeida
Created August 4, 2011 19:59
Show Gist options
  • Save fabianoalmeida/1126084 to your computer and use it in GitHub Desktop.
Save fabianoalmeida/1126084 to your computer and use it in GitHub Desktop.
Install MySQL on Ubuntu and setting external access
# Install MySQL
sudo apt-get install mysql-server
# After set the root password
# Configure the file:
sudo vi /etc/mysql/my.conf
# And add this configuration to bind-address attribute (under [mysqld])
bind-address = 0.0.0.0
# After that, set privileges to mysql user
mysql -u root -p mysql
# Inside MySQL, execute this line
grant all privileges on *.* to root@'%' identified by 'PASSWORD' with grant option;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment