phpMyAdmin 4.5.0-beta1 发布,此版本要求 PHP 5.5。
值得关注的改进:
* Improvements to the Console feature * Include structure in PDF export * Validate data before import * Support CHECKSUM TABLE operation * Improved operations regarding partitions * Alter privileges when renaming or copying a database or table * Several improvements related to speed and responsiveness * Improved print view * Use CTRL or ALT plus arrow keys to navigate in grid editor * Use plain-English destinations for $cfg['NavigationTreeDefaultTabTable'], $cfg['DefaultTabServer'], $cfg['DefaultTabDatabase'], and $cfg['DefaultTabTable']. The old style values will still work, but this makes it easier for new users to easily understand the destination links. * Integrate SQL debugging into Console * Restore row editing when no unique/primary key exists * Allow exporting one file per table and one file per database * Improvements to using multiple servers with the auth_type cookie * Support virtual columns (MySQL 5.7.5+) * Add or improve support for several MariaDB features including process list and virtual/persistent columns * Improved handling of cached data when upgrading phpMyAdmin * Add SHA256 security password support
phpMyAdmin是一个非常受欢迎的基于web的MySQL数据库管理工具。它能够创建和删除数据库,创建/删除/修改表格,删除/编辑/新增字段,执行SQL脚本等。
查询统计(增查改删所占比例),MySQL状态变量查看和修改,MySQL实时监控(canvas绘制曲线图),
而且还能进行汇总,找出可能存在的性能问题,并给出改进建议.
SQL查询工具还支持自动提示和代码高亮,查询时还能进行性能分析生成表格数据,并使用canvas绘制饼状图.
在 "数据库实例" -> "结构" -> "选中项" 中提供有 Show create 操作,用于显示表创建语句.
PMA的导出的文件类型支持也很丰富,使用起来也很方便.
PMA是目前最强大的MySQL网页管理工具.
总而言之,用PMA管理MySQL数据库和用户以及进行MySQL开发,足够了.
注意:Windows7及其以后的系统,如果在my.ini中配置了bind-address = 127.0.0.1,
那么PHP连接MySQL时要使用127.0.0.1,如果使用localhost,连接会有长达1秒的延迟.
还有关闭Xdebug,开启Opcache能明显提升PHP应用速度.
PMA开发者已经开始对PHP7进行兼容和支持,用PHP7跑,速度翻倍.
可以试试用PHP7跑PMA:
解压即用,跨Linux发行版PHP7打包(附打包方法)
http://my.oschina.net/eechen/blog/411534
话说要求5.5,有点激进呀。我开发用的PHP版本还是5.4。