How to reset mysql root password for Mysql Server 5.7 on Ubuntu
Note: the following instruction will DELTE all existing data in Mysql.
1. Remove existing Mysql:
apt purge mysql-server-5.7 mysql-server-core-5.7 mysql-common
2. Remove existing data:
mv /etc/mysql/ /etc/mysql.bak # or rm -rf /etc/mysql
mv /var/lib/mysql /var/lib/mysql.bak # or rm -rf /var/lib/mysql
3. Re-install mysql
apt install mysql-server-5.7 mysql-server-core-5.7 mysql-common
During this step, the installer will ask you for new root password.
[done].
1. Remove existing Mysql:
apt purge mysql-server-5.7 mysql-server-core-5.7 mysql-common
2. Remove existing data:
mv /etc/mysql/ /etc/mysql.bak # or rm -rf /etc/mysql
mv /var/lib/mysql /var/lib/mysql.bak # or rm -rf /var/lib/mysql
3. Re-install mysql
apt install mysql-server-5.7 mysql-server-core-5.7 mysql-common
During this step, the installer will ask you for new root password.
[done].
Comments