MySQL

All Datalian hosting account includes MySQL databases.

server:70.84.0.116
port: 3306
database name: created by you in the control panel
username: set by you in the control panel
password: set by you in the control panel

We Use MySQL Front to edit our MySQL databases.
http://www.mysql-front.com/

About MySQL Front

MySQL-Front is a graphical front for the MySQL database. Because it is a "real" application, it can offer a more refined user-interface than is possible with systems built on PHP and HTML. Response is immediate, there is no delay of reloading HTML-pages.

An application has total control of the graphic display, information can be presented as clearly as possible. MySQL-Front presents data in a table with resizable column-widths and sorting capability.

If your provider allows it, MySQL-Front can make direct contact with the database. Otherwise only one small script is to be installed on the publishing website. Login-information and passwords are stored on the harddisk, there is no need to log in on different webinterfaces.

MySQL-Front presents an uniform front-end for every database in all current projects. In practice one can work with a database of one's choice after only a few clicks.

Defining and managing the database-structure, importing data, editing data is now simple with this nice program. For designers with only a basic grasp of databases, this program is the way to go to make you independent of SQL gurus.

The program makes working with MySQL easy without hiding the language from the user. An editor is built-in, so even working with SQL-commands or scripts is made convenient.

Ease of Use:

· Windows-conformant use of all elements
· Clearly structured menu prompts
· Efficient use either via keyboard or with mouse only
· Data structure depiction same as in Windows Explorer
· Interactive dialogs to edit data structures
· Data depiction with data grid same as in MS Excel
· Detailed manual
· Very fast

High-Degree of Compatibility:

· Supports MySQL databases starting with version 3.23
· Supports all commonly used MySQL table and column types
· If desired, use of the MySQL DLL to access the database and thus compatible with future versions
· Runs on any version of Windows (starting with 95 / NT 4.0) system
· Use of numerous Windows API functions to ensure compatibility with future Windows versions
· Full Drag&Drop and Copy&Paste support
· If the ISP prohibits external access to the database, use a PHP tunnel to still access the database

Individual Configuration:

· Language settings (more than 25 languages available, unicode supported)
· Design settings
· Various options to configure the database linkage
· Numerous program use settings
· Syntax highlighting

Standard Database Editing:

· Create, change, and delete databases, tables, indices, fields and foreign keys
· Create, change, and delete data (incl. Memo / BLOB fields)
· Display graphics in BLOB fields (BMP, GIF, JPEG, and PNG)
· Create BLOB fields using a HEX editor
· Unicode support

Data / Data Structure Import:

· SQL File
· Text File (CSV format)
· MS Access File
· ODBC (Open Database Connector)

Data / Data Structure Export:

· SQL File
· Text File (CSV format)
· HTML file
· XML file
· Other MySQL database

Enhanced Database Manipulations:

· Easy Synchronisation between two tables / databases
· Fast Search&Replace inside whole table(s) / database(s)

Database Administration:

· Overview and ending of single processes and the entiered server
· Detailed server status overview 
· Configuration of server variables
· Highly individualized user rights administration
· Security settings on host level
· Table maintenance options (check, analyze, optimize, repair)

Efficient Troubleshooting:

· Distinct filtering and data sorting functions
· Logging of all SQL queries sent to the database
· Display of source code of tables and users
· Printout of data structure and data
· Management of user-defined SQL scripts
· Syntax highlighting for easy to use layouts