MySQL 5.7.x reset 'root' password
In this post I'll describe how can we set MySQL root password that was blank during the initial installation process. I'll describe end-to-end installation of MySQL database on a linux machine followed by resetting the root password. Environment OS Ubuntu Linux 18.04 MySQL 5.7.x JDK 1.8.x A. MySQL Installation Process 1. First, update the apt package index by typing (with sudo privileges): root@srv1:~# sudo apt update 2. Then install the MySQL package with the following command: root@srv1:~# sudo apt install mysql-server 3. Once the installation is completed, the MySQL service will start automatically. To check whether the MySQL server is running, type: root@srv1:~# sudo systemctl status mysql ● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: active (running) since Fri 2020-03-20 07:29:27 UTC; 17min ago Process: 1649 ExecStart=/usr/sb...