Users wizard (MySQL)

The MySQL Users Wizard lets you provide basic identification, grant privileges, and specify valid host information for a user definition.

To create a new user using a wizard:

Open a creation wizard for a user. For details, see Opening an Object Wizard.
Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- User Information panel - for details, see Users - User Information
- User Hosts panel - for details, see Users - User Hosts
- System Privileges and Object Privileges panels - for details, see Setting Permissions or Privileges for an Object
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object
Finally, use the Execute button to create the object.

Users - User Information

When creating or editing a user definition, this tab/panel lets you work with the following settings:

Setting	Description
User Name	The name of the new user. At this time, the name cannot exceed 16 characters, although the field accepts 34. The discrepancy cannot be enforced, so we urge you to show a little restraint. This is the name that is displayed in the User branch of the Navigator/Explorer tree. If you leave this field blank and complete the process, you create an <anonymous> user. Only one anonymous user per datasource is allowed.
Full Name	OPTIONAL. At this time, the name cannot exceed 16 characters, although the field accepts 34. If you entered a nickname or an alias in the user name field, you can display the user’s true identity here.
Description	OPTIONAL. Write a brief description of the user if you want.
Email	OPTIONAL. The new user’s email address.
Contact Information	OPTIONAL. The new user’s title, address, phone number or whatever contact information you want to include.
User Icon	OPTIONAL. If you want to identify your new user by color or pattern, you can use the icon editor to make a distinguishing mark. You can assign groups of users the same icon or assign each user his or her own icon. This tool helps you distinguish users at a glance. Note: If you don’t want to use the head that’s preloaded, simply click the red X and start designing your own with the other tools.

When creating or editing a user definition, this tab/panel lets you specify the valid hosts from which the user can connect to the server.

Add a new host to the list by clicking the New button. Use the associated dropdown to select a valid host-name value (such as localhost or %), overwriting the text as necessary to provide a specific quoted identifier. Provide a password in the Password and Confirm fields and click Apply.

Note: Click Apply To All to assign the current password for each host currently in the list.