26.4. Server Configuration


Several sections of the MySQL Administrator main window are devoted to server configuration:

  • Service Control enables you to configure MySQL services on Windows.

  • Startup Variables provides an interface to the settings contained in the server's option file. By changing these settings, you can change server configuration.

  • User Administration displays MySQL account information and allows you to create, edit, and delete accounts.

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 Control

When 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:

  • In configure-service mode, the main window displays only the Service Control, Startup Variables, and Server Logs sections. In normal mode, those sections are displayed along with all the other sections.

  • In configure-service mode, MySQL Administrator displays a panel in the main window that lists all available MySQL services. You can select any of them to indicate which service to configure. In normal mode, you can configure only the first MySQL service and the service-list panel is not displayed.

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:

  • The Start/Stop Service tab displays status information about the service, such as the service name and whether the server is running. A button enables you to start or stop the service and a display area shows status messages resulting from such actions.

  • The Configure Service tab is displayed only on Windows. It allows you to change the configuration of a MySQL Windows service. Changes to most of these settings require a server restart to take effect.

26.4.2. Startup Variables

The 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 Administration

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



MySQL 5 Certification Study Guide
MySQL 5.0 Certification Study Guide
ISBN: 0672328127
EAN: 2147483647
Year: 2006
Pages: 312

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net