* Top
* Requirements
* Introduction
* Installation
* Setup script
* Configuration
* Transformations
* FAQ
* Developers
* Credits
* Translators
* Glossary
phpMyAdmin 2.9.2 Documentation
* phpMyAdmin homepage
* SourceForge phpMyAdmin project page
* Official phpMyAdmin wiki
* Local documents:
+ Version history: ChangeLog
+ General notes: README
+ License: LICENSE
* Documentation version: $Id: Documentation.html 9841 2007-01-16 17:32:33Z
lem9 $
Requirements
* PHP
+ You need PHP 4.1.0 or newer, with session support (see FAQ 1.31)
+ 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 the
"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.
* Web browser with cookies enabled.
Introduction
phpMyAdmin can manage a whole MySQL server (needs a super-user) as well as 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:
* 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
* create^1 and read dumps of tables
* export^1 data to various formats: CSV, XML, PDF, ISO/IEC 26300 -
OpenDocument Text and Spreadsheet, Word, Excel and L^AT[E]X 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 (see FAQ 3.6)
* support mysqli, the improved MySQL extension (see FAQ 1.17)
* communicate in 50 different languages
A word about users:
Many people have difficulty understanding the concept of user management with
regards to phpMyAdmin. When a user logs in to phpMyAdmin, that username and
password are passed directly to MySQL. phpMyAdmin does no account management on
its own (other than allowing one to manipulate the MySQL user account
information); all users must be valid MySQL users.
^1) phpMyAdmin can compress (Zip, GZip -RFC 1952- or Bzip2 formats) dumps and
CSV exports if you use PHP with Zlib support (--with-zlib) and/or Bzip2 support
(--with-bz2). Proper support may also need changes in php.ini.
Installation
1. Quick Install
2. Setup script usage
3. Linked-tables infrastructure
4. Upgrading from an older version
5. Using authentication modes
phpMyAdmin does not apply any special security methods to the MySQL database
server. It is still the system administrator's job to grant permissions on the
MySQL databases properly. phpMyAdmin's "Privileges" page can be used for this.
Warning for Mac users:
if you are on a Mac OS version before OS X, StuffIt unstuffs with Mac formats.
So you'll have to resave as in BBEdit to Unix style ALL phpMyAdmin scripts
before uploading them to your server, as PHP seems not to like Mac-style 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 running
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. Now you must configure your installation. There are two methods that can be
used. Traditionally, users have hand-edited a copy of config.inc.php, but
now a wizard-style setup script is provided for those who prefer a
graphical installation. Creating a config.inc.php is still a quick way to
get started and needed for some advanced features.
+ To manually create the file, simply use your text editor to create the
file config.inc.php (you can copy config.sample.inc.php to get minimal
configuration file) in the main (top-level) phpMyAdmin directory (the
one that contains index.php). phpMyAdmin first loads libraries/
config.default.php and then overrides those values with anything found
in config.inc.php. If the default value is okay for a particular
setting, there is no need to include it in config.inc.php. You'll need
a few directives to get going, a simple configuration may look like
this:
<?php
$cfg['blowfish_secret'] = 'ba17c1ec07d65003'; // use here a value of your choice
$i=0;
$i++;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
?>
Or, if you prefer to not be prompted every time you log in:
<?php
$i=0;
$i++;
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'cbb74bc'; // use here your password
?>
For a full explanation of possible configuration values, see the
Configuration Section of this document.
+ Instead of manually editing config.inc.php, you can use the Setup
Script. First you must manually create a folder config in the
phpMyAdmin directory. This is a security measure. On a Linux/Unix
system you can use the following commands:
cd phpMyAdmin
mkdir config # create directory for saving
chmod o+rw config # give it world writable permissions
And to edit an existing configuration, copy it over first:
cp config.inc.php config/ # copy current configuration for editing
chmod o+w config/config.inc.php # give it world writable permissions
On other platforms, simply create the folder and ensure that your web
server has read and write access to it. FAQ 1.26 can help with this.
Next, open scripts/setup.php in your browser. Note that changes are not
saved to disk until explicitly choose Save from the Configuration area
of the screen. Normally the script saves the new config.inc.php to the
config/ directory, but if the webserver does not have the proper
permissions you may see the error "Cannot load or save configuration."
Ensure that the config/ directory exists and has the proper permissions
- or use the Download link to save the config file locally and upload
(via FTP or some similar means) to the proper location.
Once the file has been saved, it must be moved out of the config/
directory and the permissions must be reset, again as a security
measure:
mv config/config.inc.php . # move file to current directory
chmod o-rw config.inc.php # remove world read and write permissions
Now the file is ready to be used. You can choose to review or edit the
file with your favorite editor, if you prefer to set s
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
【项目资源】:包含前端、后端、移动开发、操作系统、人工智能、物联网、信息化管理、数据库、硬件开发、大数据、课程资源、音视频、网站开发等各种技术项目的源码。包括STM32、ESP8266、PHP、QT、Linux、iOS、C++、Java、python、web、C#、EDA、proteus、RTOS等项目的源码。【项目质量】:所有源码都经过严格测试,可以直接运行。功能在确认正常工作后才上传。【适用人群】:适用于希望学习不同技术领域的小白或进阶学习者。可作为毕设项目、课程设计、大作业、工程实训或初期项目立项。【附加价值】:项目具有较高的学习借鉴价值,也可直接拿来修改复刻。对于有一定基础或热衷于研究的人来说,可以在这些基础代码上进行修改和扩展,实现其他功能。【沟通交流】:有任何使用上的问题,欢迎随时与博主沟通,博主会及时解答。鼓励下载和使用,并欢迎大家互相学习,共同进步。
资源推荐
资源详情
资源评论
收起资源包目录
[文件数据]phpMyAdmin v2.9.2 For Linux_phpmyadmin2codepub.rar (604个子文件)
RELEASE-DATE-2.9.2 29B
ChangeLog 201KB
phpMyAdmin-http.conf 227B
CREDITS 169B
docs.css 4KB
print.css 1KB
.htaccess 118B
Documentation.html 208KB
translators.html 8KB
favicon.ico 18KB
error.ico 318B
error.ico 318B
INSTALL 179B
functions.js 40KB
tbl_change.js 11KB
querywindow.js 10KB
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 122KB
server_privileges.php 110KB
display_tbl.lib.php 101KB
belarusian_cyrillic-utf-8.inc.php 97KB
sqlparser.lib.php 92KB
thai-utf-8.inc.php 89KB
russian-utf-8.inc.php 88KB
bulgarian-utf-8.inc.php 87KB
greek-utf-8.inc.php 86KB
serbian_cyrillic-utf-8.inc.php 82KB
georgian-utf-8.inc.php 82KB
ukrainian-utf-8.inc.php 81KB
mongolian-utf-8.inc.php 78KB
hindi-utf-8.inc.php 78KB
arabic-utf-8.inc.php 77KB
japanese-utf-8.inc.php 76KB
persian-utf-8.inc.php 75KB
hebrew-utf-8.inc.php 72KB
korean-utf-8.inc.php 71KB
setup.php 71KB
afrikaans-utf-8.inc.php 71KB
afrikaans-iso-8859-1.inc.php 71KB
malay-utf-8.inc.php 71KB
malay-iso-8859-1.inc.php 71KB
persian-windows-1256.inc.php 71KB
greek-iso-8859-7.inc.php 70KB
spanish-utf-8.inc.php 70KB
portuguese-utf-8.inc.php 70KB
albanian-utf-8.inc.php 69KB
azerbaijani-utf-8.inc.php 69KB
spanish-iso-8859-15.inc.php 69KB
spanish-iso-8859-1.inc.php 69KB
basque-utf-8.inc.php 69KB
basque-iso-8859-1.inc.php 69KB
portuguese-iso-8859-15.inc.php 69KB
portuguese-iso-8859-1.inc.php 69KB
german-utf-8.inc.php 69KB
belarusian_latin-utf-8.inc.php 69KB
french-utf-8.inc.php 68KB
azerbaijani-iso-8859-9.inc.php 68KB
hungarian-utf-8.inc.php 68KB
german-iso-8859-15.inc.php 68KB
german-iso-8859-1.inc.php 68KB
albanian-iso-8859-1.inc.php 68KB
indonesian-utf-8.inc.php 68KB
indonesian-iso-8859-1.inc.php 68KB
korean-euc-kr.inc.php 68KB
latvian-utf-8.inc.php 68KB
dutch-utf-8.inc.php 68KB
lithuanian-utf-8.inc.php 68KB
dutch-iso-8859-15.inc.php 68KB
dutch-iso-8859-1.inc.php 68KB
turkish-utf-8.inc.php 68KB
ukrainian-windows-1251.inc.php 67KB
brazilian_portuguese-utf-8.inc.php 67KB
galician-utf-8.inc.php 67KB
italian-utf-8.inc.php 67KB
slovenian-utf-8.inc.php 67KB
bosnian-utf-8.inc.php 67KB
bulgarian-windows-1251.inc.php 67KB
bulgarian-koi8-r.inc.php 67KB
french-iso-8859-15.inc.php 67KB
french-iso-8859-1.inc.php 67KB
italian-iso-8859-15.inc.php 67KB
italian-iso-8859-1.inc.php 67KB
finnish-utf-8.inc.php 67KB
bosnian-windows-1250.inc.php 67KB
slovenian-windows-1250.inc.php 67KB
slovenian-iso-8859-2.inc.php 67KB
romanian-utf-8.inc.php 67KB
romanian-iso-8859-1.inc.php 67KB
slovak-utf-8.inc.php 67KB
lithuanian-windows-1257.inc.php 67KB
galician-iso-8859-1.inc.php 66KB
latvian-windows-1257.inc.php 66KB
catalan-utf-8.inc.php 66KB
thai-tis-620.inc.php 66KB
共 604 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
心梓知识
- 粉丝: 6562
- 资源: 3万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功