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].

Comments

Popular posts from this blog

看了几款项目管理工具

做真实的自我,是个坏主意