Data Backup and Recovery

I have locked myself out of the SnapCenter repository database

Spaceball
1,927 Views

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?

 

1 ACCEPTED SOLUTION
1 REPLY 1
Public