______________________________________________________________________
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
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
[文件数据]phpMyAdmin v2.8.1 for Windows_phpmyadmin-2.8.0.1.zip源码PHP项[文件数据]phpMyAdmin v2.8.1 for Windows_phpmyadmin-2.8.0.1.zip源码PHP项 1.适合个人搭建网站项目参考 2.适合学生毕业设计搭建网站参考 3.适合小公司搭建网站项目参考
资源推荐
资源详情
资源评论
收起资源包目录
[文件数据]phpMyAdmin v2.8.1 for Windows_phpmyadmin-2.8.0.1.zip源码PHP项 (595个子文件)
RELEASE-DATE-2.8.0.1 29B
ChangeLog 420KB
CREDITS 173B
docs.css 3KB
print.css 204B
.htaccess 95B
Documentation.html 188KB
translators.html 8KB
favicon.ico 18KB
error.ico 318B
error.ico 318B
INSTALL 183B
functions.js 40KB
tbl_change.js 11KB
querywindow.js 7KB
user_password.js 6KB
tooltip.js 5KB
dom-drag.js 4KB
server_privileges.js 3KB
indexes.js 2KB
keyhandler.js 2KB
LICENSE 18KB
common.lib.php 118KB
server_privileges.php 108KB
display_tbl.lib.php 95KB
belarusian_cyrillic-utf-8.inc.php 95KB
sqlparser.lib.php 92KB
thai-utf-8.inc.php 88KB
bulgarian-utf-8.inc.php 85KB
greek-utf-8.inc.php 85KB
serbian_cyrillic-utf-8.inc.php 81KB
russian-utf-8.inc.php 81KB
georgian-utf-8.inc.php 81KB
ukrainian-utf-8.inc.php 80KB
mongolian-utf-8.inc.php 77KB
hindi-utf-8.inc.php 76KB
arabic-utf-8.inc.php 76KB
japanese-utf-8.inc.php 75KB
persian-utf-8.inc.php 73KB
german-utf-8.inc.php 71KB
german-iso-8859-15.inc.php 71KB
german-iso-8859-1.inc.php 71KB
hebrew-utf-8.inc.php 71KB
croatian-utf-8.inc.php 70KB
croatian-windows-1250.inc.php 70KB
croatian-iso-8859-2.inc.php 70KB
korean-utf-8.inc.php 70KB
afrikaans-utf-8.inc.php 70KB
afrikaans-iso-8859-1.inc.php 70KB
malay-utf-8.inc.php 69KB
malay-iso-8859-1.inc.php 69KB
persian-windows-1256.inc.php 69KB
setup.php 69KB
greek-iso-8859-7.inc.php 69KB
spanish-utf-8.inc.php 69KB
portuguese-utf-8.inc.php 68KB
spanish-iso-8859-15.inc.php 68KB
spanish-iso-8859-1.inc.php 68KB
albanian-utf-8.inc.php 68KB
azerbaijani-utf-8.inc.php 68KB
basque-utf-8.inc.php 68KB
basque-iso-8859-1.inc.php 68KB
portuguese-iso-8859-15.inc.php 68KB
portuguese-iso-8859-1.inc.php 68KB
turkish-utf-8.inc.php 67KB
belarusian_latin-utf-8.inc.php 67KB
brazilian_portuguese-utf-8.inc.php 67KB
french-utf-8.inc.php 67KB
azerbaijani-iso-8859-9.inc.php 67KB
hungarian-utf-8.inc.php 67KB
albanian-iso-8859-1.inc.php 67KB
indonesian-utf-8.inc.php 66KB
indonesian-iso-8859-1.inc.php 66KB
latvian-utf-8.inc.php 66KB
finnish-utf-8.inc.php 66KB
korean-euc-kr.inc.php 66KB
lithuanian-utf-8.inc.php 66KB
dutch-utf-8.inc.php 66KB
brazilian_portuguese-iso-8859-1.inc.php 66KB
dutch-iso-8859-15.inc.php 66KB
dutch-iso-8859-1.inc.php 66KB
bulgarian-windows-1251.inc.php 66KB
bulgarian-koi8-r.inc.php 66KB
galician-utf-8.inc.php 66KB
italian-utf-8.inc.php 66KB
ukrainian-windows-1251.inc.php 66KB
french-iso-8859-15.inc.php 66KB
french-iso-8859-1.inc.php 66KB
italian-iso-8859-15.inc.php 66KB
italian-iso-8859-1.inc.php 66KB
slovenian-utf-8.inc.php 66KB
bosnian-utf-8.inc.php 66KB
russian-cp-866.inc.php 66KB
slovak-utf-8.inc.php 66KB
bosnian-windows-1250.inc.php 65KB
slovenian-windows-1250.inc.php 65KB
slovenian-iso-8859-2.inc.php 65KB
galician-iso-8859-1.inc.php 65KB
romanian-utf-8.inc.php 65KB
romanian-iso-8859-1.inc.php 65KB
共 595 条
- 1
- 2
- 3
- 4
- 5
- 6
资源评论
yxkfw
- 粉丝: 76
- 资源: 2万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功