文件数据phpMyAdmin v2.8.1 For Linux-phpmyadmin2801.rar

______________________________________________________________________ Top - Requirements - Introduction - Installation - Setup script - Configuration Transformations - FAQ - Developers - Credits - Translators ______________________________________________________________________ phpMyAdmin 2.8.0.1 Documentation * SourceForge phpMyAdmin project page [ http://www.phpmyadmin.net/ ] * Local documents: + Version history: ChangeLog + General notes: README + License: LICENSE * Documentation version: $Id: Documentation.html,v 2.205.2.11.2.5 2006/ 03/08 17:25:27 lem9 Exp $ Requirements * PHP + You need PHP 4.1.0 or newer, with session support (*) + You need GD2 support in PHP to display inline thumbnails of JPEGs ("image/jpeg: inline") with their original aspect ratio + You need PHP 4.3.0 or newer to use the "text/plain: external" MIME-based transformation * MySQL 3.23.32 or newer (details); * Not really a requirement but a strong suggestion: if you are using th e "cookie" authentication method, having the mcrypt PHP extension on your web server accelerates not only the login phase but every other action that you do in phpMyAdmin. * a web-browser (doh!). Introduction phpMyAdmin can manage a whole MySQL server (needs a super-user) as well a s a single database. To accomplish the latter you'll need a properly set up MySQL user who can read/write only the desired database. It's up to you to look up the appropriate part in the MySQL manual. Currently phpMyAdmin can: * easily browse through databases and tables * create, copy, rename, alter and drop databases * create, copy, rename, alter and drop tables * do table maintenance * add, edit and drop fields * execute any SQL-statement, even multiple queries * create, alter and drop indexes * load text files into tables * create (*) and read dumps of tables or databases * export (*) data to SQL, CSV, XML, Word, Excel, PDF and Latex formats * administer multiple servers * manage MySQL users and privileges * check server settings and runtime information with configuration hint s * check referential integrity in MyISAM tables * using Query-by-example (QBE), create complex queries automatically co nnecting 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 funct ions, like displaying BLOB-data as image or download-link * support InnoDB tables and foreign keys (see FAQ 3.6) * support mysqli, the improved MySQL extension (see FAQ 1.17) * communicate in 50 different languages (*) phpMyAdmin can compress (Zip, GZip -RFC 1952- or Bzip2 formats) dump s and CSV exports if you use PHP4 >= 4.0.4 with Zlib support (--with-zli b) and/or Bzip2 support (--with-bz2). Installation NOTE: phpMyAdmin does not apply any special security methods to the MySQL database server. It is still the system administrator's job to grant pe rmissions on the MySQL databases properly. phpMyAdmin's "Privileges" pag e can be used for this. Warning for Mac users:if you are on a MacOS version before OS X, StuffIt unstuffs with Mac formats. So you'll have to resave as in BBEdit to Unix style ALL phpMyAdmin script s before uploading them to your server, as PHP seems not to like Mac-sty le end of lines character ("\r"). Quick Install 1. Untar or unzip the distribution (be sure to unzip the subdirectories) : tar -xzvf phpMyAdmin_x.x.x.tar.gz in your webserver's document root. If you don't have direct access to your document root, put the files in a directory on your local machine, and, after step 3, transfer the directory on your web server using, for example, ftp. 2. Ensure that all the scripts have the appropriate owner (if PHP is run ning in safe mode, having some scripts with an owner different from the owner of other scripts will be a problem). See FAQ 4.2 and FAQ 1.26 for suggestions. 3. Create the file config.inc.php in the main (top-level) directory (the one that contains index.php). You can use setup script provided in distribution (scripts/setup.php) to create basics of config file. See Setup chapter for details. If you don't like setup or want to fine tune resulting configuration, open (or create in case of starting from scratch) config.inc.php in your favorite editor and fill in there values for host, user, password and authentication mode to fit your environment. Look at libraries/config.default.php how these fields should be defined. Here, "host" means the MySQL server. Have a look at Configuration section for an explanation of all values. Please also read the remaining of this Installation section for information about authentication modes and the linked-tables infrastructure. 4. If you are using the auth_type configuration directive, it is suggest ed that you protect the phpMyAdmin installation directory, for example with HTTP–AUTH in a .htaccess file. See the multi–user sub–section of this FAQ for additional information, especially FAQ 4.4. 5. Open the file <www.your-host.com>/<your-install-dir>/index.php in you r browser. phpMyAdmin should now display a welcome screen and your databases, or a login dialog if using HTTP or cookie authentication mode. 6. You should deny access to the libraries subfolder in your webserver c onfiguration. For Apache you can use supplied .htaccess file in that folder, for other webservers, you should configure this yourself. Such configuration prevents from possible path exposure and cross side scripting vulnerabilities that might happen to be found in that code. Setup script usage Since 2.8.0 phpMyAdmin comes with a setup script that can help you with c reating configuration. This script is located in scripts folder: scripts /setup.php. Its usage is quite simple. You follow the dialogs and this s cript prepares in memory the configuration directives. You then have two choices for saving the configuration file: 1. Download it to your local workstation, then upload (for example with ftp) to your main phpMyAdmin directory. In this case, you don't have to prepare a special config directory, so no further actions are necessary. 2. Save the file to your webserver into config directory. For saving file on webserver, or loading previous configuration you have to create config directory in phpMyAdmin's top level directory and make it writable to web server. For loading previous configuration, place it there (and make sure it has write permissions for webserver). On a Linux /UNIX server you can use the following commands: cd phpMyAdmin mkdir config # create directory for saving chmod o+rw config # give it world writable permissions # if you want to edit existing configuration: cp config.inc.php config/ # copy current configuration chmod o+w config/config.inc.php # give it world writable permissions On a Windows system, create a config in the main phpMyAdmin directory and ensure that your web server has read/write access to it. FAQ 1.26 can h elp you about this. If you already have an existing config.inc.php in yo ur main directory, copy it to the newly created config directory. Then you can open scripts/setup.php in your browser and perform setup. Af ter saving your configuration move generated configuration to top level directory and delete created co