Free mysql administrator software for linux

Zimbra Collaboration Suite project is a client/server technology for enterprise messaging and collaboration.
Zimbra delivers innovation for both the administrator and the end-user as well as compatibility with existing infrastructure and applications (both open source and proprietary).
The Zimbra Collaboration Suite provides support for email, contacts, and group calendaring, and consists of a server and client.
Main features:
Administrator Benefits
- Online move, backup and recovery of individual or a group of mailboxes
- Compatibility with Active Directory and existing LDAP directories
- Native hierarchical storage management and clustering
- Web services integration with existing enterprise applications
- Integrated anti-spam and anti-virus
End-User Benefits
- Browser based client with search, shared calendar and mail that is integrated with contacts and calendar
- Support for Outlook: calendar, mail, contacts and offline mode
- Support for mobile devices: Blackberry, Treo and etc
- Support of Windows, Apple and Linux computer.
Whats New in 5.0.0 Beta 1 Development Release:
- This is the first release in the 5.0.0 release cycle.
- New features include IM, Tasks, Standard Client autocompletion, and keyboard navigation.
- Updates have been made to migration wizards and apple/outlook connectors.
Whats New in 4.5.6 Stable Release:
- Support for an automated MySQL database corruption check that will send a notification to the admin.
- Spam training has been enhanced by allowing programmatic scanning of folders without requiring a password.
- Admins can get backup and restore complete notifications sent via email.
- .Doc and .pdf files open correctly in Zimbra Web Client.
- iSync will not duplicate the calendar, and iSync Connector works correctly with Mac OS X 10.4.10.
- Servers automatically start after a ZCS upgrade.
- Web-based cross-mailbox discovery is available for the optional Zimbra Archiving and Discovery module.

MySQL Administrator is a powerful visual administration console that enables you to easily administer your MySQL environment and gain significantly better visibility into how your databases are operating.
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.

Zmanda Recovery Manager for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server. With ZRM for MySQL you can:
- Schedule full and incremental logical or raw backups of your MySQL database
- Perform backup that is the best match for your storage engine and your MySQL configuration
- Get e-mail notification about status of your backups
- Monitor and browse your backups
- Recover database easily to any point in time or to any particular transaction

MySQL Backup for lazy sysadmins (mysqlblasy) is a Perl script for automating MySQL database backups. It uses "mysqldump" for dumping mysql databases to the files sytem. MySQL Backup for lazy sysadmins program was written with automated usage in mind.
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

MySQL Pack for QNAP TS-101/TS-201 was created to install MySQL on the QNAP NAS server, TS-101/TS-201. It contains a pre-compiled MySQL server and install programs. The php module supporting MySQL client will be also included if its necessary. The Pack also contains simple webpages for start/stop mysql.
Installation:
Create a share folder named MySQL. You may directly create Network Shares named MySQL on TS-101 Administration page. Please make sure both the real folder name and share volume name be MySQL.
Upload and unzip the package file (e.g. MySQL-4.1.21-TS-101-v0.2.tar) to the share folder created in the step 1. Here, using administrator to access the share folder is recommanded.
login in your TS-101 through Telnet Refer to http://scratchpad.wikia.com/wiki/Open_Turbostation:TS101, or find a TS-101 firmware with telnet enabled (You may find it on http://tech.groups.yahoo.com/group/OpenTurbostation/)
Run install.sh to install MySQL > /share/MySQL/install.sh /share/MySQL/mysql-4.1.21-TS-101.tgz /share/MySQL
Run mysqld.sh to start/stop MySQL > /usr/local/mysql/mysqld.sh start > /usr/local/mysql/mysqld.sh stop
Try to connect MySQL If you could connect MySQL with the following command, it means that your MySQL works. > /usr/local/mysql/bin/mysql mysql -u root --password=admin
After installation finished, MySQL will automatically start while booting. You may also run sys_initialize.sh to re-initialize MySQL. sys_initialize.sh wont remove the existed MySQL Pack and your database. > /share/MySQL/sys_initialize.sh /share/MySQL
Enhancements:
- PHP supports sockets.
- gd-jpeg errors that occurred in PHP have been fixed.

YALA is a web-based LDAP administration GUI. The idea is to simplify the directory administration with a graphical interface and neat features, though to stay a general-purpose program (unlike some LDAP browsers written specifically for managing users on the system).
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)

IdealMySQL is a PHP class that provides an interface for working with MySQL databases.

The project can connect to a database, execute queries on a database, check variable names for validity, and catch errors and email them to the administrator.

All error messages are stored in a text file that can be easily edited, and the look and feel of the error output to the user is controlled by a style sheet.