Set Login MySQL Account from Normal User

1. Login as super user "sudo su"
2. Login Mysql "mysql -u root -p"

3. SELECT User,Host FROM mysql.user;
   +------------------+-----------+
   | User             | Host      |
   +------------------+-----------+
   | admin            | localhost |
   | debian-sys-maint | localhost |
   | magento_user     | localhost |
   | mysql.sys        | localhost |
   | root             | localhost |

4. mysql> DROP USER 'root'@'localhost';
   Query OK, 0 rows affected (0,00 sec)

5. mysql> CREATE USER 'root'@'%' IDENTIFIED BY '';
   Query OK, 0 rows affected (0,00 sec)

6. mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
   Query OK, 0 rows affected (0,00 sec)
   
   mysql> FLUSH PRIVILEGES;
   Query OK, 0 rows affected (0,01 sec)

Source : https://askubuntu.com/a/784347