Transcript MySQL Administrator

A Brief Documentation

Provides basic information about
connection, server, and client.
Information about the parameters used to connect to
the MySQL server.
◦ Username: Username used for the current
connection to the MySQL server.
◦ Hostname: The name of the machine hosting the
MySQL server. This is either identical to the name
listed in Network Name, or it islocalhost.
◦ Port: The port used for connecting to the MySQL
server.
Information about the MySQL server and its host.
◦ MySQL Version: The version of the MySQL server.
◦ Network Name: The name of the machine hosting
the MySQL server.
◦ IP: The IP number of the MySQL server host.
Information about MySQL Administrator and the host
client.
◦ Version: The version of MySQL Administrator, and
the version number of the MySQL client/server
protocol.
◦ Network name: The name of the host where
MySQL Administrator runs.
◦ IP: The IP number of the MySQL Administrator
host.
◦ Operating System: Information about the
operating system on which MySQL Administrator
runs.
◦ Hardware: Information about the hardware on
which MySQL Administrator runs.

This section shows how to start and stop
the MySQL server you are connected to.
Currently, this is only possible if the server
is running on the same machine that hosts
MySQL Administrator. You cannot start and
stop MySQL servers on remote machines.
Tabs: Start and Stop Service, Configure
Service

This section allows you to set variables that
the MySQL server reads on startup. These
variables are stored in the option file of the
server.

This section shows how to administer
existing users, add new users, and delete
existing users.
Tabs: User Accounts, User Information,
Schema Privileges, Table Column Privileges,
Resources

This section allows you to view and manage
the current connections to the server (also
called threads).
Tabs: Threads, User Connections

This section of MySQL Administrator shows
you how to graphically monitor the realtime status of your MySQL server
Tabs: Connection Health, Memory Health,
Creating Custom Health Graphs , Status
Variables, System Variables

The Server Logs section provides easy
access to the various log files generated by
the MySQL server. You can access the
server's error log, slow query log, and
general log using this section.
Tabs: Error Log, Slow Log, General Log

The Replication Status sections give you a
visual overview of your MySQL replication
master and slaves. The server status icons
beside each machine tells you which slave
machines are connected to the master and
which ones are offline.
Section: Configuring Replication Servers

This section shows you how to create backup
projects and to perform backups. This section
will produce backup files that are plain text
and composed of multiple SQL statements
that can be executed to restore your
database, similar to the output generated by
the mysqldump utility.
Tabs: Backup Project, Advance Options,
Schedule

The Restore section helps with disaster
recover by helping you restore backup files
created using MySQL Administrator.
Tabs: General, Restore Content

This section deals with viewing catalogs,
schemata, tables and their properties,
creating databases, and performing a
number of operations on tables.
Tabs: Schema Tables, Schema Indexes