https://community.netapp.com/t5/Data-Protection/I-have-locked-myself-out-of-the-SnapCenter-repository-database/m-p/171365#M13449 <P><A href="https://kb.netapp.com/Advice_and_Troubleshooting/Data_Protection_and_Security/SnapCenter/How_to_reset_MySQL_root_user_password_in_SnapCenter_Server_4.0_and_4.1" target="_self">How to reset MySQL root user password in SnapCenter Server 4.0 and 4.1</A></P> Wed, 03 Nov 2021 07:26:46 GMT Mjizzini 2021-11-03T07:26:46Z https://community.netapp.com/t5/Data-Protection/I-have-locked-myself-out-of-the-SnapCenter-repository-database/m-p/171313#M13447 <P>I accidently used the wrong method to reset the mysqldb password from Snapcenter.</P><P>Instead of</P><OL><LI>open-SmConnection</LI><LI><SPAN>Set-SmRepositoryPassword</SPAN></LI></OL><P><SPAN>i used</SPAN></P><P><SPAN>C:\Program Files\MySQL\MySQL Server 5.7\bin&gt;mysqld --defaults-file="D:\ProgramData\NetApp\SnapCenter\MySQL Data\my.ini" --init-file="D:\\mysql-init.txt"<BR /><BR />where&nbsp;mysql-init.txt contains<BR />ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword';<BR /><BR />Now I'm not able to do Open-SmConnection any more.<BR /><BR /></SPAN></P><P><SPAN>Any suggestions?</SPAN></P><P>&nbsp;</P> Wed, 04 Jun 2025 10:09:48 GMT https://community.netapp.com/t5/Data-Protection/I-have-locked-myself-out-of-the-SnapCenter-repository-database/m-p/171313#M13447 Spaceball 2025-06-04T10:09:48Z https://community.netapp.com/t5/Data-Protection/I-have-locked-myself-out-of-the-SnapCenter-repository-database/m-p/171365#M13449 <P><A href="https://kb.netapp.com/Advice_and_Troubleshooting/Data_Protection_and_Security/SnapCenter/How_to_reset_MySQL_root_user_password_in_SnapCenter_Server_4.0_and_4.1" target="_self">How to reset MySQL root user password in SnapCenter Server 4.0 and 4.1</A></P> Wed, 03 Nov 2021 07:26:46 GMT https://community.netapp.com/t5/Data-Protection/I-have-locked-myself-out-of-the-SnapCenter-repository-database/m-p/171365#M13449 Mjizzini 2021-11-03T07:26:46Z