Users wizard (MySQL)

Go Up to MySQL object wizards

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

1. Open a creation wizard for a user. For details, see Opening an Object Wizard.
2. 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 panel and Object Privileges panel. 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.
3. Click Execute 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. 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.
Email	Optional. The new user email address.
Contact Information	Optional. The new user 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 an icon. This tool helps you distinguish users at a glance. Note: If you do not want to use the pre-loaded heading, click the red X and start designing your own with the other tools.

Users - User Hosts

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 New. 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. Complete the Password and Confirm fields, and then click Apply.

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

• Remove a selected host from the list by clicking Delete.