Created
August 29, 2020 12:40
-
-
Save tkuchiki/0fadb0d2ca16b27f54d2ca76a3ee549f to your computer and use it in GitHub Desktop.
Install mysql 8.0 on ubuntu 18.04
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
apt-get update | |
apt-get install -y debconf libaio1 apparmor-profiles lsb-release gnupg | |
DEB="/tmp/mysql.deb" | |
ROOT_PASSWORD="" | |
MYSQL_USER="testuser" | |
MYSQL_PASSWORD="testpass" | |
curl -H "UserAgent: Mozilla" -L -o $DEB https://dev.mysql.com/get/mysql-apt-config_0.8.15-1_all.deb | |
export DEBIAN_FRONTEND="noninteractive" | |
echo "mysql-apt-config mysql-apt-config/select-server select mysql-8.0" | debconf-set-selections | |
dpkg -i ${DEB} | |
apt-key adv --keyserver pgp.mit.edu --recv-keys 5072E1F5 || true | |
debconf-set-selections <<< "mysql-server mysql-server/root_password password ${ROOT_PASSWORD}"; | |
debconf-set-selections <<< "mysql-server mysql-server/root_password_again password ${ROOT_PASSWORD}"; | |
apt-get update | |
apt-get install -y mysql-server | |
systemctl start mysql | |
mysql -u root --password=${ROOT_PASSWORD} -e "CREATE USER ${MYSQL_USER}@'%' identified by '${MYSQL_PASSWORD}'; GRANT ALL PRIVILEGES ON *.* TO ${MYSQL_USER}@'%'; FLUSH PRIVILEGES;" | |
rm -f ${DEB} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment