______________________________________________________________________
Top - Requirements - Introduction - Installation - Configuration
Transformations - FAQ - Developers - Credits - Translators
______________________________________________________________________
phpMyAdmin 2.6.4-pl1 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.147.2.3 2005/09/15 16:42:00 lem9 Exp $
Requirements
* PHP
+ You need PHP 4.1.0 or newer (*)
+ 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. Open the file config.inc.php in your favorite editor and change the v alues for host, user, password and authentication mode to fit your
environment. 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. It is recommended that you protect the directory in which you install ed phpMyAdmin (unless it's on a closed intranet, or you wish to use
HTTP or cookie authentication), for example with HTTP-AUTH (in a
.htaccess file). See the multi-user sub-section of the 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
* You can safely copy your older config.inc.php over a new one, if you can live with default values for possible new parameters (you can check
release notes to see what new features were added). This compatibility
will stay for long time, current version supports importing config files
from 2.2 and maybe even older (nobody has tried that).
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 pa
没有合适的资源?快使用搜索试试~ 我知道了~
FPT服务器架设软件Ravenswood-JS-1.0.12.1.zip下载
共2000个文件
php:837个
png:686个
html:444个
需积分: 9 18 下载量 18 浏览量
2009-11-12
20:43:28
上传
评论
收藏 13.06MB ZIP 举报
温馨提示
FPT服务器架设软件Ravenswood-JS-1.0.12.1.zip下载,欢迎下载!
资源推荐
资源详情
资源评论
收起资源包目录
FPT服务器架设软件Ravenswood-JS-1.0.12.1.zip下载 (2000个子文件)
RELEASE-DATE-2.6.4-pl1 30B
Helvetica.afm 76KB
dl_findfile.al 4KB
dl_expandspec.al 1KB
dl_find_symbol_anywhere.al 515B
start.bat 1KB
install.bat 495B
JLite.bat 476B
Start UniTray.bat 351B
close.bat 299B
uninstall.bat 288B
Stop UniTray.bat 250B
stop.bat 179B
mysqlstop.bat 68B
mysqlrun.bat 60B
run.bat 32B
Joomla.bmp 3KB
Socket.bs 0B
uniserv.c 1KB
pskill.c 1KB
jl.c 272B
win2unix.cgi 3KB
delete.cgi 1KB
mysqlstop.cgi 1KB
mysqlrun.cgi 1KB
restart_serv.cgi 1KB
shutdown.cgi 994B
errorlog.cgi 875B
cgienv.cgi 633B
cgienv.cgi 518B
mysqlrun.cgi1 1KB
ChangeLog 337KB
my-small.cnf 2KB
httpd.conf 35KB
oldhttpd.conf 35KB
win1251.conf 5KB
latin5.conf 5KB
win1251ukr.conf 4KB
estonia.conf 4KB
win1250.conf 4KB
cp1257.conf 4KB
hungarian.conf 4KB
koi8_ukr.conf 4KB
koi8_ru.conf 4KB
german1.conf 4KB
danish.conf 4KB
hebrew.conf 4KB
cp1251.conf 4KB
latin1.conf 4KB
latin2.conf 4KB
croat.conf 4KB
greek.conf 4KB
swe7.conf 4KB
usa7.conf 4KB
dec8.conf 4KB
hp8.conf 4KB
dos.conf 4KB
CREDITS 182B
docbook.css 22KB
template_css.css 11KB
template_css.css 11KB
template_css.css 9KB
editor_ui.css 8KB
theme.css 6KB
calendar-system.css 6KB
editor_popup.css 6KB
theme.css 5KB
uhp2.css 5KB
install.css 4KB
screen.css 4KB
calendar-mos.css 4KB
editor_content.css 3KB
docs.css 3KB
lightboxEx.css 3KB
phpfm.css 2KB
css_color_blue.css 2KB
admin_login.css 2KB
css_color_red.css 2KB
css_color_green.css 2KB
lightbox.css 2KB
editor_ui.css 2KB
tabpane.css 2KB
media.css 1KB
editor_content.css 1KB
contextmenu.css 1KB
dyngal.css 1KB
props.css 1KB
inlinepopup.css 1KB
dtree.css 882B
advimage.css 835B
editor_popup.css 805B
offline.css 762B
lightbox.css 737B
poll_bars.css 644B
content.css 609B
advlink.css 594B
searchreplace.css 536B
editor_content.css 513B
help.css 395B
blank.css 395B
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
不适合躺平
- 粉丝: 52
- 资源: 13
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功