Create User Mysql
created a new user:
mysql> CREATE USER 'user'@'localhost' IDENTIFIED WITH mysql_native_password 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 caching_sha2_password BY 'password';
source : https://stackoverflow.com/questions/49948350/phpmyadmin-on-mysql-8-0
Priviliges DB mysql;
INSERT INTO `db` (`Host`, `Db`, `User`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Execute_priv`, `Event_priv`, `Trigger_priv`) VALUES ('localhost', 'DatabaseName', 'DatabaseUser', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');