phpMyAdmin can not access as root
by droid.c3p0 from LinuxQuestions.org on (#52263)
I have installed phpMyAdmin on my home PC (localhost).
I can access it as a user phpmyadmin without password.
But user phpmyadmin has no Privieges - has no right to create MySQL database, nor Import one, nothing at all.
I can not access phpMyAdmin as user root - it does not accept my root-password.
I can not access phpMyAdmin as user root - without password.
Quote:
Quote:
Quote:
How to access phpMyAdmin with Privileges to work with MySQL databases ?
I can access it as a user phpmyadmin without password.
But user phpmyadmin has no Privieges - has no right to create MySQL database, nor Import one, nothing at all.
I can not access phpMyAdmin as user root - it does not accept my root-password.
I can not access phpMyAdmin as user root - without password.
Quote:
| Database server Server: Localhost via UNIX socket Server type: MariaDB Server connection: SSL is not being used Documentation Server version: 10.3.22-MariaDB-0+deb10u1 - Debian 10 Protocol version: 10 User: phpmyadmin@localhost Server charset: UTF-8 Unicode (utf8mb4) |
| Web server Apache/2.4.38 (Debian) Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 PHP extension: mysqliDocumentation mbstringDocumentation PHP version: 7.3.14-1~deb10u1 |
| phpMyAdmin Version information: 4.9.1deb1~mx19 |