phpMyAdmin 3.2.4 Documentation
* Top
* Requirements
* Introduction
* Installation
* Setup script
* Configuration
* Transformations
* FAQ
* Developers
* Copyright
* Credits
* Translators
* Glossary
* phpMyAdmin homepage
* SourceForge phpMyAdmin project page
* Official phpMyAdmin wiki
* Local documents:
+ Version history: ChangeLog
+ License: LICENSE
* Documentation version: $Id: Documentation.html 13140 2009-12-02 18:11:04Z
lem9 $
Requirements
* PHP
+ You need PHP 5.2.0 or newer, with session support (see FAQ 1.31) and
the Standard PHP Library (SPL) extension.
+ To support uploading of ZIP files, you need the PHP zip extension.
+ For proper support of multibyte strings (eg. UTF-8, which is currently
default), you should install mbstring and ctype extensions.
+ You need GD2 support in PHP to display inline thumbnails of JPEGs
("image/jpeg: inline") with their original aspect ratio
+ When using the "cookie" authentication method, the mcrypt extension is
strongly suggested for most users and is required for 64?bit machines.
Not using mcrypt will cause phpMyAdmin to load pages significantly
slower.
* MySQL 5.0 or newer (details);
* 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 57 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. Choose an appropriate distribution kit from the phpmyadmin.net Downloads
page. Some kits contain only the English messages, others contain all
languages in UTF-8 format (this should be fine in most situations), others
contain all languages and all character sets. We'll assume you chose a kit
whose name looks like phpMyAdmin-x.x.x-all-languages.tar.gz.
2. Untar or unzip the distribution (be sure to unzip the subdirectories): tar
-xzvf phpMyAdmin_x.x.x-all-languages.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 4, transfer the
directory on your web server using, for example, ftp.
3. 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.
4. 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
$cfg['Servers'][$i]['auth_type'] = 'config';
?>
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 setup/ 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 li
没有合适的资源?快使用搜索试试~ 我知道了~
新闻发布系统要的来下载啊
共1683个文件
php:477个
gif:395个
png:290个
需积分: 0 1 下载量 138 浏览量
2011-01-09
18:50:29
上传
评论
收藏 6.78MB RAR 举报
温馨提示
一个简单的新闻发布。金包括简单的增加、删除和修改
资源详情
资源评论
资源推荐
收起资源包目录
新闻发布系统要的来下载啊 (1683个子文件)
RELEASE-DATE-3.2.4 29B
fckeditor.afp 4KB
sample02.afp 3KB
sample04.afp 3KB
sample03.afp 3KB
sampleposteddata.afp 2KB
sample01.afp 2KB
fck.afpa 23B
config.ascx 5KB
class_upload.asp 10KB
io.asp 6KB
fckeditor.asp 6KB
commands.asp 6KB
config.asp 6KB
sample02.asp 3KB
sample04.asp 3KB
sample03.asp 3KB
connector.asp 2KB
sample01.asp 2KB
sampleposteddata.asp 2KB
basexml.asp 2KB
upload.asp 2KB
sampleposteddata.asp 2KB
util.asp 1KB
connector.aspx 1KB
upload.aspx 1KB
db_config.php.bak 292B
image.cfc 46KB
ImageObject.cfc 12KB
fckeditor.cfc 9KB
cf5_upload.cfm 10KB
cf5_connector.cfm 10KB
cf_io.cfm 10KB
cf_commands.cfm 8KB
config.cfm 8KB
fckeditor.cfm 7KB
spellchecker.cfm 5KB
cf_util.cfm 4KB
sample02_mx.cfm 3KB
sample04_mx.cfm 3KB
sample02.cfm 3KB
sample03_mx.cfm 3KB
sample04.cfm 3KB
cf_connector.cfm 3KB
sample03.cfm 3KB
cf_basexml.cfm 3KB
fckutils.cfm 2KB
sample01_mx.cfm 2KB
cf_upload.cfm 2KB
sampleposteddata.cfm 2KB
sample01.cfm 2KB
connector.cfm 992B
upload.cfm 991B
sample02.cgi 5KB
sample04.cgi 5KB
sample03.cgi 4KB
connector.cgi 4KB
sample01.cgi 3KB
upload.cgi 3KB
sampleposteddata.cgi 3KB
ChangeLog 13KB
fck.afpa.code 5KB
swekey.sample.conf 2KB
phpMyAdmin-http.conf 227B
CREDITS 169B
musbe-ca.crt 1KB
css_body.css 13KB
style.css 12KB
style.css 12KB
fck_editor.css 8KB
fck_editor.css 8KB
fck_editor.css 8KB
style1.css 7KB
styles.css 6KB
ui.datepicker.css 5KB
thickbox.css 4KB
fck_internal.css 4KB
docs.css 3KB
sample14.styles.css 3KB
fck_dialog.css 2KB
fck_dialog.css 2KB
fck_dialog.css 2KB
mooRainbow.css 2KB
fck_editorarea.css 2KB
css_top.css 2KB
browser.css 2KB
css_menu.css 2KB
form_new.css 2KB
fck_dialog_common.css 2KB
fck_showtableborders_gecko.css 1KB
sample.css 1KB
manage.css 1KB
print.css 1KB
spellerStyle.css 888B
base.css 546B
ui.datepicker.css~ 4KB
Thumbs.db 198KB
Thumbs.db 50KB
entries 1KB
entries 326B
共 1683 条
- 1
- 2
- 3
- 4
- 5
- 6
- 17
youshile
- 粉丝: 5
- 资源: 4
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 高光谱数据集(.mat.csv)-科研学术
- 基于JavaScript和CSS的母婴之家网页设计源码 - myzj
- WX小程序源码无后台京东白条
- WX小程序源码无后台简易计算器
- 基于SpringBoot和Vue的Fastcms前后端分离CMS系统设计源码 - fastcms
- WX小程序源码无后台会议精灵
- 基于Java和Javascript的工程建设综合管理系统材料管理模块设计源码 - material
- c51_2_2.c
- 凡客vancl商城的商品分类-产品搜索-产品详情-评论的抓取php程序压缩包
- ASCII American Standard Code for Information Interchange
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0