Question 177105 in PhpMyAdmin Question posted in
The official documentation can be found here.

phpMyAdmin root login denied

I have MX Linux 21.3 as my OS, installed phpMyAdmin, but when tried to login, got an error.

tried to install ZoneMinder got an error with DB connection, installed phpMyAdmin to facilitate adding/changing users/privileges, could install phpMyAdmin without problem, but when tried to login, got the following error: (please see the screenshot below), and I followed this post to install phpMyAdmin.
ps: I did change the $cfg[‘blowfish_secret’] = ‘mypassword’; in /var/www/html/phpMyAdmin/config.inc.php, what I’m doing wrong?

Tags:

2

Answers


  1. 0

    Without more context, this is difficult to answer outside of assumptions. Regardless, I hope this helps.

    The impression I get from the data you provided makes me infer the problem would just be the root password.

    I would point out that the root password and the passphrase under $cfg[‘blowfish_secret’] are not necessarily the same thing according to the document you shared.

    If you are able to login via command-line passwordless.

    You can then reset the password yourself

    sudo mysqld --skip-grant-tables
mysql -u root mysql
UPDATE user SET Password=PASSWORD('YOUR_ENTRY_HERE') WHERE User='root'; FLUSH PRIVILEGES; exit;
    Login or Signup to reply.
  2. 0

    blowfish_secret is related to the web UI connection, not the database one.

    zoneminder doesn’t use database users to control access so phpmyadmin not needed.

    To reset password of the root account, and CREATE A SEPARATE ZONEMINDER ACCOUNT;

    $ sudo -u mysql mariadbd --skip-grant-tables &
$ mariadb
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> SET PASSWORD FOR root@localhost = PASSWORD('i will not forget this');
MariaDB [(none)]> source /usr/share/zoneminder/db/zm_create.sql; 
MariaDB [(none)]> grant lock tables,alter,create,select,insert,update,delete,index on zm.* to zmuser@localhost identified by 'zmpass';
MariaDB [(none)]> SHUTDOWN;

$ sudo systemctl start mariadb.service

    Ensure the zm configuration (/etc/zm/zm.conf?) uses these authentication of the zmuser.

    from step 7 of zm install.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search