Free mysql administration software for linux

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.

LDAP Administration Tool is a tool to manage LDAP-based directories.
LDAP Administration Tool stands for LDAP Administration Tool. The tool allows you to browse LDAP-based directories and add/edit/delete entries contained within. It can store profiles for quick access to different servers.
Main features:
- User, Group Computer and user-defined views
- Directory browser
- Schema browser
- LDIF imports and exports
- Samba and Active Directory support
- Mass-edit support
- Integration with GNOME

NWN Server Administration is a Web interface for managing NeverWinter Night servers.
This interface provides many features for monitoring and controlling multiple servers on the same computer.
The interface provides support for nwnx, and has an interface for running database queries.
Enhancements:
- Fixed problem with Character Administration with usernames with symbols in their names such as -. Also fixed
- the Administration privileges with same problem.
- Fixed issue with a Non-Privileged user couldnt download the NWN Campaigns.
- Fixed issue with deleting a character with a symbol in the name.
- Added HotU portraits and classes.
- Changed access privileges on Character Administration. Made Deleting characters a separate privileges.
- Changed access on Uploading files, Upload is now a separate privilege.
- Added a NWN Server Administration Options page, currently has adminemail address setting, and ability to hide/show unprivileged commands to the user.

Server Web Administration Tool is a self-extracting shell script that installs a perl module called Linux::Statistics and a bunch of perl scripts that provide detailed information about a server.
Information includes : memory usage, disk usage, cpu usage, file usage, network usage, swap usage inode and file handle usage, socket information and information about paging on the server etc. There is also a script to check whether a particular process/daemon is running or not.
You can run the script by running "sh swat-1.0.0.sh" as root.
Enhancements:
- This version comes with a bundled installation of the Apache 1.3.29 Web server.

Open Admin for Schools is a School Administration Program. It is a freely available, open source software package and is licensed under the GNU General Public License.
Open Administration for Schools project is entirely web based and can run from a centrally located division wide server or a single computer in a school. It is designed to support an entire division on one or more central computers but can also work just fine for a single school.
Currently several school divisions use this approach and have 15+ schools on a single central server. This is because it is designed to be lightweight both in server resource requirements and in communication bandwidth.
It is secure. Each school has two or more virtual websites and each is protected with password(s). One site, the admin site, is used by the school office and another, the teacher site, is used by teachers in the classroom.
The teacher site also has password access for entering attendance by teachers and also uses cookies that expire in a short period, further limiting access. Another site, a parent/student site, is controlled by parent/student userids and passwords. A fourth virtual site may be used by school liason officers from outside agencies to give them a slightly different access to school information. (Community Schools)
Main features:
- Demographics - It stores student and family information that can be viewed and printed in a variety of ways.
- Attendance - Attendance can be entered either by secretaries in the school office or by teachers in the classroom. It features the ability to do different numbers of periods per day for elementary grades vs high school and middle years. This will allow elementary classes to have 2 classes per day (AM/PM) with a homeroom teacher while higher grades can have attendance done on a per subject period basis (and be subject based). Attendance reports are integrated with report cards/progress reports. A variety of attendance reports are available. A variety of attendance entry methods are available for use by teachers and/or secretaries to allow it to integrate with normal school practice.
- Discipline - A simple discipline module to track student discipline events and track outcomes, etc. Behaviours may be categorized and statistical reports may be printed. Enrollment changes are also posted into this system.
- Report Card System - a flexible reporting system with per subject objectives (up to 20), integrated attendance reporting, etc. All report cards are printed as PDF reports and may include a school logo. All subjects may have unlimited length text comments, and can have any desired ordering. Attendance reporting will now do days open, days enrolled, days absent, and times late as standard.
- IEP (Special Needs) Site that is integrated at the division level that allows special needs teachers to tailor individual student programs that can be viewed from each schools teacher site. This includes the ability to add student medical history, testing done, student teams (and responsibilities), and objectives chosen from lists of thousands, categorized in a variety of ways. There can be up to 32 objectives per subject and each subject is specific to that particular child. His/her program would consist of a variety of subjects in areas such as fine motor control, etc.
- This system can generate progress reports (for use with the report card system) as well as a comprehensive IEP report containing the yearly plan for the child. This IEP can also viewed from the teacher site, to ensure compliance throughout the year.
- Export/Import Modules - to allow students to easily transfer schools within divisions without re-entry of demographic information. Export of data to other programs. Export of data to Provincial authorities via an automated XML based transfer mechanism.
- Saskatchewan SDS support for direct XML transfers of student demographic, subject and enrollment marks to provincial authorities.
- Online Gradebook to allow teachers to enter marks and assessments onine from school or home. It can group and weight assessment items and post directly into the report card system.
- Parent Viewing scripts to allow parents to view attendance, gradebook(where allowed), and report card marks. This is easily integrated into existing school sites.
- Upcoming: Family functions, Parent-Teacher Interview Scheduling, Wherever schools want to go...
- Further out... Multi-language support (demand for a Spanish version exists currently), Student timetabling.
Enhancements:
- A new Fees System to allow fee charging (predefined or new, with various groups), invoice printing, payments and receipts, and the ability to export summary journal transactions to an external accounting program.
- A new teacher logout to remove session data has been added.
- There is a new 70 page User Documentation PDF and a 40 page Administration Documentation PDF (also available in HTML versions).

Mysql Data Manager (shortly MDM) is multifunctional and multiplatform web based mysql administration tool and data editor. Mysql Data Manager is a CGI script written in Perl. It uses web browser based GUI, which provides a complete set of high-level and low-level capabilities.
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.

MySQL Activity Report is a valuable database tuning aid.

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 is a patch that reads table creation file (tables.sql) and compares it to what mysqldump gives. It creates SQL clauses to update the database to match the creation file.