MySQL master password validation failure processing method

After successful login with Windows account, right-click instance, in the Properties window, go to the security item, view the settings in Server Authentication as "SQL Server and Windows Authentication Mode", and then execute the following statement to enable the SA user. Change the sa password at the same time:

EXEC sp_password ' sa ', null, ' sa ' ALTER LOGIN sa ENABLE

result execution Error:

Message 15116, Level 16, State 1, line 1th

Password validation failed. The password is too short to meet Windows policy requirements.

Solution idea:

Local settings may be overridden by domain settings. The security policy is specified in the domain settings and the password must be somewhat complex. You need to change the sa password again:

EXEC sp_password ' sa ', ' uiop_098mn ', ' sa ' ALTER LOGIN sa ENABLE