Can't logging with phpmyadmin

Hi
i will try with my poor english
I have migrate my http server on a new machine
On these new one
i can connect to mysql and the mysql server in running

● mariadb.service - MariaDB database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)
     Active: active (running) since Thu 2025-05-01 16:10:01 CEST; 1h 24min ago
       Docs: man:mysqld(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 5642 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS)
    Process: 5652 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade (code=exited, status=0/SUCCESS)
   Main PID: 5662 (mysqld)
     Status: "Taking your SQL requests now..."
      Tasks: 9 (limit: 1039)
        CPU: 1.451s
     CGroup: /system.slice/mariadb.service
             └─5662 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --user=mysql --socket=/run/mysql/mysql.sock

May 01 16:10:01 localhost.localdomain systemd[1]: Starting MariaDB database server...
May 01 16:10:01 localhost.localdomain systemd[1]: Started MariaDB database server.

I can connect to sql with mysql -u root -p
with the right pasword

when i try to connect to sql with the phpmyadmin (http) i got an error message
access denied for user ‘root@localhost’
I saw the method is defined in the config file /etc/phpmyadmin/config.inc.php

I have try to change the value for auth_type from ‘cookie’ to ‘config’ and put password but i have an error message meaning the parameters arent bad

looks like i should not use the same value for : blowfish_secret for two machine ,?
is that’s right ? and how can i generated this ?? or the is a file with these value somewhere on the machine ?
Best to you

I can said also
If i want to access to a web instance on my new machine i got an error message
" erreur lors de la connexion à la base de données"
A link to the SQL server could not be established. Please check your configuration.

may be this can help to understand the origine of the problem

Best

I follow this

mysql -u root -p{Provide your root password here}
USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password;
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('Provide your root password here');
FLUSH PRIVILEGES;
exit;

And now i can connect with phpmyadmin

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.