:: DEVELOPER ZONE
MySQL Administrator :: 9.3 User Information
The fields in this tab are unavailable unless you either click on a username in the Us er Accounts area of the sidebar, or create a new user in that sidebar or using the button on this tab. In the former case, the fields are filled with the information stored for that user, in the latter case, all fields are empty.
Note that all fields will be stored only when you click the button. If you don't want to save your changes, click the button.
The values you enter in the fields of this tab are stored on the
MySQL server. The fields in the Login
Information group of this tab are stored in the
user table of the mysql
database, while the fields in the Additional
Information group are stored in the
user-info table of the mysql
database. The latter table is created the first time you add a new
user, or change an existing user. Its contents may look like this:
mysql> SELECT * FROM mysql.user-info \G
*************************** 1. row ************
User: superuser
Full-name: Stefan Hinz
Description: MySQL Documentation Team
Email: stefan@mysql.com
Contact-information: Phone: +49 30 123456789
Fax: +49 30 987654321
ICQ: 123456789
Icon:
-
Login Information
MySQL User: Username that is specified when connecting to the MySQL server. Note that this username has nothing to do with usernames you might use elsewhere on your operating system. It is recommendable not to use special characters or spaces for that username.Password: Password that is specified when connecting to the MySQL server. Note that this password has nothing to do with passwords you might use elsewhere on your operating system. It is recommendable not to use special characters or spaces for that password. It is, however, recommendable to use non-trivial passwords. A very trivial password might beabcde, while a non-trivial password might belEtusMak3iThartdoGesz. Note that it is not mandatory to specify a password, although it is highly recommendable to do so.Confirm Password: Fill in the password once again to make sure you do not accidentally introduce a typo.
-
Additional Information
All information specified here is optional.
Full Name: As opposed to the username inMySQL User, the full name may contain any characters, including spaces.Description: Additional description of user.Email: Email address of user.Contact Information: More contact information, like postal address, or messenger information.Icon: Rather than using the default icon, you may select a different icon by pressing the button. You can either use one of the buttons that are shipped with MySQL Administrator , or use an icon of your own. In the latter case, be aware that the icon has to be exactly 48 by 48 pixels in size, and its file format has to bePNG(portable network graphics).
© 1995-2005 MySQL AB. All rights reserved.
