Free mysql database software for mac

JumpBox for the MySQL Relational Database 1.1.11 is described as an easy to use, flexible and feature-rich databases which is used as an integral component in many JumpBoxes.

This JumpBox includes MySQL 5 along with PHPMyAdmin setup and ready to run. It's a great tool for developing database backed applications and can also be used along with other JumpBoxes if you need to move the database into a separate virtual machine.

Deploying an application as a JumpBox provides a dramatically-reduced path to getting started with the software. Aside from installation benefits it yields other advantages such as portability across computing environments and simplified ongoing maintenance of the application.

This JumpBox is free so there's no risk in trying it out. Download it today and experience for yourself a whole new way of working with server software.

1. Self-contained deployment means easy to move or delete - it won't scatter files all over your operating system.
2. New versions of the JumpBox contain updates to each component in the software stack so there's no patching web servers, application servers, databases, dependencies, etc.
3. A web-based administration console simplifies the management of your application including SSL certs, email relaying, SSH, backups and more.
4. Once you know how to install a JumpBox you can deploy any of 50+ other JumpBoxes and take advantage of a growing library of conveniently-packaged Open Source software.

Navicat for MySQL 8.1.5 brings you an effective solution for MySQL administration and development. This is an all-inclusive mysql front end provides a powerful graphical interface for databases management, development 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 let you converts Access to MySQL, MS SQL to MySQL, Excel to MySQL, synchronizes and backups database in a snap through helpful wizards.

Major Features:

1. Latest MySQL Versions Support: Navicat for MySQL a powerful MySQL Database Server administration and development tool. Highlights of supported features:
   • Support of MySQL versions from 3.21 or above
   • Support of Unicode / Character Set
   • Support of MySQL Events, Views and Stored Procedures creation
   • Support of Triggers
   • Support of Foreign Keys
   • Support of Partition
2. Additional Connection Options
   • Support of SSH Tunnel: Establish a secure SSH session through SSH Tunneling in Navicat. Enjoy a strong authentication and secure encrypted communications between two hosts.
   • Support of HTTP Tunnel: Navicat comes with you HTTP Tunneling while your ISPs do not allow direct connections to their MySQL server but allows establishing HTTP connections. HTTP Tunneling is a method for connecting to a MySQL server that uses the same protocol (http://) and the same port (port 80) as a webserver does.
   • Provide auto-reconnection for MySQL server: With the option "Keepalive Interval", you can keep connection alive with the server by pinging it.
3. Comprehensive Management of MySQL objects
   • Create, edit and drop table's fields, indices, foreign keys and triggers: With Table Designer the basic Navicat for MySQL tool for working with tables, you can create, edit and drop table's fields, indices, foreign keys, and much more.
   • SQL Preview: The SQL Preview area shows you SQL representation of the oracle objects you are creating. This ability allows you to preview SQL before execution.
   • Dump object definition as sql file: Backup object definition and data with ease by dumping as sql file.
   • View Database / Table Structure: Present the database / table definition by printing their structures in Navicat. Understand the respective object structure fully at a glance.
4. Diversified Import and Export Competence
   • Import data from ODBC: You can import data from ODBC after setting up a data source connection. All available tables will be included if connection success. Just simply choose the tables you wish to import or specify a query using Add Query button.
   • Import data from different file formats: XLS, CSV, TXT, DBF and XML: Import Wizard allows you to import data into a table from diverse format. On top of that, you can save your settings as an import profile for setting schedule.
   • Export data to different file formats: XLS, TXT, CSV, DBF and XML: Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.
   • Export data and create records as INSERT statements in sql file: During Data Transfer, you can choose to export data as sql file with record options like complete insert statements / extended insert statements etc.
5. Powerful Data Manipulation Tools
   • Form View: Manipulate the current record with Form View. Enjoy a clear display of field name and its value with focus on current record.
   • Support of Foreign Key Data Selection: With the GUI tool Foreign Key Data Selection, you can locate the foreign key values from the reference table. Stop shifting the view to a master table to look for the available values!
   • Data and Structure Synchronization: Navicat for MySQL allows you to transfer data from one MySQL database to another with detailed analytical process. Likewise, you can compare and modify the table structures. For both Data and Structure Synchronization, the target database can be on the same server as the source database or on another MySQL server.
   • Support of Data Transfer between local / remote MySQL databases: Transfer tables/views/stored procedures/events from one MySQL database to another MySQL database, or to a plain text file.
   • Support of Backup and Restore MySQL databases: Regular backup on database is important to users. Backup/restore all tables and records, views, stored procedures and events for your MySQL database using Navicat. You can also schedule backups between databases.
   • Create Schedule for Backup, Import / Export, Data Transfer, Saved Queries and Data Synchronization: Create a batch job for setting schedule to execute at one or more regular intervals, beginning and ending at a specific date and time. Batch job can be created for Query, Backup, Data Transfer, Data Synchronization, Import and Export.
   • Send notification e-mail and attachment for schedule task: Generate notification e-mails with attach exported files to recipients you specify, connecting them to the latest schedule information. Read directly through your email account on the results returned from a schedule.
6. Powerful Security Management
   • Visual User Manager: Navicat provides users a visual tool for user management. You can easily add, duplicate, delete users, and edit global user privileges, and grant privileges on the selected databases, tables/views, fields and stored procedures/functions.
7. Well-Designed Visual Builder / Editor
   • Visual Query / View Builder: Visual Query / View Builder which is divided into two portions: the upper Graphical View, and the lower Syntax View, allows you to create and edit queries / views visually without knowledge of SQL.
   • Query Editor: It allows you to create and edit SQL text for a query, prepare and execute selected queries.
   • Support of Parameter Query: Set query parameters to add variable values to a query each time you run it.
   • Code-Completion for Query, View, Stored Procedure and Event: Experience a quick way in constructing SQL statements in Query Editor, View, Stored Procedure and Event with the Code-completion feature. Whether you want to select available properties of database objects or SQL keywords, all it takes is a pick from the drop-down list.
8. More great features
   • Virtual Grouping: Have a better organization over objects in Navicat. You can categorize objects into groups with the Virtual Grouping feature. Virtual Grouping can be applied on Connection, Table, View, Stored Procedure, Event, Query, Backup and Schedule.
   • Server Monitor: Select the servers that you want to monitor by checking them in the checklist box of the Server Monitor Window. Click on either Process List, Variables or Status icon to show and/or modify the properties of MySQL servers.
   • SQL Console: To use a command-line interface, you can open SQL Console in Navicat. It provides you an interactive text-based screen to query input and result output from database.
   • Tabbed Windows: Customize your window behaviour style. Navicat supports you of dragging windows in and out of the tabbed windows.

Enhancements:

• Improvements:
• • Improved compatibility to some ODBC drivers for Import Wizard.
• Bug Fixes:
• • Incorrect use of hexadecimal format in MySQL data types other than BLOB in Data Transfer.
  • Data grid was unable to be opened properly when some kind of text were displayed.
  • Removed some internal SQL run by Navicat in Query Viewer.
  • Unable to change the default value of an existing field from NULL to other values in Table Designer.
    

Requirements

• Mac OS X 10.4 Tiger or 10.5 Leopard

Find Database Tables 1.0 is the right solution if you have a bunch of MySQL tables in your database that you aren't sure if you use anymore while finding them can be tough and daunting and you're afraid to delete any because that one obscure script you wrote years ago may still use it. Simply log onto your database sever, select your database, select the folder that has your scripts, and let Find Database Tables do the searching for you!

Major Features:

1. Fast Searching
2. View the table data - make sure if you really want to delete the table or not
3. View the scripts where a table was found
4. Drop unwanted tables right from the application
5. Export the results to a CSV file that can be used in any spreadsheet application
6. Can view table data, scripts, and delete tables while the searching is going on

Sequel Pro 0.9.6 is a handy program for Mac OS X which can work with MySQL databases. With support for browsing and modifying tables with 100,000+ rows, and databases with more than 100 tables. Sequel Pro is a fork of Version 0.7 of CocoaMySQL.

MySQL Connector/ODBC (with MyODBC as acronym) allows you to connect to a MySQL database server using the ODBC database API on all Microsoft Windows and most Unix platforms, including through such applications and programming environments such as Microsoft.

Main features:
Standards compliant:
- The production-ready version of Connector/ODBC is compliant with the ODBC 2.50 specification, Level 0 (with some Level 1 and 2 features). The stable version, is compliant with the ODBC 3.51 specification, Level 1 (complete Core API and Level 2 features).
Cross-platform:
- Connector/ODBC is available for Microsoft Windows, as well as many Unix systems (including Linux, Sun Solaris, HP-UX, IBM AIX, and Mac OS X).

Enhancements
Functionality added or changed:
- Added FLAG_NO_BINARY_RESULT connection option to always handle binary function results as character data. (Bug #29402)
Bugs fixed:
- Some catalog functions used fixed-sized buffers for handling arguments that could be overrun, and misinterpreted some arguments as patterns when they should be treated as identifiers. (Bug #36275)
- SQLDriverConnect() returned SQL_ERROR when the user cancelled the dialog box instead of SQL_NO_DATA. (Bug #36293)
- System DSN lookup (using ODBC_BOTH_DSN) fails on Windows XP. (Bug #36203)
- SQLProcedures() followed by SQLFreeStmt() crashes (Bug #36069)
- ADO adUseServer cursor is lost after updating adLongVarWChar field (Bug #26950)
- SQL_TYPE_TIMESTAMP and SQL_TYPE_TIME parameters were incorrectly included when parameters were expanded. (Bug #37342)
- DSN-less connection prompting cannot lookup driver entry (Bug #37254)

Exero CMS is a free and open source content management system that runs on PHP, Mod_Rewrite and MySQL Database.
Exero CMS has an easy to use AdminCP that allows the admin to create/edit or delete Pages, Blocks and Items(links,images,polls) and Modules.

System requirements:
-
-

Enhancements
- Fixed a small security issue with the $theme variable in the templates.
- Fixed issues with the SEO URLs.