Changes

The MySQL Administrator Tool

1,292 bytes added, 20:23, 26 September 2007
Connecting to the Database Server
The reason for this is that the specified user has not been granted permission to access the database server from a remote system. This problem can be resolved on the server using the MySQL Administrator. Simply launch the MySQL Administrator tool on the system hosting the database server, select the ''User Administration'' option and select the required user from the list of users in the bottom left hand corner of the window. Once selected, click with the right mouse button on the user name and select ''Add Host''. In the resulting ''Add Host'' dialog add the host name or IP address of the remote host to which you wish to allow connections and click on ''OK''. Once the user has the appropriate privileges to connect from the specified host it should be possible to connect the MySQL Administrator client to the database server.
 
== Using the MySQL Administator ==
 
Once the Administrator tool is connected to a database server the following options are available:
 
* '''Server Information''' - displays information about the server and client systems including the version of MySQL client and server software, the client operating system and hardware and the IP addresses of both hosts.
 
* '''Service Control''' - When connected to the server from a client on the server host and with appropriate privileges, the server may be stopped and started from this screen. In addition, this option displays the server startup logs.
 
* '''Startup Parameters''' - Allows a wide range of server startup options to be specified.
 
* '''User Administration''' - Allows new users to be added and existing users to be deleted. In addition, a wide range of access privilege settings for each user may be configured using this screen including controlling database access and limiting the number of queries a user may perform in a given time period.
 
* '''Server Connections''' - Provides a list of the current connections to the database server. The user name, remote location and activity are listed for each connection. In addition, any connected may be killed by selecting it in the list and pressing the ''Kill Connection'' button.