MySQL root access from all hosts

remote_mysql.txt

sudo ufw allow from any to any port 3306 proto tcp

sudo apt update
sudo apt install mysql-server
sudo mysql_secure_installation
sudo mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Rtcv39$$';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Rtcv39$$';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Rtcv39$$';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

[mysqld]
skip-log-bin = true 

sudo systemctl restart mysql

rm -rf /var/lib/mysql

mysql -u root -h 0.0.0.0 -p