Free mysql to access software for linux

MySQL Abstractor package contains PHP classes that implements a MySQL database abstraction layer.

It provides several classes. There is one for establishing connections and executing SQL queries, another for composing and executing SELECT, INSERT, UPDATE and DELETE queries from a list of parameters, and a wrapper class to simplify the usage of the other two classes.

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.

A MySQL Storage Engine for AWS S3 project is a plugin storage engine that allows MySQL to access Amazon Web Services Simple Storage Service (AWS S3) buckets and items.
You need a MySQL source tree, and you need to have it built.
Figure out where the source tree is.
In my case its /home/mark/mysql/mysql-5.1-arch
Figure out where the target install tree is.
In my case its /home/mark/mysql/builds/example
Figure out where the MySQL build puts storage engine plugins.
Its probably in lib/mysql under the install tree
Or its /usr/lib/mysql
Or its /usr/local/lib/mysql
For me its /home/mark/mysql/builds/example/lib/mysql
Then run:
./config/bootstrap
./configure --with-mysql=/path/to/mysql-source --libdir=/path/to/mysql-plugins
make && make install
You can optionally copy the "src" directory here into storage/ in the
MySQL server source, rebuild MySQL, and things should compile.
Next, you should probably install the S3 command line tools.
They depend on you having Python.
Get them at http://www.hanzoarchives.com/development-projects/s3-tools/
If you dont have one yet, you need an Amazon AWS account, and then
request that they enable S3. Go to http://amazonaws.com/ to do that.
You will need to get your "AWS Access Key Identifiers".
Assume they are
FV8CY5793BC7CY32YOSN
W9oQxQNJizGgjxNc82giE9/ipefQW19tuO2xpC9G
(I just made those up with a random number generator.)
Put this in your .bashrc file
AWS_ACCESS_KEY_ID=FV8CY5793BC7CY32YOSN
AWS_ACCESS_KEY_SECRET=W9oQxQNJizGgjxNc82giE9/ipefQW19tuO2xpC9G
export AWS_ACCESS_KEY_ID AWS_ACCESS_KEY_SECRET
This isnt used by the storage engine, but it makes using the s3 command
line tools easier.
Use s3mkbucket to create a bucket. Remember that buckets are in a
global namespace, and there are advantages to having them look lik a
domain name. I suggest you snap up "s3.example.com", where
"example.com" is your own domain name.
s3mkbucket s3.example.com
s3put -k solfege/Do -s "a deer, a female deer" s3.example.com
s3put -k solfege/Re -s "a drop of golden sun" s3.example.com
s3put -k solfege/Mi -s "a name I call myself" s3.example.com
s3put -k solfege/Fa -s "a long long way to run" s3.example.com
s3put -k solfege/So -s "a needle pulling thread" s3.example.com
s3put -k solfege/La -s "a note to follow So" s3.example.com
s3put -k solfege/Ti -s "a drink with jam and bread" s3.example.com
Then at the mysql> prompt
create table s3notes (s3id varchar(255) not null primary key, s3val blob)
engine=AWSS3
connection=awss3 s3.example.com FV8CY5793BC7CY32YOSN W9oQxQNJizGgjxNc82giE9/ipefQW19tuO2xpC9G;
select * from s3notes where s3id=solfege/Re;
insert into s3notes (s3id, s3val) values (color/Red, ff 00 00);
select * from s3notes where s3id=color/Red;
delete from s3notes where s3id=color/Red;
You can name the table anything you want, but the fields must be named s3id and s3val, and s3id must be the primary key.
Enhancements:
- More flexible schema, CREATE SERVER, and SELECT without WHERE are supported.

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.

MySQL PHP to PostgreSQL is an application that takes a php page that uses mysql calls and changes them into PostgreSQL calls.
This allows any website (if it converts properly) that was written in PHP for MySQL to run as a website written to run on PostgreSQL.
- Step 1: Download and uncompress
To uncompress simply type: tar xvzf mysqlphp2postgres.tar.gz
If youre on a non-GNU system you might have to type: gzip -dc mysqlphp2postgres.tar.gz | tar xvf -
- Step 2: Compile
To compile simply type: make
If youre on a non-GNU system youll have to edit the make file to change the compiler to cc instead of gcc
- Step 3: Install
Type: make install
This will simply copy the binary file to /usr/local/bin/
- Step 4: Convert
Type: mysqlphp2postgres inputfile.php outputfile.php
The input file is the php page that uses mysql. The outfile is the page you want to create. You will probably need to tell mysqlphp2postgres the name of the postgreSQL database since mysql_select_db doesnt translate. You can do this by using a -d switch. So if, for example, the database youre connecting to is called blah, you could type: mysqlphp2postgres -d blah inputfile.php outputfile.php
Problems:
I have had the following problems from using this program:
MySQL has a lot more functions in PHP than PostgreSQL that do more things. I havent had a problem with any unsupported functions in my programs, but someone probably will. If you want to help write code for this to support those functions (if thats even possible) feel free to help.
Enhancements:
- Fixed some stuff.
- Cleaned up some code.
- This program now produces code optomized for PHP 4.1.0 and above.

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.

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.