Resetting phpMyAdmin password

English Applications
1

HI,

I’m unable to reset my phpMyAdmin root password. Grateful for your guidance.

2

Does this help?

3

It is great article, but I can’t access i.e. enter the phpMyAdmin dashboard to change the password by typing: SET PASSWORD FOR ‘root’@‘localhost’ = PASSWORD(‘your_root_password’);

4

Option 2: SSH is not working since I can’t access the folder /etc/phpMyAdmin.
I get a message: Could not enter folder /etc/phpMyAdmin.

5

It’s showing:

Active: active (running) since Sun 2024-04-07 00:31:43 CEST; 1h 41min ago
       Docs: man:mysqld(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 942 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS)
    Process: 961 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade (code=exited, status=0/SUCCESS)
   Main PID: 974 (mysqld)
     Status: "Taking your SQL requests now..."
      Tasks: 9 (limit: 4915)
     CGroup: /system.slice/mariadb.service
             └─ 974 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --user=mysql

Apr 07 00:31:42 localhost.localdomain systemd[1]: Starting MariaDB database server...
Apr 07 00:31:43 localhost.localdomain systemd[1]: Started MariaDB database server.

But I can’t enter login with the password even though I didn’t change it.

6

In the Linux terminal, I typed this: sudo systemctl stop mysql and then this: sudo mysqld_safe --skip-grant-tables & and I was able to enter myPHPAdmin panel.

I typed this in the SQL tab: SET PASSWORD FOR ‘root’@‘localhost’ = PASSWORD(‘developer’); and clicked on the Go button and got this message: Error SQL query: Copy SET PASSWORD FOR ‘root’@‘localhost’ = PASSWORD(‘developer’); MySQL said: Documentation #1290 - The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement

In the General settings I tried to change the password and got this message: SQL query: Copy

SET password = PASSWORD(‘***’) MySQL said: Documentation

#1290 - The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement

I tried to restart mySQL by typing sudo systemctl start mysql and the sudo systemctl status mariadb.service to check the status to see if it’s running and it says:

mamunsson@dynamic-pd01:> sudo systemctl start mysql [sudo] password for root: Job for mariadb.service failed because the control process exited with error code. See “systemctl status mariadb.service” and “journalctl -xeu mariadb.service” for details. mamunsson@dynamic-pd01:> sudo systemctl status mariadb.service × mariadb.service - MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Sun 2024-04-07 11:40:25 CEST; 8s ago Docs: man:mysqld(8) systemd - MariaDB Knowledge Base Process: 13987 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS) Process: 13993 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade (code=exited, status=0/SUCCESS) Process: 13999 ExecStart=/usr/lib/mysql/mysql-systemd-helper start (code=exited, status=1/FAILURE) Main PID: 13999 (code=exited, status=1/FAILURE) Status: “MariaDB server is down”

Apr 07 11:39:55 dynamic-pd01.res.v6.highway.a1.net systemd[1]: Starting MariaDB database server… Apr 07 11:40:25 dynamic-pd01.res.v6.highway.a1.net systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Apr 07 11:40:25 dynamic-pd01.res.v6.highway.a1.net systemd[1]: mariadb.service: Failed with result ‘exit-code’. Apr 07 11:40:25 dynamic-pd01.res.v6.highway.a1.net systemd[1]: Failed to start MariaDB database server. mamunsson@dynamic-pd01:~> ^C

When I restarted my computer, I checkd the status of mySQL and it was active again.

I checked this guide: https://dev.mysql.com/doc/refman/8.3/en/resetting-permissions.html

I see a var/lib/mysql and var/lib/mysql-files but I can’t access them. I tried to access them as super user by typing sudo su and then I navigated to cd /var/lib/mysql-files or cd /var/lib/mysql but don’t know what steps to take and how.

7

I came across this link: php - SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' - Stack Overflow and tried this:

"In short, in MariaDB:

sudo mysql -u root;
use mysql;
UPDATE mysql.user SET plugin = ‘mysql_native_password’, Password = PASSWORD(‘pass1234’) WHERE User = ‘root’;
FLUSH PRIVILEGES;
exit;"

But I’m still unable to access phpMyAdmin.

8

Ok, I was able to successfully change the password by typing it like this in the terminal: sudo mysqladmin -u root password ‘developer’

9

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