______________________________________________________________________
Top - Requirements - Introduction - Installation - Configuration
Transformations - FAQ - Developers - Credits - Translators
______________________________________________________________________
phpMyAdmin 2.7.0-pl2 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.177.2.3 2005/12/27 13:55:17 lem9 Exp $
Requirements
* PHP
+ You need PHP 4.1.0 or newer, with session support (*)
+ If you want to display inline thumbnails of JPEGs with the original
aspect ratio, you also need GD2 support in PHP
+ Starting with phpMyAdmin 2.6.1, MIME-based transformations that use
an external program need PHP 4.3.0 or newer
* 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:
* create and drop databases
* create, copy, drop, rename and alter tables
* do table maintenance
* delete, edit and add fields
* execute any SQL-statement, even batch-queries
* manage keys on fields
* load text files into tables
* create (*) and read dumps of tables
* export (*) data to CSV, XML 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 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 or ...
* 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 for suggestions.
3. Create the file config.inc.php in your favorite editor and fill in th ere values for host, user, password and authentication mode to fit your
environment. Look at 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 config auth_type, it is suggested that you prote ct 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.
Linked-tables infrastructure
For a whole set of new features (bookmarks, comments, SQL-history, PDF-ge neration, field contents transformation, etc.) you need to create a set of special tables. Those tables can be located in your own database, or in a central database for a multi-user installation (this database would then be accessed by the controluser, so no other user should have right s to it).
Please look at your scripts/ directory, where you should find a file call ed create_tables.sql. (If you are using a Windows server, pay special at tention to FAQ 1.23).
If your MySQL server's version is 4.1.2 or later, please use create_table s_mysql_4_1_2+.sql instead, for a new installation.
If you already had this infrastructure and upgraded to MySQL 4.1.2 or lat er, please use upgrade_tables_mysql_4_1_2+.sql.
You can use your phpMyAdmin to create the tables for you. Please be aware that you may need special (administrator) privileges to create the data base and tables, and that the script may need some tuning, depending on the database name.
After having imported the create_tables.sql file, you should specify the table names in your config.inc.php file. The directives used for that ca n be found in the Configuration section. You will also need to have a co ntroluser with the proper rights to those tables (see section Using auth entication modes below).
Upgrading from an older version
Just copy config.inc.php from previous installation into a newly unpacked one. If your previous phpMyAdmin version was 2.3.0 or older, some tweak ing may be required because, as of 2.7.0, using those old config files i s no longer supported.
Using authentication modes
* HTTP and cookie authentication modes are recommended in a multi-user environment where you want to give users access to their own database
and don't want them to play around with others.
Nevertheless be aware that MS Internet Explorer seems to be really buggy
about cookies, at least till version 6. And PHP 4.1.1 is also a bit
buggy in this area!
Even in a single-user environment, you might prefer to use HTTP or
cookie mode so that your user/password pair are not in clear in the
configuration file.
* HTTP and cookie authentication modes are more secure: the MySQL login information does not need to be set in the phpMyAdmin configuration
file (except possibly for the controluser).
However, keep in mind that the password travels in plain text, unless
you are using the HTTPS protocol.
In cookie mode, the password is stored, encrypted with the blowfish
algorithm, in a temporary cookie.
* Note: starting with phpMyAdmin 2.6.1, configuring the controluser to enable HTTP and cookie authen
没有合适的资源?快使用搜索试试~ 我知道了~
[文件数据]phpMyAdmin v2.7.0-pl2 for Windows_phpmyadmin.rar
共585个文件
php:309个
png:225个
sh:13个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 39 浏览量
2024-04-20
00:10:24
上传
评论
收藏 3.41MB RAR 举报
温馨提示
【项目资源】:包含前端、后端、移动开发、操作系统、人工智能、物联网、信息化管理、数据库、硬件开发、大数据、课程资源、音视频、网站开发等各种技术项目的源码。包括STM32、ESP8266、PHP、QT、Linux、iOS、C++、Java、python、web、C#、EDA、proteus、RTOS等项目的源码。【项目质量】:所有源码都经过严格测试,可以直接运行。功能在确认正常工作后才上传。【适用人群】:适用于希望学习不同技术领域的小白或进阶学习者。可作为毕设项目、课程设计、大作业、工程实训或初期项目立项。【附加价值】:项目具有较高的学习借鉴价值,也可直接拿来修改复刻。对于有一定基础或热衷于研究的人来说,可以在这些基础代码上进行修改和扩展,实现其他功能。【沟通交流】:有任何使用上的问题,欢迎随时与博主沟通,博主会及时解答。鼓励下载和使用,并欢迎大家互相学习,共同进步。
资源推荐
资源详情
资源评论
收起资源包目录
[文件数据]phpMyAdmin v2.7.0-pl2 for Windows_phpmyadmin.rar (585个子文件)
RELEASE-DATE-2.7.0-pl2 29B
ChangeLog 378KB
CREDITS 173B
docs.css 3KB
print.css 185B
Documentation.html 177KB
translators.html 8KB
favicon.ico 18KB
error.ico 318B
error.ico 318B
INSTALL 183B
functions.js 40KB
tbl_change.js 11KB
querywindow.js 6KB
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 113KB
server_privileges.php 106KB
display_tbl.lib.php 95KB
belarusian_cyrillic-utf-8.inc.php 92KB
sqlparser.lib.php 91KB
thai-utf-8.inc.php 86KB
bulgarian-utf-8.inc.php 83KB
greek-utf-8.inc.php 83KB
serbian_cyrillic-utf-8.inc.php 79KB
russian-utf-8.inc.php 79KB
georgian-utf-8.inc.php 79KB
ukrainian-utf-8.inc.php 78KB
mongolian-utf-8.inc.php 75KB
hindi-utf-8.inc.php 75KB
arabic-utf-8.inc.php 74KB
japanese-utf-8.inc.php 72KB
persian-utf-8.inc.php 71KB
german-utf-8.inc.php 69KB
hebrew-utf-8.inc.php 69KB
german-iso-8859-15.inc.php 68KB
german-iso-8859-1.inc.php 68KB
croatian-utf-8.inc.php 68KB
croatian-windows-1250.inc.php 68KB
croatian-iso-8859-2.inc.php 68KB
korean-utf-8.inc.php 68KB
afrikaans-utf-8.inc.php 68KB
afrikaans-iso-8859-1.inc.php 68KB
malay-utf-8.inc.php 67KB
malay-iso-8859-1.inc.php 67KB
persian-windows-1256.inc.php 67KB
spanish-utf-8.inc.php 67KB
greek-iso-8859-7.inc.php 67KB
portuguese-utf-8.inc.php 66KB
spanish-iso-8859-15.inc.php 66KB
spanish-iso-8859-1.inc.php 66KB
azerbaijani-utf-8.inc.php 66KB
albanian-utf-8.inc.php 66KB
basque-utf-8.inc.php 66KB
basque-iso-8859-1.inc.php 66KB
portuguese-iso-8859-15.inc.php 66KB
portuguese-iso-8859-1.inc.php 66KB
galician-utf-8.inc.php 66KB
belarusian_latin-utf-8.inc.php 66KB
french-utf-8.inc.php 65KB
turkish-utf-8.inc.php 65KB
brazilian_portuguese-utf-8.inc.php 65KB
galician-iso-8859-1.inc.php 65KB
azerbaijani-iso-8859-9.inc.php 65KB
hungarian-utf-8.inc.php 65KB
finnish-utf-8.inc.php 65KB
albanian-iso-8859-1.inc.php 65KB
latvian-utf-8.inc.php 65KB
indonesian-utf-8.inc.php 65KB
lithuanian-utf-8.inc.php 65KB
indonesian-iso-8859-1.inc.php 65KB
korean-euc-kr.inc.php 65KB
dutch-utf-8.inc.php 64KB
brazilian_portuguese-iso-8859-1.inc.php 64KB
dutch-iso-8859-15.inc.php 64KB
dutch-iso-8859-1.inc.php 64KB
bulgarian-windows-1251.inc.php 64KB
bulgarian-koi8-r.inc.php 64KB
italian-utf-8.inc.php 64KB
french-iso-8859-15.inc.php 64KB
french-iso-8859-1.inc.php 64KB
italian-iso-8859-15.inc.php 64KB
italian-iso-8859-1.inc.php 64KB
polish-utf-8.inc.php 64KB
ukrainian-windows-1251.inc.php 64KB
slovenian-utf-8.inc.php 64KB
bosnian-utf-8.inc.php 64KB
slovak-utf-8.inc.php 64KB
russian-cp-866.inc.php 64KB
bosnian-windows-1250.inc.php 63KB
slovenian-windows-1250.inc.php 63KB
romanian-utf-8.inc.php 63KB
slovenian-iso-8859-2.inc.php 63KB
romanian-iso-8859-1.inc.php 63KB
catalan-utf-8.inc.php 63KB
共 585 条
- 1
- 2
- 3
- 4
- 5
- 6
资源评论
CrMylive.
- 粉丝: 1w+
- 资源: 4万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功