$ sudo apt install phpmyadmin
$ mysql -u root -p
mysql> show databases;
mysql> create database database1; "write any name instead of database1"
mysql> select user,host,plugin from mysql.user;
mysql> create user 'xxxx'@'localhost' identified by '*******(passwordkey)'
if you forgot to put password then use
ALTER USER xxx@localhost identified by '****';
mysql> grant all privileges on *.* to 'xxxx'@'localhost';
mysql> update user set plugin="auth_socket" where User='xxxx';
mysql> flush privileges;
mysql>exit
EmoticonEmoticon