Free mysql commands software for linux

Gtk+ MySQL Command Center is a GUI client for MySQL databases.
Gtk+ MySQL Command Center will help you to use your MySQL servers, do requests on them, manage their configuration (users, process, etc.), dump datas and structure and more.
You dont need GNOME to use it.
Main features:
- Use gtk+ only (doesnt need Gnome)
- Manage a mysql server list (Store in a XML file)
- SQL Query window (with query duplication capabilities)
- Edit value directly in the results table
- Multi-window system ... not all request in the same window
- Dump SQL table|database|serveur|request into SQL, XML and CSV files

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 Connector/ODBC project is an ODBC driver for the MySQL database server.
MySQL is a multithreaded, multi-user SQL database management system (DBMS) which has, according to MySQL AB, more than 10 million installations.
MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, which holds the copyright to most of the codebase.
This is similar to the JBoss model and how the Free Software Foundation handles copyright in its projects, and dissimilar to how the Apache project does it, where the software is developed by a public community and the copyright to the codebase is owned by its individual authors.
Enhancements:
- This release fixes a regression in the handling of character data from the server when the server misidentifies it as binary data. (The driver contains a workaround for this server bug that was inadvertantly removed.)

mysqlPostfix is a standalone or mysqlISP managed subsystem for running 1 or 100s of postfix mail servers. mysqlPostfix was developed for very scalable, but simple and cheap anti-virus anti-spam mail-gateway frontend to mysqlSendmail sendmail imap/pop3/webmail final destination servers.

A free white-paper that covers building a (small to very large) scalable and fault redundant mail system with linux, postfix, spamassassin, clamAV and sendmail is soon to be available on openisp.net and will also be noted here.

Prerequisites:

mySQL server and client libs installed and running on same server as the application. You must know the root password. (Paranoids: Check the install script in mainfunc.h)

Use find . -name mysql.h and find / -name libmysqlclient.a to get paths. Edit makefile and mysqlrad.h for these if needed.

If using FreeBSD (or other that needs gmake defines in makefile) make sure that FreeBSD=1 is in makefile at top. You can change useradd/userdel and usermod commands to customize for your system see relevant mysqlPostfix.tConfiguration entries for details.

Must have a running Apache server on the same server with cgi capabilities. Should be SSL enabled if possible (see below for intranet or other just "testing" non-SSL setup.) Typical setup involves user openisp httpd daemon on some random port number like 9023 for non SSL and 8045 for SSL connections. ~openisp should have everything mysqlISP related in it (More on this below.)

Note that MD5 support requires at least glibc2.

Example BASH Install Instructions

(Must edit makefile and use GNU make on FreeBSD builds. Usually gmake)

shell>tar xzf mysqlPostfixN.M.tar.gz
(Where N.M (Ex 1.43) is the latest Major.Minor version available at
openisp.net/mysqlPostfix)
shell>cd mysqlPostfix
shell>export CGIDIR=/apache/cgi-bin/
(or whatever your Apache cgi-bin dir is)
shell>vi local.h
shell>vi makefile
shell>make
(or "# SSL=1 make" if you are using mysql libraries compiled with OpenSSL)
shell>make install
shell>export ISMROOT=/home/joe
(or whatever directory the mysql application project folder/dir is in)
shell>chown mysql data
shell>chmod o+x $ISMROOT
(make sure mysql daemon owner can access the initial data
files. If this fails you need to drop database mysqlpostfix via mysql
command line)
shell>/cgi-bin/mysqlPostfix.cgi Initialize

This will setup application and allow you to login as user "Root" password "wsxedc"

mysqlIPM is a Web-based IP address, router, firewall, and quality of service manager. It includes provisions for MAC hardware addresses, and tftp files for router backup.
In a nutshell mysqlISP assigns (and deploys across network of ISP servers) products to ISP clients (customers). These products consist of one or more sevices that similarly consist of one or more service parameters. End user level, Reseller level, Admin level and Root level record and operation permissions have been built in from the ground up (based on years of ism|2 experience.) Even ISP employees would have a hard time bypassing cgi security measures. The products are deployed for new/mod/del operations via an asynchronous job queue system and read by subsystem servers via mySQL tcp/ip connections (or if local much faster and secure mySQL socket.) Client side subsystem root command line operations done with crontab entries read the master mysqlISP job queue -this is very secure and much better than root permission httpd daemons...shudder. For the PRO ISP all this should be done with a second NIC card on all edge servers making up a private ISP management LAN. But mySQL GRANT command with passwd and user@hostip makes system pretty much secure, except for possible packet sniffers run on non switched hub local -unlikely unless server is hacked. VPN, ssl tunnels etc can be used also for mySQL connections between servers.
unixservice.com commercial:
Non GPL software like unixservice.coms ism|4 (but at least very inexpensive -less than $100/Month- with sitewide license, install, monthly support hours, and yes it is opensource -installed on your server. Support is local to your region NA, SA, Europe etc.) can wrap mysqlISP for a non technical 100% customizable look and feel -skin template sets. ism|4 can also be used to automate billing of ISP clients (ACHDebits, credit card, email, checks, cash etc...electronically, periodically, one-time...etc.) Propietary closed source ISP software companies hate us believe me.
Enhancements:
- VERY IMPORTANT: Some accounting queries require mySQL 4.
- Added accounting invoice generation and payment processing.
- Added special client usage products.
- Added accounting test suite .mysql SQL files.
- Changed tInstance schema (again...sorry) for accounting specs.
- Minor changes in many table pages for improved application use.

Command Executor is an amaroK script which execute an internal command (e.g. stop playing) when reaches that entry. Sometimes it is useful to execute some external commands (e.g. shutdown) when playing reached a certain place (e.g. end of album).

This script does the job. If amaroK starts playing a track from the "Shell Command" album, this script executes the comment tag of the track as a shell command.

You need some prepared audio files, with correctly filled tags. There are three .ogg files enclosed for stop playing, shutdown and hibernate the computer.

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.