软件星级:3分
phpMyAdmin (MySQL数据库管理)是一个用PHP编写的,可以通过互联网控制和操作MySQL。通过phpMyAdmin可以完全对数据库进行操作,例如建立、复制/删除数据等等。 管理 MySQL-server 以及单一数据库的 PHP 程序,对于不熟悉 MySQL 命令列指令的人来说,是很方便的管理工具。
phpMyAdmin 是一个用PHP编写的,可以通过 web方式控制和操作MySQL数据库。通过 phpMyAdmin 可以完全对数据库进行操作,例如建立'复制'删除数据等等。如果使用合适的工具,MySQL 数据库的管理就会变得相当简单。应用 MySQL 命令行方式需要对MySQL 知识非常熟悉,对 SQL语言也是同样的道理。不仅如此,如果数据库的访问量很大,列表中数据的读取就会相当困难。
phpMyAdmin可以管理整个MySQL服务器(需要超级用户),也可以管理单个数据库。为了实现后一种,你将需要合理设置MySQL用户,他只能对允许的数据库进行读/写。那要等到你看过MySQL手册中相关的部分。
1.下载多国语言包
解压好后更名为 phpmyadmin 注意全是小写的,把它放在 文件夹htdocs下
2.将config.sample.inc.php 更名为 config.inc.php
3,配制 config.inc.php
修改 $cfg['Servers'][$i]['controluser'] 把前面的 //去掉,在后面写上数据库名字 如 'root'
$cfg['Servers'][$i]['controlpass'] 把前面的// 去掉,在后面写上数据库密码,如'123'
修改$cfg['blowfish_secret'] = '' 在后面'' 里面随便填上几个数字 '456'
4. 配制服务器的php.ini
将php下的 libmcrypt.dll 复制到 C:WINDOWSsystem32
修改php.ini
将 ;extension=php_mcrypt.dll前的;去掉
5,重启apache即可
PhpMyAdmin安装包下载安装
将下载文件解压缩到 WEB 访问路径下。文件目录如phpmyadmin。
配置文件
然后配置目录下libraries文件下的 config.default.php 文件。
$cfg['PmaAbsoluteUri'] = ‘//localhost/phpmyadmin’;
$cfg['blowfish_secret'] = ’123456′;
$cfg['DefaultLang'] = ‘zh-gb2312′;
$cfg['DefaultCharset'] = ‘gb2312′;
$cfg['Servers'][$i]['auth_type'] = ‘cookie’;
保存之后,在浏览器里输入://localhost/phpmyadmin/user_password.php
phpMyAdmin v4.6.1
- issue #12120 PMA_Util not found in insert_edit.lib.php
- issue #12118 Fixed activation of some languages
- issue #12121 Fixed error in 3NF step of normalization
- issue #12135 Fix offering JSON datatype in incompatible MySQL versions
- issue #12132 Can not open table with JSON field
- issue #12125 Cannot highlight a column if I scroll down from the top of the table
- issue #12154 Fixed possible PHP error in SQL parser
- issue #12029 Fixed SQL quoting in SQL export
- issue #12129 Improve performance of database structure page
- issue #12159 Fix PHP error if user did unpack new version over old one
- issue #12165 Fix parsing of expression 0
- issue #12146 Document setup with Google Cloud SQL
- issue #12197 Fix parsing of queries with double
- issue #12202 Fixed setting of language from user configuration
- issue #12200 Fixed check for ndb version
- issue #12206 Fixed loading of configuration file
- issue #12204 Check if sessions are working and report failures
- issue #12211 non-clickable initial letter for users / and can't modify users with MySQL 5.7.12
- issue #12215 Fixed config tab persistence errors
- issue #12217 Fixed javascript erros on user creation
- issue #12144 Fixed parsing of some AS clauses
- issue #12205 Fixed parsing of FULL OUTER JOIN queries
- issue #12171 Fixed editing of VIEW structure
- issue #12208 Avoid printing executed queries on import
phpMyAdmin V4.5.1
- issue Invalid argument supplied for foreach()
- issue array_key_exists() expects parameter 2 to be array
- issue #11480 Notice Undefined index: drop_database
- issue #11486 Server variable edition in ANSI_QUOTES sql_mode: losing current value
- issue #11491 Propose table structure broken
- issue #11464 phpMyAdmin suggests upgrading to newer version not usable on that system
- issue #11495 'PMA_Microhistory' is undefined
- issue #11496 Incorrect definition for getTablesWhenOpen()
- issue #11500 Error when creating new user on MariaDB 10.0.21
- issue #11505 Notice on htmlspecialchars()
- issue Notice in Structure page of views
- issue #11510 AUTO_INCREMENT always exported when IF NOT EXISTS is on
- issue #11516 Some partitions are missing in copied table
- issue #11521 Notice of undefined variable when performing SHOW CREATE
- issue #11509 Error exporting sql query results with table alias
- issue #11512 SQL editing window does not recognise 'OUTER' keyword in 'LEFT OUTER JOIN'
- issue #11518 "NOT IN" clause not recognized (MySQL 5.6 and 5.7)
- issue #11524 Yellow star does not change in database Structure after add/remove from favorites
- issue #11531 Invalid SQL in table definition when exporting table
- issue #11526 Foreign key to other database's tables fails
- issue #11519 Bug while exporting results when a joined table field name is in SELECT query
- issue #11522 Strange behavior on table rename
- issue #11539 Rename table does not result in refresh in left panel
- issue #11541 Missing arguments for PMA_Table::generateAlter()
- issue #11544 Notices about undefined indexes on structure pages of information_schema tables
- issue Change minimum PHP version for Composer
- issue #11542 Import parser and backslash
- issue #11546 "Visualize GIS data" seems to be broken
- issue #11548 Confirm box on "Reset slave" option
- issue Fix cookies clearing on version change
- issue #11558 Cannot execute SQL with subquery
- issue #11520 Incorrect syntax creating a user using mysql_native_password with MariaDB
- issue #11561 Cannot use third party auth plugins
phpMyAdmin 4.3.11 更新日志
# SQL链接错误4774是完全错误的
错误4768:# MariaDB版本不匹配
错误4777缺少#一些图像设计师原创主题
错误4767:在细雨# mysql_charsets.inc.php未定义的索引
错误4753正常场#和多线领域有不同的利润率
错误4760不能重新导入设置#从本地存储
错误4778 SQL数据库列表时出错#通过附加的列进行排序
错误4780注意#时间戳列没有默认值
phpMyAdmin V4.4.6.1 Final
[安全] CSRF漏洞安装
[安全]漏洞允许中间人攻击
phpMyAdmin V4.5.5 更新内容:
Fixes include improvements to changing passwords on newer MariaDB servers and several fixes to the SQL parser which will resolve some errors users encountered entering commands in the SQL tab.