Create User Mysql
created a new user:
mysql> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
3- Grant all privileges to the new user:
mysql> GRANT ALL PRIVILEGES ON *.* To 'user'@'localhost';
4- Change the Authentication Plugin with the password:
mysql> ALTER USER 'user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
source : https://stackoverflow.com/questions/49948350/phpmyadmin-on-mysql-8-0