mysql administrator manual
MySQL Administrator 1.2
MySQL Administrator is a powerful visual administration console that enables you to easily administer your MySQL environment. more>> <<less
MySQL Administrator for Linux 1.0.12
A powerful visual administration console that enables you to easily administer your MySQL environment more>>
MySQL Administrator now integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface.
By using MySQL Administrator you will be able to:
- Achieve higher database availability through improved management
- Reduce errors through visual database administration
- Lower database administration costs through improved productivity
- Deliver a more secure environment through easier privilege management
MySQL Administrator enables developers and DBAs to easily perform all the command line operations visually including configuring servers, administering users, and dynamically monitoring database health.
Other common administrative tasks such as monitoring replication status, backup and restore, and viewing logs can also be performed through the MySQL Administrator graphical console.
User Administration in Minutes
Administering users, granting privileges and viewing user privilege information has never been easier! Now you can leverage the full power of MySQLs user management and privilege capabilities to fully protect your MySQL server host using an integrated graphical user administration console.
For example, a form-based interface provides a simple method for adding users, assigning passwords and including user profile information. Plus, assigning and revoking global, database, and table/column privileges is as easy as adding and removing privilege items from an available list. Finally, an explorer interface provides a hierarchical view allowing you to easily view user privileges by privilege type.
Single View Dynamic Health Monitoring
Dynamic health monitoring gives you an immediate view into the key indicators of the health of your MySQL environment. Dynamic graphs enable you to easily view percentage of memory usage, connection usage, hit rates, as well as the number of SQL queries on an ongoing basis, as your system runs.
The Disk Health tab gives you an overview of the amount of hard disk space, tablespace, and log files being used. You can also use the visual health monitoring feature to get a hierarchical view into status and server variables such as the number of outstanding connections, number of bytes sent and received by clients, buffer allocations size and more.
Quickly Optimize MySQL
MySQL Administrator now allows you to easily view and setup key parameters so you can quickly optimize the performance of MySQL. Using a graphical forms-based environment, you quickly fine tune general and advanced parameters. For example you can set memory usage parameters and configure server start-up parameters related to the MyISAM and InnoDB table types.
Rapid Disaster Prevention and Recovery
Now you can rapidly create consistent backups and restore data by simply visually selecting the schemas and tables you want to back/restore from your hierarchical data directory. The graphical environment gives you additional visibility into Tabletype, Rows, Data Length, and Update time.
Server Information At-a-Glance
The server information section of MySQL Administrator allows you to quickly view basic information about the server and client. This view gives you immediate visibility into items such as server status, client and server version numbers and IP address, as well as connection information.
View Replication Status
Now you can quickly set up replication to increase the robustness and speed of your MySQL environment. The replication features within MySQL Administrator allow you to easily view the network topology of your replication master and slaves. Plus, the graphical environment provides additional visibility into IP addresses and logfiles.
View Server Logs from a Centralized Administration Environment
Now you can view all the MySQL log files including error logs, binary logs, and InnoDB logs from a single, centralized administration environment so you can diagnose server problems quicker and track database changes.
Service Control
Gain complete control of service creation and overcome the time consuming task of installing and setting up services. Plus, start and stop MySQL servers and view corresponding log messages.
Browse Catalog
Browse your catalog and view corresponding tables with columns, all indices and users with privileges to access selected databases. From here you can monitor and optimize tables.
Cross Platform
MySQL Administrator will initially be available for Microsoft Windows and Linux, and be compatible with MySQL version 4.0 or later.
MySQL Abstractor 2.2
MySQL Abstractor package contains PHP classes that implements a MySQL database abstraction layer. more>>
It provides several classes. There is one for establishing connections and executing SQL queries, another for composing and executing SELECT, INSERT, UPDATE and DELETE queries from a list of parameters, and a wrapper class to simplify the usage of the other two classes.
Virtual Administrator Daemon 0.2.0
Virtual Administrator Daemon is set of Perl scripts and modules which can help with remote server management. more>>
It can receive multiple commands to execute, and it has been built to provide support for a scalable system administration environment.
Since it takes XML, clients can be developed in a different set of environments with easy integration into the server.
Enhancements:
- This release added support for standalone/daemon mode, SSL support and a default SSL certificate, a default timeout of 30 seconds while reading or writing sockets, more refined log messages, and new < mode >< /mode >, < ip >< /ip >, < port >< /port >, and < listen >< /listen > configuration elements.
Mysql Data Manager 1.73
Mysql Data Manager is multifunctional and multiplatform web based mysql administration tool and data editor. more>>
High-level functions allow to accomplish a lot with a single mouse click while low-level functions let you do precisely what you want. Using this tool you get a wide range of solutions to support any Mysql web application.
You log into Mysql server via transparent interface of MDM with no need to store your password into config file. You use all privileges granted to you on Mysql server to manage your databases and accounts. All your mouseclicks are being transmitted to mysql server transparently as a command or a chain of predefined commands.
Almost all messages you may receive from MDM interface are generated natively by mysql server and transparently transferred by MDM to web browser for your convenience.
Mysqk Data Manager is a transparent interface between you and Mysql that helps you to manage your data using pre-programmed operations.
Mysql Data Manager does not require root access to MySQL Server to do all the things you need to as a Database Administrator or Web Administrator through web interface.
Here are some operations that MDM can provide:
- CREATE AND ALTER TABLES. All table types are supported
- DELETE records using WHERE clause. DROP tables
- IMPORT DATA from CSV files generated by other applications.
- EXPORT DATA from search results or entire table into CSV files to use them with other applications.
- EDIT exported CSV FILES
- BACKUP and RESTORE the entire database or selected tables in seconds.
- ACCESS MANAGEMENT - create, edit and delete Mysql user accounts in bulk.
- Manage privileges of single and multiple users on all levels: global, database, table and column.
- SEARCH AND MODIFY records using multiple search criteria. (BLOBs are supported)
- INSERT AND EDIT DATA - edit multiple records from search result, directly or by uploading files from local computer. (unquoted expressions are supported).
- EDIT, INSERT and DELETE records in Spreadsheets
- ZOOM Blob and Text fields
- Visually compose SELECT query, joining several tables.
- PRINT DATA - Generate Printable Output.
- SQL SCRIPTING - Create, save, edit and run SQL scripts and use them as Shortcuts. Multiple queries and comments are supported.
- ADMIN FUNCTIONS - Optimize, Analyze, Repair and Check tables. Show status, Variables etc.
- GENEATE "CREATE TABLE" queries
- Provide each user with dedicated subdirectory to store backups, SQL scripts and exported or uploaded ASCII files.
- Assign maximum total size per user of saved backups, SQL scripts and exported or uploaded ASCII files.
- Customize colors and add clickable image.
- Assign a desired Character Set.
- Set up operational parameters using visual interface.
Main features:
- Security. Mysql Data Manager is as secure as your Mysql Server is. User name and password are not stored in any external file. There is no need to use .htaccess protection.
- Easy installation. Only single file must be uploaded. Setup is done using visual interface. You dont need to be root user to install this Mysql web Client.
- Easy in use. No programming skills are needed. Understandable and intuitive interface.
- Reliability and Efficiency. The program generates only pure HTML code. It does not use client side scripting.
- High Speed. Low Bandwidth. No image is used to build GUI. All you see on the screen is built from standard HTML elements. That means also compatibility with all web browsers.
- Multifunctionality.
- Ability to operate in Multi-User environment as universal control panel for wide range of database applications and services.
- All data types are supported.
- All table types are supported.
- All Mysql versions are supported.
- Ability to preview and customize automatically generated queries.
- Quick Backup and Restore
- Quick Import and Export
- High performance, affordable price.
- User friendly error handling
- Platform independence. This is Perl Script.
- Local connection to databases located on a remote host. Global access over the Internet.
- Fully transparent access to Mysql Server through Perl API.
Yet Another LDAP Administrator 0.32
YALA is a web-based LDAP administration GUI. more>>
Yet Another LDAP Administrator goal is to simplify the administration but not to make the YALA user stupid: to achieve this, we try to show the user what YALA does behind the scenes, what it sends to the server (unlike Microsoft Active Directory, for example).
Main features:
- Clear and Simple interface
- Cross-Platform: YALA can be accessed from any platform using any modern browser
- Cute javascript to improve the web-interface, which can be set off if you would like
- Theoretically works with any LDAP server, see README file for list of supported LDAP servers.
- Reads the schema from the LDAP server and gets lots of useful information off there.
- Entry Types recognition: You can configure YALA to recognize an entry of objectclasses X & Y, for example, as a user entry, have a special icon for it, and allow simple creation of new entries of this type (i.e. add a new user).
- Its free (under the GPL)
SQL::Translator::Manual 0.07
SQL::Translator::Manual is a Perl module that contains a manual for SQL translator. more>>
SYNOPSIS
SQL::Translator (AKA "SQLFairy") is a collection of modules for transforming (mainly) SQL DDL files into a variety of other formats, including other SQL dialects, documentation, images, and code. In this manual, we will attempt to address how to use SQLFairy for common tasks. For a lower-level discussion of how the code works, please read the documentation for SQL::Translator.
It may prove helpful to have a general understanding of the SQLFairy code before continuing. The code can be broken into three conceptual groupings:
Parsers
The parsers are responsible for reading the input files and describing them to the Schema object middleware.
Producers
The producers create the output as described by the Schema middleware.
Schema objects
The Schema objects bridge the communication between the Parsers and Producers by representing any parsed file through a standard set of generic objects to represent concepts like Tables, Fields (columns), Indices, Constraints, etc.
Its not necessary to understand how to write or manipulate any of these for most common tasks, but you should aware of the concepts as they will be referenced later in this document.
Navicat MySQL administrator Manager for Linux (Freeware available) 8.0.28
Navicat MySQL Manager is a set of graphical database management and monitoring tools for MySQL. Navicat is easy-to-use and powerful. It supports backup/ restore, import/ export data and synchronize da more>>
Navicat Manager is an ideal solution for MySQL administration and development. This is an all-inclusive mysql front end provides a powerful graphical interface for databases management and maintenance. Easy installation
and intuitive interface make it an irreplaceable tool for mysql on the web or your local desktop. Navicat supports all verions of MySQL and it lets you convert data to/ from MySQL, synchronizes and backups database in a snap through helpful wizards. Major features of Navicat full version include Visual Query Builder, Import/ Export, Report Builder, Backup/ Restore, SSH and HTTP Tunneling and Data Transfer. Navicat also supports to import data from ODBC, batch job scheduling (create schedule for Import/Export, Data Transfer and saved queries),
printing of table structure. It also includes a full featured graphical manager for setting the users and access privileges. Navicat version 8 supports Code Completion, Form View and email Notification Services, etc. Navicat is the number 1 MySQL database administration shareware in Download.com with over 350,000 downloads and 1,100,000 installations worldwide. Some of the users including Sony Music, Intel, Kodak, FedEx, KPMG Consulting, Ericsson,
Siemens AG, Yahoo!, NTT DoCoMo (Japan), Hitachi (Japan), Imation, Lexmark, Cisco Systems, RSA Security, Avis (Europe), U.S. Department of Energy, UPS, Disney, Oxford University, Harvard University, NASA Space Flight Center, MIT, Michigan State University, University of Michigan, ...
Navicat delivers a personal experience, simplifying the way you work. The program is also available for Windows and Mac OS X.
License:Freeware
License:Freeware
Mysql Assistant 1.1.1
Mysql Assistant is a MySQL viewer. more>>
Myassistant is a MySQL viewer using, Ruby, Ruby-Gtk2, MySQL/Ruby and developed on ruby-1.8.4, Mysql-5.0.16, mysql-ruby-2.7, ruby-gtk2-0.14.1.
Currently 3 APIs are provided for MySQL, MySQL/Ruby, Ruby/MySQL, and DBI.
These are 3 different APIs, Please install proper one.
Installation:
untar package anywhere you want.
Security Issue
Myassistant create ".mydb" file which includes "Mysql server name","user name",
"password","database name" with chmod 600 on your home directory.
It could be your security hole, so please notice that.
Fonts
Currently default font is "Sans 12". If you want change it, edit row number 91.
If you have any questions or problems, please let me know.

MySQL for Linux 6.0.0
MySQL - Multi-user and robust SQL database server more>> MySQL - Multi-user and robust SQL database server. The worlds most popular open source database
MySQL is a very fast, multi-user, multi-threaded and robust SQL (Structured Query Language) database server. The worlds most popular open source database.
MySQL is an attractive alternative to higher-cost, more complex database technology. Its award-winning speed, scalability and reliability make it the right choice for corporate IT departments, Web developers and packaged software vendors<<less
source database MySQL is a very fast, multi-user, multi-threaded and robust SQL (Structured ... MySQL is an attractive alternative to higher-cost, more complex database technology. ItsMySQL Activity Report 1.0.0
MySQL Activity Report is a valuable database tuning aid. more>>
The MySQL Activity Report package is a tool to help MySQL database administrators to collect several database parameters and variables. These collected values can be used for server monitoring or performance tuning purposes.
The most important component of the MySQL Activity Report is mysqlard. This daemon collects the data from a MySQL server and stores these values in a Round Robin Database.
The mysqlard package also contains example graphing, cron and php scripts. The cron scripts can be used to keep archives of the generated graphics and the php script shows the generated graphics and tries to give some tuning tips.
MySQL table patcher 1.6.2
MySQL table patcher is a patch that reads table creation file (tables.sql) and compares it to what mysqldump gives. more>>
MySQL Backup for lazy sysadmins 0.7
MySQL Backup for lazy sysadmins (mysqlblasy) is a Perl script for automating MySQL database backups. more>>
For example, it is silent during operation, and only produces noise on errors/problems. It rotates backups automatically to prevent the backup disk from getting full when the administrator is on vacation (or is lazy).
Main features:
- syslog facility
- unix output (loglevels, errors to stderr)
- dump some or all databases from a database instance
- compress dumps (using gzip,bzip2 or perl modules)
- backup rotation to avoid disc overflow
- no shell on external commands!
- can be run as unpriviledged user
- perfect for cron jobs
Gimp User Manual 0.12
GIMP User Manual project is a user manual for the GIMP. more>>
Enhancements:
- New content (incl. spelling and grammar fixes) for German, French, Italian, Norwegian, Russian, Spanish and Korean
- The PDF version of the manual is now generated using dblatex
- Lots of bug fixes
MySQL wrapped 1.6
MySQL wrapped is a very small collection of classes that hides the MySQL C API. more>>
Examples:
The following example should be linked with the mysqlclient library from the MySQL distribution / build.
#include
#include
#include
#include
#include "Database.h"
#include "Query.h"
int main()
{
Database db("localhost","dbuser","","testdb");
Query q(db);
q.execute("delete from user");
q.execute("insert into user values(1,First Person)");
q.execute("insert into user values(2,Another Person)");
q.get_result("select num,name from user");
while (q.fetch_row())
{
long num = q.getval();
std::string name = q.getstr();
printf("User#%ld: %sn", num, name.c_str() );
}
q.free_result();
}
Enhancements:
- This release adds methods to access fields by name.



