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


1.6.11 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.

    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.


User Comments
Sign Up Login You must be logged in to post a comment.