phpMyAdmin 3.5.1-rc1 Documentation
* Top
* Requirements
* Introduction
* Installation
* Setup script
* Configuration
* Transformations
* FAQ
* Developers
* Copyright
* Credits
* Glossary
* phpMyAdmin homepage
* SourceForge phpMyAdmin project page
* Official phpMyAdmin wiki
* Git repositories on Github
* Local documents:
+ Version history: ChangeLog
+ License: LICENSE
Requirements
* PHP
+ You need PHP 5.2.0 or newer, with session support (see FAQ 1.31) , the
Standard PHP Library (SPL) extension and JSON support.
+ To support uploading of ZIP files, you need the PHP zip extension.
+ For proper support of multibyte strings (eg. UTF-8, which is currently
the default), you should install the 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.
+ To support upload progress bars, see FAQ 2.9.
+ To support BLOB streaming, see PHP and MySQL requirements in FAQ 6.25.
+ To support XML and Open Document Spreadsheet importing, you need PHP
5.2.17 or newer and the libxml extension.
* 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, columns and indexes
* create, copy, drop, rename and alter databases, tables, columns 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, and L^AT[E]X formats
* import data and MySQL structures from OpenDocument spreadsheets, as well as
XML, CSV, and SQL files
* 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
* track changes on databases, tables and views
* support InnoDB tables and foreign keys (see FAQ 3.6)
* support mysqli, the improved MySQL extension (see FAQ 1.17)
* create, edit, call, export and drop stored procedures and functions
* create, edit, export and drop events and triggers
* communicate in 62 different languages
* synchronize two databases residing on the same as well as remote servers
(see FAQ 9.1)
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. phpMyAdmin configuration storage
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
没有合适的资源?快使用搜索试试~ 我知道了~
游戏账号出售源码 账号交易平台源码 手游账号交易平台源码 游戏币交易源码.zip
共2001个文件
php:707个
png:582个
gif:225个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
5星 · 超过95%的资源 2 下载量 99 浏览量
2023-11-18
11:21:07
上传
评论 1
收藏 64.44MB ZIP 举报
温馨提示
游戏帐号交易平台,游戏币交易和手游账号出售源码下载 安装搭建说明 亲测环境:Linux+Nginx1.16.1+PHP5.6+Mysql5.5 先修改配置文件:/config/config.php Nginx伪静态 后台地址:/yjadmin/ 进入后基本配置 修改下域名,【清除缓存】,安装完毕。
资源推荐
资源详情
资源评论
收起资源包目录
游戏账号出售源码 账号交易平台源码 手游账号交易平台源码 游戏币交易源码.zip (2001个子文件)
RELEASE-DATE-3.5.1-rc1 29B
js_games_phone.js.bak 68KB
ChangeLog 26KB
swekey.sample.conf 2KB
musbe-ca.crt 1KB
index.css 45KB
ueditor.css 43KB
ueditor.min.css 33KB
jquery-ui-1.8.16.custom.css 33KB
jquery-ui-1.8.16.custom.css 33KB
basic.css 26KB
basic.css 26KB
index.css 24KB
default.css 22KB
index.css 20KB
umeditor.css 18KB
layer.css 14KB
index.css 14KB
umeditor.min.css 14KB
index.css 14KB
index.css 14KB
index.css 14KB
basic.css 11KB
basic.css 10KB
basic.css 10KB
tinymce.css 10KB
index.css 10KB
default.css 10KB
task.css 9KB
shop.css 9KB
basic.css 9KB
basic.css 9KB
index.css 9KB
index.css 8KB
index.css 8KB
style.css 8KB
index.css 8KB
basic.css 7KB
shCoreDefault.css 7KB
styles.css 7KB
index.css 6KB
index.css 6KB
common.css 6KB
index.css 5KB
layer.css 5KB
layer.css 5KB
index.css 4KB
jquery.flexslider.css 4KB
index.css 4KB
jquery.flexslider.css 4KB
jquery.flexslider.css 4KB
scrawl.css 4KB
jquery.flexslider.css 4KB
basic.css 3KB
image.css 3KB
codemirror.css 3KB
index.css 3KB
docs.css 3KB
video.css 3KB
index.css 3KB
image.css 3KB
attachment.css 3KB
charts.css 3KB
lanrenzhijia.css 2KB
emotion.css 2KB
index.css 2KB
pty.css 2KB
style.css 2KB
style.css 2KB
video.css 2KB
emotion.css 2KB
dialogbase.css 2KB
music.css 2KB
uploadifive.css 2KB
index.css 2KB
demo.css 1KB
index.css 1KB
elastislide.css 1KB
elastislide.css 1KB
uploadify.css 1KB
uploadify.css 1KB
edittable.css 1KB
background.css 1KB
print.css 1KB
template.css 1KB
file_manager.css 1KB
formula.css 869B
reset.css 753B
index.css 736B
editor.css 736B
index.css 682B
reset.css 654B
index.css 645B
index.css 577B
index.css 476B
help.css 395B
ie6-style.css 165B
google.css 143B
index.css 66B
iframe.css 31B
共 2001 条
- 1
- 2
- 3
- 4
- 5
- 6
- 21
资源评论
- m0_688134472024-03-18超赞的资源,感谢资源主分享,大家一起进步!
- hgy755505552024-04-26这个资源总结的也太全面了吧,内容详实,对我帮助很大。
智慧浩海
- 粉丝: 1w+
- 资源: 5113
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功