Skip to content

Instantly share code, notes, and snippets.

@asiletto
Created February 27, 2015 08:47
Show Gist options
  • Save asiletto/d80ea88042de23fd70fa to your computer and use it in GitHub Desktop.
Save asiletto/d80ea88042de23fd70fa to your computer and use it in GitHub Desktop.
#install & minimal mysql config (starting point for a docker container)
apt-get update
#apt-get update && apt-get upgrade -y
echo "mysql-server-5.6 mysql-server/root_password password root" | sudo debconf-set-selections
echo "mysql-server-5.6 mysql-server/root_password_again password root" | sudo debconf-set-selections
apt-get -y install mysql-server-5.6
sed -i 's/127\.0\.0\.1/0\.0\.0\.0/g' /etc/mysql/my.cnf
mysql -uroot -proot -e 'USE mysql; UPDATE `user` SET `Host`="%" WHERE `User`="root" AND `Host`="localhost"; DELETE FROM `user` WHERE `Host` != "%" AND `User`="root"; FLUSH PRIVILEGES;'
service mysql restart
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment