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

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.