Documentation Home
MySQL and Windows
Download this Excerpt
PDF (US Ltr) - 2.4Mb
PDF (A4) - 2.4Mb
EPUB - 2.1Mb
HTML Download (TGZ) - 2.1Mb
HTML Download (Zip) - 2.1Mb


MySQL and Windows  /  ...  /  MySQL Server Instance Config Wizard: The Security Options Dialog

1.5.11 MySQL Server Instance Config Wizard: The Security Options Dialog

The content of the security options portion of the MySQL Server Instance Configuration Wizard will depend on whether this is a new installation, or modifying an existing installation.

  • Setting the root password for a new installation

    It is strongly recommended that you set a root password for your MySQL server, and the MySQL Server Instance Config Wizard requires by default that you do so. If you do not wish to set a root password, uncheck the box next to the Modify Security Settings option.

    Note

    If you have previously installed MySQL, but not deleted the data directory associated with the previous installation, you may be prompted to provide the current root password. The password will be the one configured with your old data directory. If you do not want to use this data, or do not know the root password, you should cancel the installation, delete the previous installation data, and then restart the installation process. For more information on deleting MySQL data on Microsoft Windows, see Section 1.4.3, “Removing MySQL When Installed from the MSI Package”.

    MySQL Server Instance Config Wizard: Security
  • To set the root password, enter the desired password into both the New root password and Confirm boxes.

    Setting the root password for an existing installation

    If you are modifying the configuration of an existing configuration, or you are installing an upgrade and the MySQL Server Instance Configuration Wizard has detected an existing MySQL system, then you must enter the existing password for root before changing the configuration information.

    MySQL Server Instance Config Wizard: Security (Existing Installation)

    If you want to change the current root password, enter the desired new password into both the New root password and Confirm boxes.

To permit root logins from across the network, check the box next to the Enable root access from remote machines option. This decreases the security of your root account.

To create an anonymous user account, check the box next to the Create An Anonymous Account option. Creating an anonymous account can decrease server security and cause login and permission difficulties. For this reason, it is not recommended.