de-fuck-mysql.sh

#!/bin/bash

# de-fuck mysql 5.7
# This script allow you to log on MySQL as root user without use sudo

# sudo apt install postgresql
# sudo apt purge "mysql-*"
# you know, would be better...

sudo mysql -u root -e "CREATE USER 'root2'@'localhost';"
sudo mysql -u root -e "GRANT ALL PRIVILEGES ON *.* TO 'root2'@'localhost' WITH GRANT OPTION;"

mysql -u root2 -e "DROP USER 'root'@'localhost';"
mysql -u root2 -e "CREATE USER 'root'@'localhost';"
mysql -u root2 -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;"

mysql -u root -e "DROP USER 'root2'@'localhost';"