Unable to login to mysql after the fireware update - mysqli::real_connect(): (HY000/2002): Connection refused

My Cloud OS 5 Personal & Network Attached Storage My Cloud Mirror
1

When I open phpmyadmin to login to root account I get this error
mysqli::real_connect(): (HY000/2002): Connection refused

I try to reset root password using this script

python3 /usr/bin/mysql_reset.py -r

But I get this error

root@WDMyCloudMirror ~ # python3 /usr/bin/mysql_reset.py -r
killall: mysqld: no process killed
killall: mysqld_safe: no process killed
killall: mariadbd: no process killed
killall: mariadbd-safe: no process killed
231031 22:37:03 mysqld_safe Logging to ‘/mnt/HD_a4/.@database@/WDMyCloudMirror.err’.
231031 22:37:04 mysqld_safe Starting mariadbd daemon with databases from /mnt/HD_a4/.@database@
Traceback (most recent call last):
File “/usr/bin/mysql_reset.py”, line 748, in
reset_root_account()
File “/usr/bin/mysql_reset.py”, line 585, in reset_root_account
if not _get_datadir_from_process_list():
File “/usr/bin/mysql_reset.py”, line 72, in _get_datadir_from_process_list
datadir = output.decode().strip().split(“/usr/libexec/mariadbd”)[1].split(“–datadir=”)[1].split(" ")[0]
IndexError: list index out of range
root@WDMyCloudMirror ~ #

3

it is

image
image766×396 13.7 KB

4

i get this erro

image
image733×532 20.7 KB

6

Following command didnt show anything

  • pidof mariadbd;

I already run this but i did try again

  • python3 /usr/bin/mysql_reset.py --reboot

image
image964×211 5.17 KB

8

It didn’t work still same issue

pidof mariadbd still show nothing

9

Then I suggest manually reinstalling the latest My Cloud OS5 firmware.

10

I have lot of files on this NAS, Will this remove all files

12

Update firmware but still same issue

image
image1037×522 17.1 KB

It looks like sql starts and then crash it

image
image1037×255 6.11 KB

15

You can see from above screen. It runs and find no sql is running

16

this command try to run it but nothing happens

  • python3 /usr/bin/mysql_reset.py --reset

image
image1002×448 9.79 KB

18

I have, also updated phpmyadmin and login again but same issue. I think it’s an issue with new firmware

2 Likes
19

Anything else I can do to fix this issue

21

This command didnt return anything

  • pidof mariadbd

I also done system restore

image
image953×508 13.6 KB

Still same issue, Cant login

22

Is it possible to completely remove sql and reinstall it again

24

Yes, the WD support answered.
Here you can see how to remove mysql.