I have locked myself out of the SnapCenter repository database

[Spaceball]

I accidently used the wrong method to reset the mysqldb password from Snapcenter.

Instead of

1. open-SmConnection
2. Set-SmRepositoryPassword

i used

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld --defaults-file="D:\ProgramData\NetApp\SnapCenter\MySQL Data\my.ini" --init-file="D:\\mysql-init.txt"

where mysql-init.txt contains
ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword';

Now I'm not able to do Open-SmConnection any more.

Any suggestions?

[Mjizzini · Accepted solution]

How to reset MySQL root user password in SnapCenter Server 4.0 and 4.1