Free mysql front software for linux

Mysql Assistant is a MySQL viewer. Mysql Assistant requires Ruby-Gtk2 and MySQL/Ruby.

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.

MySQLfs is Linux userspace filesystem which stores data in a MySQL database. The project uses FUSE to interface with the kernel.

yoursql project is a mysql version fingerprint tool written in C.

This will only work on hosts that actually let you connect, if you are blocked by an ACL, this wont work.

Qt MySQL Budget project is a GUI that allows the creation of a personal budget.

The basic layout is a month selector, a tab for your allocations (budget), a tab for your expenses, and a tab showing the totals.

It has a very simple design allowing the quick creation and updating of budgets to help individuals plot and track their monthly sending.

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.

MySQL Query Browser is a database querying tool.

MySQL Query Browser combines the simplicity of a Web-browser-like interface with powerful features like multiple result sets on tab sheets, query history, storing query "bookmarks", editing and comparing resultsets, SQL script debugging, and more.

MySQL Query Browser is available under the MySQL AB "dual licensing" model. Under this model, users may choose to use MySQL products under the free software/opensource GNU General Public License (commonly known as the "GPL") or under a commercial license.

MySQL Squid Access Report, mysar for short, is a reporting system for user web traffic activity, as logged from a squid proxy.
MySAR consists of two parts:
- Command line utilities which import a squid log file in a MySQL database and maintain the databas.
- A web interface for accessing the reports.
Main features:
- Free. Licenced under the GPL, mysar is free for everyone to use.
- Dynamic. Forget about static reports that take ages to generate, hogging the systems CPU. Mysar is is the only squid reporting system with a database as its backend.
- Almost realtime. No longer do you have to wait for the next hour or day for the reports to be generated. All of the user activity is available to you when you want it. NOW.
- Portable. Written in pure PHP, mysar is available to any unix-based OS platform PHP supports, without any modification.
- Flexible. Since the code is open-source, you can customize it to your needs. Create you own reports as you see fit.
- Supported. Mysar project has a mailing-list, forum and an active maintainer.
- Stable. Utilizing mature and stable software like Smarty, MySQL and PHP, mysar is standing on the shoulders of giants.
- Easy. With a foolproof installation and a user-friendly web interface, mysar makes web traffic reporting easier than ever.
- Customizable. Mysar neednt be on the same server as squid or MySQL. If your load is too high, just load-balance your processes as you see fit.
Enhancements:
- This version added 64-bit support for the binary importer.