Several sections of the MySQL Administrator main window are devoted to server configuration:
There is also an Options … item in the Tools menu that brings up the Options dialog. This dialog enables you to change general program settings, manage connection profiles, and set MySQL Table Editor preferences. This dialog is largely similar to the Options dialog provided by MySQL Query Browser and is described in Section 3.6, "The Options Dialog." 26.4.1. Service ControlWhen MySQL Administrator starts, it displays its Connection dialog. Normally, you use this dialog to connect to a server and MySQL Administrator presents its main window in normal mode. If instead you hold down the Control key and select the Skip button in the Connection dialog, MySQL Administrator displays the main window in configure-service mode. This mode is useful for starting a server when no server is running to which you can connect. MySQL Administrator operation depends on whether you're running in configure-service mode or normal mode:
The capabilities provided by the Service Control section currently work only for local servers, and those provided by the Configure Service tab are designed to control MySQL servers that have been installed to run as Windows services. The Service Control section has two tabs:
26.4.2. Startup VariablesThe Startup Variables section presents an interface to the settings present in the server's option file. This capability is available only for local servers. If the file is writable, you can change the settings and write the changes back to the file to affect future server operation. For example, you can enable or disable log files, set the default storage engine, and change the size of memory caches. The server must be restarted before changes take effect. There are many server configuration options, so this section has several tabs that organize the available settings into groups of related options. See Figure 26.2. Figure 26.2. MySQL Administrator Startup Variables section.26.4.3. User AdministrationThe User Administration section enables you to manage MySQL user accounts. You can create new accounts, edit accounts, or delete accounts. An account browser displays a list of existing accounts. Selecting an account allows you to examine and modify its characteristics, such as the username, the password, the privileges held by the account, and its resource limits. Privileges can be granted at the global, database, table, and column levels. MySQL accounts are defined by a combination of username and hostname, which means that you can have different accounts that have the same username. The account browser in MySQL Administrator provides a hierarchical view that groups accounts by username. A Clone User feature enables you to create one user from another, which is an easy way to set up new users that differ only slightly from existing users. The User Administration section has a User Information tab that enables you to associate descriptive information with each user, such as real name, telephone number, email address, and an icon. MySQL Administrator creates a user_info table in the mysql database to store this information. However, the user_info table is not a grant table and does not have anything to do with the privileges held by users. |