S
S
sergey_silin2017-11-12 17:33:46
Vue.js
sergey_silin, 2017-11-12 17:33:46

How to login as root in phpmyadmin?

How to login as root in phpmyadmin?
That's what gives out 5a085baa612bc046110412.png
Tell me what else you need from the information I'll write.
Everything is installed on a separate server, debian 9.2, php7, mysql-server, apache2, phpmyadmin. Everything is fresh.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
Slava Vitrenko, 2017-11-20
@mxuser

By default, root login is disabled. I advise you to create a separate user for your needs:
(enter one line at a time)

sudo mysql -u root -p (спросит пароль)
create user 'пользователь'@localhost identified by 'пароль';
grant all privileges on *.* to 'пользователь'@localhost;
grant grant option on *.* to 'пользователь'@localhost;
flush privileges;
quit;

K
korn1shon, 2021-04-08
@korn1shon

and where to put it?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question