MySQL permission drop operation-how to start setting with Guests account

MySQL is installed on Windows and runs with the SYSTEM permission by default. For example, SYSTEM is a super administrator. Not required. We do not recommend that you use this permission to run any program. This article demonstrates how to run MySQL under the GUEST account. Step 1: create an account belonging to the GUESTS group, which is assumed to be: sqlserver Step 2: Set the GUEST account to have MYS

MySQL is installed on Windows and runs with the SYSTEM permission by default. For example, SYSTEM is a super administrator. Not required. We do not recommend that you use this permission to run any program. This article demonstrates how to run MySQL under the GUEST account. Step 1: create an account belonging to the GUESTS group, which is assumed to be: sqlserver Step 2: Set the GUEST account to have MYS

MySQL is installed on Windows and runs with the SYSTEM permission by default. For example:

SYSTEM is a super administrator. Not required. We do not recommend that you use this permission to run any program.

This article demonstrates how to run MySQL under the GUEST account.

Step 1: create an account belonging to the GUESTS group, which is assumed to be: sqlserver

Step 2: Set the GUEST account to have the control permission for the MYSQL installation directory.

All accounts except the administrators, system, and sqlserver accounts can be deleted.

Step 3: Set the MYSQL service to start with sqlserver.

Choose "Management Tools"> "services", find "MySQL", right-click "properties", and select "Log on" on the displayed tab"

The default logon identity is "Local SYSTEM account". Now select "this account" and fill in sqlserver and the corresponding password.

Step 4: restart the MYSQL service.

Find "MYSQL" in the service just now, right-click-"restart", and the system will restart the MYSQL service.

After the startup, check whether the Running Account of mysqld-nt.exe in the task manager is changed to sqlserver.

So far, the execution of MySQL settings with the GUESTS permission has been set.

Note: in actual use, it is best not to assign any group to the new user. It is an independent user. Besides running mysql without any permissions, sqlserver is similar to the original one, however, the configuration is more complicated than mysql.