Free mysql admin software for linux

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.

PHP Mini SQL Admin is a light, standalone script for accessing MySQL databases. PHP Mini SQL Admin is intended for Web developers and requires knowledge of SQL commands.

OpenVPN Admin is a GUI for OpenVPN it is writen in Mono and runs under Linux and Windows.

Included in OpenVPN-Admin is a Certificate wizard and a certificate management for the client.

GRUB Web Admin module allows webmin (a web-based interface for system administration for Unix) to manage the grub bootloader.

AIM Sniff is a utility for monitoring and archiving AOL Instant Messenger messages across a network.
You can either do a live dump (actively sniff the network) or read a PCAP file and parse the file for IM messages. You also have the option of dumping the information to a MySQL database, a flat file, STDOUT, or any combination of the three.
AIM Sniff allows administrators to see how often users are chatting to monitor for abuse and you can also use AIM Sniff to monitor for cases of harassment or pirated software trading. It has been tested on FreeBSD, Linux, and OS X.
AIM Sniff is licensed under the GNU General Public License (GPL).
Enhancements:
- Several bugfixes from the alpha release are included, as well as a few feature enhancements.
- Daemon mode is now working, and there is a feature to not use a handles file (useful when using the software behind a NAT).
- In addition, the install will prompt for MySQL admin credentials for creating the database.
- Issues with the MSN message types crashing the DB and connections to the DB timing out after a period of time have been fixed.
- Also fixed is "noise" from database SQL statements.

Admin is entirely written in Java. It uses Swing GUI Components and JDBC to connect to databases. It has been succesfully tested with MySQL, InstantDB, Oracle, Empress, and PostgreSQL.

You can have a tree view of the RDBMS or pick a single instance to have a look at its metadata. It allows you to create, modify, and drop tables and to create indices on a table. The dynamic form makes it easy to enter data into a certain table, and the guided query makes it easy to retrieve data from a table and to export it.

Java developers will probably enjoy the code generator doing an OO relational wrapper and a swing GUI for them. You can also export and import data and transport it from one DBMS to another.

DBD::mysql is a Perl module with MySQL driver for the Perl5 Database Interface (DBI).

SYNOPSIS

use DBI;

$dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";

$dbh = DBI->connect($dsn, $user, $password);


$drh = DBI->install_driver("mysql");
@databases = DBI->data_sources("mysql");
or
@databases = DBI->data_sources("mysql",
{"host" => $host, "port" => $port});

$sth = $dbh->prepare("SELECT * FROM foo WHERE bla");
or
$sth = $dbh->prepare("LISTFIELDS $table");
or
$sth = $dbh->prepare("LISTINDEX $table $index");
$sth->execute;
$numRows = $sth->rows;
$numFields = $sth->{NUM_OF_FIELDS};
$sth->finish;

$rc = $drh->func(createdb, $database, $host, $user, $password, admin);
$rc = $drh->func(dropdb, $database, $host, $user, $password, admin);
$rc = $drh->func(shutdown, $host, $user, $password, admin);
$rc = $drh->func(reload, $host, $user, $password, admin);

$rc = $dbh->func(createdb, $database, admin);
$rc = $dbh->func(dropdb, $database, admin);
$rc = $dbh->func(shutdown, admin);
$rc = $dbh->func(reload, admin);

EXAMPLE

#!/usr/bin/perl

use strict;
use DBI();

# Connect to the database.
my $dbh = DBI->connect("DBI:mysql:database=test;host=localhost",
"joe", "joes password",
{RaiseError => 1});

# Drop table foo. This may fail, if foo doesnt exist.
# Thus we put an eval around it.
eval { $dbh->do("DROP TABLE foo") };
print "Dropping foo failed: $@n" if $@;

# Create a new table foo. This must not fail, thus we dont
# catch errors.
$dbh->do("CREATE TABLE foo (id INTEGER, name VARCHAR(20))");

# INSERT some data into foo. We are using $dbh->quote() for
# quoting the name.
$dbh->do("INSERT INTO foo VALUES (1, " . $dbh->quote("Tim") . ")");

# Same thing, but using placeholders
$dbh->do("INSERT INTO foo VALUES (?, ?)", undef, 2, "Jochen");

# Now retrieve data from the table.
my $sth = $dbh->prepare("SELECT * FROM foo");
$sth->execute();
while (my $ref = $sth->fetchrow_hashref()) {
print "Found a row: id = $ref->{id}, name = $ref->{name}n";
}
$sth->finish();

# Disconnect from the database.
$dbh->disconnect();

DBD::mysql is the Perl5 Database Interface driver for the MySQL database. In other words: DBD::mysql is an interface between the Perl programming language and the MySQL programming API that comes with the MySQL relational database management system. Most functions provided by this programming API are supported. Some rarely used functions are missing, mainly because noone ever requested them.