phpMyAdmin 3.4.8 Documentation
* Top
* Requirements
* Introduction
* Installation
* Setup script
* Configuration
* Transformations
* FAQ
* Developers
* Copyright
* Credits
* Glossary
* phpMyAdmin homepage
* SourceForge phpMyAdmin project page
* Official phpMyAdmin wiki
* 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)
* 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 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
没有合适的资源?快使用搜索试试~ 我知道了~
php授权验证系统
共1025个文件
php:438个
png:345个
js:62个
需积分: 16 8 下载量 146 浏览量
2018-05-27
19:20:20
上传
评论 2
收藏 6.77MB ZIP 举报
温馨提示
权中心相关 123.sql 授权中心的数据库 脚本 jsduhufysjdu45ghgg 目录是补丁目录 放到自己的服务器上 比如 http://www.baidu.com/jsduhufysjdu45ghgg update.php 负责 授权检查 和 更新版本检查 版本都是 依次递增 1.1 1.2 1.3 不能跳跃 客户端也是依次升级 客户端 当前版本是 1.1 就先升级到 1.2 再升级到 1.3 所以 在授权管理中心 添加版本的时候 必须按照规律来 版本号 必须如此 更新包 很简单 参考下 jsduhufysjdu45ghgg 下面的 1.1.zip 命名格式 升级文件为了防止猜出来 可以自己随意命名 zip格式 客户端版本号 就按照 之前定的前缀 就行 在查询的时候 我已经做处理了 你确定下 你的前缀 还得修改 version.php 里面的版本号 自己想一下 确定下 更新包的 数据库更新脚本 update.sql sql语句 自己写 务必检查好 客户端升级的时候 直接执行 更新包 每次更新完成后 都全部删除 防止客户拿到更新包 更新包制作 必须严谨 测试后 再发布 授权管理平台 用户 admin 密码 admin888 安全码 123456 授权域名 为顶级域名 不限制二级域名 授权时间 格式 2015-01-01 这样填写 微信平台网站相关 升级动作 已经包含 授权检查 客户端其他文件 授权检查代码.php 自己复制到重要文件中 然后加密重要文件就行 授权检查代码 一定要加在文件开头 不然不起作用
资源推荐
资源详情
资源评论
收起资源包目录
php授权验证系统 (1025个子文件)
RELEASE-DATE-3.4.8 29B
ChangeLog 30KB
pChart.class 137KB
pData.class 7KB
pCache.class 3KB
swekey.sample.conf 2KB
CREDITS 227B
tcpdf.crt 2KB
musbe-ca.crt 1KB
bootstrap.min.css 114KB
style.css 114KB
jquery-ui-1.8.custom.css 30KB
jquery-ui-1.8.custom.css 30KB
index.css 25KB
font-awesome.css 21KB
layer.css 14KB
style-responsive.css 12KB
public.css 12KB
style1.css 10KB
styles.css 7KB
bootstrap-reset.css 7KB
toastr.css 7KB
laydate.css 6KB
404.css 5KB
layer.css 5KB
slidebars.css 4KB
laydate.css 3KB
laydate.css 3KB
laydate.css 3KB
laydate.css 3KB
laydate.css 3KB
laydate.css 3KB
laydate.css 3KB
docs.css 3KB
owl.carousel.css 1KB
print.css 1KB
jquery.easy-pie-chart.css 141B
fontawesome-webfont.eot 37KB
glyphicons-halflings-regular.eot 20KB
tcpdf.fdf 1KB
loading-0.gif 6KB
ajax_clock_small.gif 2KB
ajax_clock_small.gif 2KB
input-spinner.gif 2KB
loading-2.gif 2KB
onLoad.gif 781B
loading-1.gif 701B
input_bg.gif 162B
customSelect-arrow.gif 47B
htaccess 2KB
.htaccess 118B
.htaccess 118B
.htaccess 118B
Documentation.html 244KB
favicon.ico 18KB
error.ico 5KB
favicon.ico 1KB
error.ico 318B
gettext.inc 17KB
phpdoctor.ini 4KB
README.INI 3KB
INSTALL 128B
140916064844xgrlvl.jpg 34KB
login-bg.jpg 33KB
lock-bg.jpg 31KB
corner_image.jpg 28KB
9602x90.jpg 28KB
new_data.jpg 2KB
new_data.jpg 2KB
new_struct_hovered.jpg 2KB
new_struct_hovered.jpg 2KB
new_data_hovered.jpg 2KB
new_data_hovered.jpg 2KB
new_struct_selected_hovered.jpg 1KB
new_struct_selected_hovered.jpg 1KB
new_data_selected_hovered.jpg 1KB
new_data_selected_hovered.jpg 1KB
new_data_selected.jpg 1KB
new_data_selected.jpg 1KB
new_struct_selected.jpg 1KB
new_struct_selected.jpg 1KB
new_struct.jpg 1KB
new_struct.jpg 1KB
chart-texture.jpg 449B
jquery-ui-1.8.custom.js 186KB
jquery.jcryption.3.1.0.js 148KB
jquery.sparkline.js 121KB
jquery-1.7.2.min.js 93KB
jquery-1.7.2.min.js 93KB
jquery.js 91KB
jquery.min.js 90KB
jquery-1.4.4.js 76KB
jquery.nicescroll.js 58KB
owl.carousel.js 52KB
move.js 40KB
jquery.qtip-1.0.0.min.js 38KB
bootstrap.min.js 35KB
functions.js 31KB
history.js 25KB
layer.js 21KB
共 1025 条
- 1
- 2
- 3
- 4
- 5
- 6
- 11
资源评论
qq_35768826
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功