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
Posted on: September 26, 2020, by :