How to install phpmyadmin with all privileges?

Question

PHP

I install on my server everything that is needed for the site to work (PHP, MYSQL, phpmyadmin)

sudo tasksel install lamp-server
sudo apt-get install php7.1-mbstring
sudo apt-get install php7.1-mcrypt
sudo phpenmod mbstring
sudo phpenmod mcrypt
sudo apt-get install phpmyadmin

when installing phpmyadmin, I chose apache, set a password ...
then I go to phpmyadmin already through the browser, there is a phpmyadmin user and the password is suitable, but there is no privilege to create a database, I try to log in as root and the same password, there is no access ... I
tried to log in under the data specified in /etk/mysql/debian.cnf, there is no access either ... Tell me

how to install it correctly?

Answer 1

sudo mysql_secure_installation
then N (No)
then set the PASSWORD (I don’t remember exactly, but there may be a second request to confirm the password - enter again)
then Y (Yes) 4 times, that is, until the questions run out, answer all Y

sudo mysql
alter user 'root'@'localhost' identified with mysql_native_password by 'ПАРОЛЬ';
flush privileges;
exit;

that's it, now you can enter PMA as root and PASSWORD

Answer 2

Try it through the terminal and you can also bring the php configuration file to do this:
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = root
password =
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = root
password =
socket = /var/run/mysqld/mysqld.sock
basedir = /usr