Skip to content

Instantly share code, notes, and snippets.

@smaknsk
Created December 3, 2019 13:43
Show Gist options
  • Save smaknsk/67190a17c5d06f7f96a9d88832a92d8f to your computer and use it in GitHub Desktop.
Save smaknsk/67190a17c5d06f7f96a9d88832a92d8f to your computer and use it in GitHub Desktop.
mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
systemctl start mysqld
mysqladmin password 'root'
mysql -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION"
mysql -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION"
mysql -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY 'root' WITH GRANT OPTION"
mysql -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1' IDENTIFIED BY 'root' WITH GRANT OPTION"
mysql -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'vagrant-arch.vagrantup.com' IDENTIFIED BY 'root' WITH GRANT OPTION"
mysql -e "GRANT ALL PRIVILEGES ON *.* TO ''@'localhost' IDENTIFIED BY 'root'"
mysql -e "GRANT ALL PRIVILEGES ON *.* TO ''@'vagrant-arch.vagrantup.com' IDENTIFIED BY 'root'"
mysql -e "DROP USER 'root'@'localhost'"
mysql -e "DROP USER 'root'@'127.0.0.1'"
mysql -e "DROP USER 'root'@'::1'"
mysql -e "DROP USER 'root'@'vagrant-arch.vagrantup.com'"
mysql -e "DROP USER ''@'localhost'"
mysql -e "DROP USER ''@'vagrant-arch.vagrantup.com'"
mysql -e "FLUSH PRIVILEGES"
mysql -e "DROP DATABASE IF EXISTS test"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment