phpMyAdmin can help to access MySQL

| No Comments | No TrackBacks

I use phpMyAdmin when I need to access MySQL database directly.
The phpMyAdmin application requires not only the MySQL server, but also PHP and a Web server to be installed. This application is commonly found in a virtual hsoting envirnment through an Internet Service Provider, as it allows the user complete access to only their own database.

1and1 and Dreamhost both have phpMyAdmin.

The main features of phpMyAdmin:
* browse and drop databases, tables, views, fields and indexes
* create, copy, drop, rename and alter databases, tables, fields and indexes
* maintenance server, databases and tables, with proposals on server configuration
* execute, edit and bookmark any SQL-statement, even batch-queries
* load text files into tables
* create1 and read dumps of tables
* export1 data to various formats: CSV, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel and LATEX formats
* administer multiple servers
* manage MySQL users and privileges
* check referential integrity in MyISAM tables
* using Query-by-example (QBE), create complex queries automatically connecting required tables
* create PDF graphics of your Database layout
* search globally in a database or a subset of it
* transform stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
* support InnoDB tables and foreign keys
* support mysqli, the improved MySQL extension
* communicate in 54 different languages


Related Articles

No TrackBacks

TrackBack URL: http://www.yinfor.com/mtcgi/mt-t-1010.cgi/2127

Leave a comment

About this Entry

This page contains a single entry by David Yin published on April 15, 2008 1:42 AM.

Types of Table Relationships was the previous entry in this blog.

Firefox Upgrade to 2.0.0.14 is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

OpenID accepted here Learn more about OpenID
Powered by Movable Type 4.21-en

Online Tools