bind-address = 127.0.0.1 as below:
# localhost which is more compatible and is not less secure.
Restart MySQL service with
to make changes into effect.
Login MySQL as root, then run the code as below[change the field you want]:
CREATE USER 'USER_NAME'@'localhost' IDENTIFIED BY 'NEW-PASSWORD';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';