How To Install Mysql Administrator In Windows

---

Buy and download the full PDF and ePub versions of this MySQL eBook for merely $ix.99

The MySQL Administrator is a powerful graphical client tool designed to ease the assistants and monitoring of the MySQL database server. In one case installed, the MySQL Ambassador connects to the specified database server and allows tasks such as adding users, monitoring the server operation and server connections and the backup and restoration of databases to exist performed quickly and easily.

Note that whilst this tool is however available for some platforms, this functionality is now provided using the MySQL Workbench tool, details of which may be constitute in the chapter entitled Administering and Monitoring MySQL using the MySQL Workbench.

Contents

Getting and Installing MySQL Administrator

The MySQL Ambassador is not supplied with the basic MySQL installation and must exist downloaded and installed separately. Both pre-congenital versions of the tool for Windows, Linux and Mac Bone and the source lawmaking for this tool can be obtained from:

http://dev.mysql.com/downloads

The Windows version of the GUI tools is supplied every bit an installer executable. To perform the installation, simply launch the installer once the download is complete.

The Linux version of the tools can be downloaded using RPM (notation that the filenames may change for later on releases or unlike Linux versions of the software):

su - rpm -ihv mysql-gui-tools-5.0r12-1rhel4.i386.rpm rpm -ihv mysql-administrator-5.0r12-1rhel4.i386.rpm        

On Windows, the MySQL Ambassador can exist launched from the Desktop Start menu. On Linux, the tool is launched as follows:

mysql-administrator        

Connecting to the Database Server

In one case MySQL Administrator starts, the login screen will announced as follows:

Enter the IP address or the name of the host on which the database server is running together with the database user login name and password and click connect. The MySQL Ambassador should connect to the designated database server and brandish the "Server Data" screen:

If the database server is running on a remote host it is possible the connectedness will neglect with a bulletin similar to the following:

Could non connect to the specified example.  MySQL Error Number 1045 Admission denied for user 'username'@'192.168.2.xi'(using password: YES)        

The reason for this is that the specified user has not been granted permission to access the database server from a remote arrangement. This trouble tin be resolved on the server using the MySQL Ambassador. Simply launch the MySQL Ambassador tool on the system hosting the database server, select the User Administration selection and select the required user from the list of users in the bottom left manus corner of the window. One time selected, click with the right mouse push on the user proper 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 post-obit options are available:

• Server Information - displays information nigh the server and client systems including the version of MySQL customer and server software, the customer operating system and hardware and the IP addresses of both hosts.

• Service Control - When connected to the server from a customer on the server host and with appropriate privileges, the server may exist stopped and started from this screen. In addition, this choice 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 improver, 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 listing of the current connections to the database server. The user name, remote location and activeness are listed for each connectedness. In improver, any connected may be killed by selecting it in the list and pressing the Kill User button.

• Health - This screen allows a wide range of server metrics such as database queries, connections, traffic and retentivity usage to be monitored in real-time graph grade.

• Backup - Provides a user friendly mechanism for backing upwardly the databases maintained past the current server. The Advanced backup screen allows Backups to be scheduled on a regular ground.

• Restore - Restores one or more than databases from a fill-in session.

• Replication - Provides a visual overview of the replication master and slaves. Icons beside each machine signal which slave machines are connected to the principal and which are currently off-line.

• Catalogs - Allows catalogs, tables, schemata and tables to exist viewed. Too allows new databases and tables to be created. A list of existing catalogs and schema is located in the bottom left corner of the screen, enabling an existing entry to be selected and edited. This screen is not merely a good style to create databases and tables, it is also invaluable every bit a tool for learning about the layout of existing databases and tables. This topic is covered in particular in Creating New Databases and Tables with MySQL Administrator.

Summary

The MySQL Administrator provides an easy to utilize and user friendly mode to administer many aspects of a MySQL server and related databases. A description of the full capabilities of this tool are beyond the scope of this chapter, but given intuitive nature of the tool, simply exploring the different screens volition speedily bring the user up to speed.

Purchase and download the full PDF and ePub versions of this MySQL eBook for only $nine.99

---

Source: https://www.techotopia.com/index.php/The_MySQL_Administrator_Tool

Posted by: hatfieldivii1991.blogspot.com

Share this post