reanim8ed/sample.md

## sample.md

      
    Raw
  

              sample.md
            
          
    Change root password

sudo systemctl stop mysql
sudo systemctl edit mysql

[Service]
ExecStart=
ExecStart=/usr/sbin/mysqld --skip-grant-tables --skip-networking

sudo systemctl daemon-reload
sudo systemctl start mysql
sudo mysql -u root
mysql> FLUSH PRIVILEGES;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Password123#@!';
mysql> exit
sudo systemctl revert mysql
sudo systemctl daemon-reload
sudo systemctl restart mysql
mysql -u root -p

Change to remote access:

RENAME USER 'peter'@'localhost' TO 'peter'@'%';
GRANT ALL ON somedb.* TO 'peter'@'%';

https://ostechnix.com/how-to-reset-root-password-in-mysql-8-on-ubuntu-linux/