* Top
* Requirements
* Introduction
* Installation
* Setup script
* Configuration
* Transformations
* FAQ
* Developers
* Credits
* Translators
* Glossary
phpMyAdmin 3.1.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 12197 2009-01-19 17:32:29Z
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 55 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
?>
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 link to save the config file locally and up
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
phpMyAdmin-3.1.2.rar (608个子文件)
RELEASE-DATE-3.1.2 29B
ChangeLog 41KB
swekey.sample.conf 2KB
phpMyAdmin-http.conf 227B
CREDITS 169B
musbe-ca.crt 1KB
style1.css 7KB
styles.css 6KB
docs.css 4KB
mooRainbow.css 2KB
print.css 1KB
moor_arrows.gif 94B
moor_cursor.gif 80B
blank.gif 43B
.htaccess 118B
Documentation.html 223KB
translators.html 8KB
favicon.ico 18KB
favicon.ico 1KB
error.ico 318B
error.ico 318B
INSTALL 179B
mootools.js 90KB
functions.js 44KB
move.js 32KB
scripts.js 21KB
mooRainbow.js 18KB
common.js 13KB
tbl_change.js 11KB
tooltip.js 5KB
ajax.js 5KB
dom-drag.js 5KB
iecanvas.js 4KB
navigation.js 4KB
server_privileges.js 3KB
indexes.js 3KB
keyhandler.js 2KB
querywindow.js 1KB
mootools-domready-rainbow.js 759B
LICENSE 18KB
LICENSE 5KB
unicode_data.php 287KB
tcpdf.php 212KB
chinese_simplified-utf-8.inc.php 106KB
display_tbl.lib.php 105KB
sqlparser.lib.php 99KB
english-utf-8.inc.php 96KB
server_privileges.php 93KB
common.lib.php 89KB
config.default.php 59KB
pdf_schema.php 52KB
tbl_change.php 52KB
dejavusansb.php 48KB
dejavusans.php 48KB
database_interface.lib.php 48KB
Table.class.php 47KB
File.class.php 43KB
relation.lib.php 42KB
sql.php 40KB
Config.class.php 34KB
tbl_structure.php 31KB
db_qbe.php 30KB
common.inc.php 28KB
tbl_properties.inc.php 28KB
sqlparser.data.php 27KB
pdf_pages.php 26KB
tbl_operations.php 26KB
theme_right.css.php 26KB
blowfish.php 26KB
sql.php 25KB
navigation.php 25KB
db_operations.php 25KB
theme_right.css.php 25KB
export.php 24KB
blobstreaming.lib.php 24KB
db_structure.php 22KB
cookie.auth.lib.php 22KB
tbl_relation.php 21KB
Message.class.php 21KB
server_status.php 20KB
sql_query_form.lib.php 20KB
dejavuserifb.php 20KB
dejavuserif.php 20KB
Index.class.php 20KB
mysqli.dbi.lib.php 19KB
FormDisplay.class.php 19KB
pmd_general.php 18KB
core.lib.php 18KB
List_Database.class.php 18KB
tbl_printview.php 16KB
latex.php 16KB
select_lang.lib.php 16KB
tbl_select.php 16KB
mult_submits.inc.php 15KB
odt.php 15KB
mysql_charsets.lib.php 15KB
swekey.php 15KB
pdf.php 15KB
plugin_interface.lib.php 14KB
tbl_replace.php 13KB
共 608 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
隐形的粉红色独角兽
- 粉丝: 16
- 资源: 122
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- GAPSO-LSTM,即遗传粒子群优化算法优化LSTM的超参数做数据回归预测,多输入单输出,预测精度高于PSO-LSTM,算法原
- 永磁同步电机的参数辨识源码,完整的CCS工程,已经在工程项目上验证通过,辨识精度非常高 1、参数辨识源码在src-foc文件夹
- 增程式电动汽车基于工况的自适应ECMS能量管理策略(matlab的m程序)
- Fluent电弧,激光,熔滴一体模拟 UDF包括高斯旋转体热源、双椭球热源(未使用)、VOF梯度计算、反冲压力、磁场力、表面张
- C#全自动多线程上位机源码编程 0,纯源代码 1,替代传统plc搭载的触摸屏 2,工控屏幕一体机直接和plc通信 3,功能
- 基于三有源桥的模型预测控制仿真,可以独立控制输出侧两个端口的电压或者电流,动态响应快,也可以扩展至四有源桥电路
- VIENNA维也纳拓扑,三相整流simulink仿真:采用电压电流双闭环控制,电压外环采用PI控制,电流内环采用bang ban
- 永磁同步电机改进超螺旋滑模观测器无位置传感器控制 采用一种改进的超螺旋滑模观测器永磁同步电机无位置传感器控制,该观测器在传统ST
- comsol仿真模拟气液两相化学吸收CO2(氢氧化钠溶液NaOH和MEA溶液吸收CO2) 此案例为文献复现
- 内有cpar文件和simulink文件,并有演示操作视频,carsim+simulink联合仿真实实现道超车, 包含道决策,路径
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功