存档

文章标签 ‘phpmyadmin’

这消息透漏的挺快,phpMyAdmin 4.0.4.1正式版发布

2013年7月2日 没有评论

phpMyAdmin 4.0.4.1正式版昨天发布,我刚从网络得知消息,你看看百度就立马更新了好几篇关于phpMyAdmin 4.0.4.1正式版发布的文章,看来很多人都在盯着看phpMyAdmin 4.0.4.1的更新情况啊

这次的phpMyAdmin 4.0.4.1更新修正了很大的一个漏洞,所以建议如果大家是phpMyAdmin 4.0.4版本的,请务必要升级至phpMyAdmin 4.0.4.1,防止漏洞问题造成的损失,到时候大家就麻烦了哦。

我们还是言归正传吧,phpMyAdmin是我博客里经常提到和涉及到的一个软件,是mysql网页浏览、管理的一个非常牛的php网页软件,建议大家使用,之前在我的博客中提到的相关文章为:

phpmyadmin 4.0.4正式版发布
利用phpMyBackupPro巧妙批量定期备份mysql数据库,phpmyadmin无法完成!
phpmyadmin设置关闭information_schema
phpmyadmin 4.0.1正式版发布,phpMyAdmin 4.0.1

分类: 张宏良张洪量 标签:

phpmyadmin 4.0.4正式版发布

2013年6月29日 没有评论

phpMyAdmin – ChangeLog

phpMyAdmin – ChangeLog
======================

4.0.4.0 (2013-06-17)
– bug #3959 Using DefaultTabDatabase in NavigationTree for Database Click
– bug #3961 Avoid Suhosin warning when in simulation mode
– bug #3897 Row Statistics and Space usage bugs
– bug #3966 Only display “table has no unique column” message when applicable
– bug #3960 NavigationBarIconic config not honored
– bug #3965 Default language wrong with zh-TW
– bug #3921 Call to undefined function PMA_isSuperuser() if default server is
not set
– bug #3971 Ctrl/shift + click opens links in same window
– bug #3964 Import using https does not work
– bug Missing removeCRLF option in ExportCsv and ExportExcel plugins
– bug #3631 Drop not working Visio schema export.
– bug #3645 Better handling of invalid ODS documents
– bug #3976 Number of pages
– bug #3922 User privileges, database name unescaped

4.0.3.0 (2013-06-05)
– bug #3941 Recent tables list always empty
– bug #3933 Do not translate “Open Document” in export settings
– bug #3927 List of tables is missing after expanding in the navigation frame
– bug #3942 Warnings about reserved word for many non reserved words
– bug #3912 Exporting row selection, resulted by ORDER BY query
– bug #3957 Cookies must be enabled past this point
– bug #3956 “Browse foreign values” search filter / page selector not working
– bug #3579 NOW() function incorrectly selected (partial regression)
– [security] Javascript execution vulnerability in Create view,
reported by Maxim Rupp (see PMASA-2013-6)

4.0.2.0 (2013-05-24)
– bug #3902 Cannot browse when table name contains keyword “call”
+ center loading indicator for navigation refresh, related to bug #3920
– bug #3925 Table sorting in navigation panel is case-sensitive
– bug #3915 Import of CSV file (Replace table data with file) with duplicate values
– bug #3907 undefined variables, function parameter problems
– bug #3898 Structure not refreshed after column drop
– bug #3926 View is not updatable
– bug #3919 PropertiesIconic not honored
– bug #3930 Databases to choose for specific privileges show up escaped
– bug #3910 Export database with empty table as a php array, does not produce valid PHP
– bug #3936 Query profiler chart not loading from SQL Query page
– bug #3946 Missing CSV import option “Do not abort on INSERT error”
– bug #3943 Missing Operations>Table options>AUTO_INCREMENT
– bug Missing CREATE DATABASE statement when exporting at database level
– bug #3924 Show warning when CSV file does not contain data for all columns
– bug #3947 Missing Sql Query after modify structure
– bug #3948 Server export problems
– bug #3917 CountTables directive is deprecated

4.0.1.0 (2013-05-14)
– bug #3879 Import broken for CSV using LOAD DATA
– bug #3889 When login fails and error display is active, login data is displayed
– bug #3890 [import] Web server upload directory import fails
– bug #3891 [import] Server upload folder import file name missing in success message
+ RFE #1421 [auth] Add retry button on connection failure with config auth
– bug #3894 [interface] Provide feedback if no columns selected for multi-submit
– bug #3799 [interface] Incorrect select field change on ctrl key navigation in Firefox
– bug #3885 [browse] display_binary_as_hex option causes unexpected behavior
– bug #3899 Git commit links to Github missing
– bug #3900 CSP WARN in Firefox console
– bug #3901 Setup script warning for config auth (stored login data) shows link BBcode
– bug #3895 [browse] Fixed getting BLOB data
– bug #3905 [export] Custom Exporting exports all databases
– bug #3909 [import] Import of CSV FIle to selected table doesn’t work
– bug #3904 Browsing an empty table should not display its Structure
– bug #3908 Calendar widget improperly redirects to home
– bug #3918 Greyed out tabs when there are no rows fixed
– bug #3916 [interface] Missing scrollbar (original theme)
+ [vendor] add tcpdf path to vendor_config.php
– bug fix compat with tcpdf >= 6.0 (tested with 6.0.012)

4.0.0.0 (2013-05-03)
+ patch #3481047 for RFE #3480477 Insert as new row enhancement
+ patch #3480999 Activate codemirror in the query window
– patch #3495284 XML Import – fix message and redirect
+ RFE #3484063 Null checkbox behavior
+ patch #3497179 Contest-5: Add user: Allow create DB w/same name + grant u_%
+ patch #3498201 Contest-6: Export all privileges
+ patch #3502814 for RFE #3187077 Change password buttons should match
+ RFE #3488640 Expand table-group in non-light navigation frame if only one
+ patch #3509360 Contest-3: Option “Truncate table” before “insert”
+ patch #3506552 Contest-2: Show index information in the data dictionary
+ patch #3510656 Contest-1: Ignoring foreign keys while dropping tables
– bug #3509686 Reverting sort on joined column does not work
+ New transformation: append string
+ RFE #3507804 Session upload progress (PHP 5.4)
+ RFE #3488185 draggable columns vs copy column name
+ patch #3507001 Contest-4: Textarea for large character columns
+ Removed the PHP version of the ENUM editor
+ patch #3507111 Display distinct results, linked to corresponding data rows
– bug #3507917 [export] JSON has unescaped values for allegedly numeric columns
+ RFE #3516187 show tables creation, last update, last check timestamps in db_structure
– bug #3059806 Supporting running from CIFS/Samba shares
– bug #3516341 [export] Open Document Text, Word and Texy! Text show table structure twice
– bug [export] Texy! Text: Columns containing Pipe Character don’t export properly
+ [export] Show triggers in Open Document Text, Word and Texy! Text
– patch #3415061 [auth] Login screen appears under the page
+ RFE #3517354 [interface] Allow disabling CodeMirror with $cfg[‘CodemirrorEnable’] = false
+ RFE #3475567 [interface] New directive $cfg[‘HideStructureActions’]
– bug #3468272 [import] Fixed import of ODS with more paragraphs in a cell
– bug #3510196 [core] Improved redirecting with ForceSSL option
+ RFE #3518852 [edit] edit blob but not other binary, new option $cfg[‘ProtectBinary’] = ‘noblob’
+ Hide language select box if there are no locales installed
+ Removed some directives: verbose_check, SuggestDBName, LightTabs,
VerboseMultiSubmit, ReplaceHelpImg
– patch #3500882 Fixing checkbox behaviour while editing identical rows
+ RFE #3441722 [interface] Display description of datatypes
+ RFE #3517835 [structure] Move columns easily
+ Ajaxified “Create View” functionality
+ [import] New plugin: import mediawiki
+ New navigation system
+ Discontinued the use of a frame-based layout
+ RFE #3528994 [interface] Allow wrapping possibly long values in replication-status table
+ [interface] Autoselect username input on cookie login page
– bug #3563799 [interface] Grid editing destroying huge amount of data
+ [import] Remove support for the unactive docSQL import format
– bug #3577443 [edit] “Browse foreign values” does not show on ajax edit
+ RFE #3522109 [browse] Grid editing: action to trigger it (or disable)
– bug #3526598 [interface] SQL query not shown when creating table
+ Dropped configuration directive: AllowThirdPartyFraming
+ Dropped configuration directive: LeftFrameLight
+ Dropped configuration directive: DisplayDatabasesList
+ Dropped configuration directives: ShowTooltipAliasDB and ShowTooltipAliasTB
+ Dropped configuration directive: NaviDatabaseNameColor
+ Added configuration directive: MaxNavigationItems
+ Renamed configuration directive: LeftFrameDBTree => NavigationTreeEnableGrouping
+ Renamed configuration directive: LeftFrameDBSeparator => NavigationTreeDbSeparator
+ Renamed configuration directive: LeftFrameTableSeparator => NavigationTreeTableSeparator
+ Renamed configuration directive: LeftFrameTableLevel => NavigationTreeTableLevel
+ Renamed configuration directive: LeftPointerEnable => NavigationTreePointerEnable
+ Renamed configuration directive: LeftDefaultTabTable => NavigationTreeDefaultTabTable
+ Renamed configuration directive: LeftDisplayTableFilterMinimum => NavigationTreeDisplayTableFilterMinimum
+ Renamed configuration directive: LeftDisplayLogo => NavigationDisplayLogo
+ Renamed configuration directive: LeftLogoLink => NavigationLogoLink
+ Renamed configuration directive: LeftLogoLinkWindow => NavigationLogoLinkWindow
+ Renamed configuration directive: LeftDisplayServers => NavigationDisplayServers
+ Renamed configuration directive: LeftRecentTable => NumRecentTables
+ Renamed configuration directive: LeftDisplayDatabaseFilterMinimum => NavigationTreeDisplayDbFilterMinimum
+ Removed the “Mark row on click” feature; must now click the checkbox to mark
+ Removed the “Synchronize” feature
+ Improved layout of server variables page
+ RFE #1052091 [config] Double-underscores in PMA table names
+ Improved the “More” dropdown on the table structure page
+ [interface] Added “scroll to top” link in menubar
+ [designer] Fullscreen mode for the designer
+ Upgraded jquery to v1.8.3 and jquery-ui to v1.9.2
+ patch #3597529 [status] Add raw value as title on server status page
+ Support MySQL 5.6 partitioning
+ Removed the AjaxEnable directive
+ RFE #3542567 Accept IPv6 ranges and IPv6 CIDR notations in $cfg[‘Servers’][$i][‘AllowDeny’][‘rules’]
– bug #3576788 Grid editing shows the value before silent truncation
– Upgraded jqPlot to 1.0.4 r1121
– Upgraded to jquery-ui-timepicker-addon 1.1.1
+ RFE #3599046 [interface] Added comments for indexes
– Replaced qtip with jQuery UI tooltip
– Upgraded CodeMirror to 2.37
– bug #2951 [export] Correctly export decimal fields.
– bug #3762 [core] Make Advisor work on Windows withou COM extension.
– bug #3519 [export] Prevent infinite recursion in PDF export.
– bug #3827 Table specific privileges not displayed for db name containing
underscore
– RFE #1386 Add IF NOT EXISTS clause when copying database
– No longer package .travis.yml configuration file when creating a release.
– bug #3830 Can’t export custom query because it lowercases table names
– bug #3829 Enabling query profiling crashes javascript based navigation
+ rfe #879 Reserved word warning
+ Remove the database ordering sub-feature of the only_db directive
– bug #3840 When exporting to gzip format, the data is compressed 2 times
+ RFE #1319 Permit to create index when creating foreign key
– bug #3703 Incorrect updating of the list of users
– bug #3853 Blowfish implementation might be broken (replace with phpseclib)
– bug #3865 Using like operator on each backslash needs 4 backslash protection
– bug #3860 Displayed git revision info is not set
– bug #3871 Check referential integrity broken across databases
– bug #3874 [export] No preselected option when exporting table
– bug #3873 Can’t copy table to target database if table exists there
– bug #3683 Incorrect listing of records from to count
– bug #3876 [import] PHP 5.2 – unexpected T_PAAMAYIM_NEKUDOTAYIM
– [security] Local file inclusion vulnerability, reported by Janek Vind
(see PMASA-2013-4)
– [security] Global variables overwrite in export.php, reported by Janek Vind
(see PMASA-2013-5)
– bug #3892 [export] SQL Export files are empty

3.5.8.1 (2013-04-24)
– [security] Remote code execution (preg_replace), reported by Janek Vind
(see PMASA-2013-2)
– [security] Locally Saved SQL Dump File Multiple File Extension Remote Code
Execution, reported by Janek Vind (see PMASA-2013-3)

3.5.8.0 (2013-04-08)
– bug #3828 MariaDB reported as MySQL
– bug #3854 Incorrect header for Safari 6.0
– bug #3705 Attempt to open trigger for edit gives NULL
– Use HTML5 DOCTYPE
– [security] Self-XSS on GIS visualisation page, reported by Janek Vind
– bug #3800 Incorrect keyhandler behaviour #2

3.5.7.0 (2013-02-15)
– bug #3779 [core] Problem with backslash in enum fields
– bug #3816 Missing server_processlist.php
– bug #3821 Safari: white page
– Correct detection of the Chrome browser

3.5.6.0 (2013-01-28)
– bug #3593604 [status] Erroneous advisor rule
– bug #3596070 [status] localStorage broken in server status monitor
– bug #3598736 [routines] Editing a procedure with special characters
– bug #3600322 [core] Visualize GIS data throws Fatal Error
– bug #3599362 [core] Double-escaped error message
– bug #3776 [cookies] Login without auth on second server

— Older ChangeLogs can be found on our project website —
http://www.phpmyadmin.net/old-stuff/ChangeLogs/

# vim: et ts=4 sw=4 sts=4
# vim: ft=changelog fenc=utf-8
# vim: fde=getline(v\:lnum-1)=~’^\\s*$’&&getline(v\:lnum)=~’\\S’?’>1’\:1&&v\:lnum>4&&getline(v\:lnum)!~’^#’
# vim: fdn=1 fdm=expr

分类: php学习 标签:

利用phpMyBackupPro巧妙批量定期备份mysql数据库,phpmyadmin无法完成!

2013年6月15日 没有评论

由于工作需要,今天在网络寻找批量定期备份mysql数据库的方法,首先我从百度和谷歌都搜索了相关的phpmyadmin的使用文档,搜索关键词如下:
1,phpmyadmin批量备份mysql数据库
2,如何使用phpmyadmin定期备份mysql数据库
3,phpmyadmin定期批量备份mysql数据库
找了这些关键词都无法找到想要的结果,而最终的结果是phpmyadmin无法定期备份数据库。而且单次导出也很麻烦,最主要的是不支持远程ftp发送。

有了这些请求之后,我就尝试了用phpmyadmin来批量导出数据库为sql文件,其实这个phpmyadmin是可以做到的,具体流程如下:
1,打开phpmyadmin
2,点击export导出
3,选择所有数据库
4,选择zip压缩
5,开始导出
这样能完整的导出备份所有的数据库,但是效率低下,尤其是表一多,那就完蛋了。

后来通过网络搜索到phpMyBackupPro,可以非常巧妙的定期批量备份mysql,那么具体定期备份方法其实很简单,你只要下载phpMyBackupPro这个软件即可,然后到官方寻找批量备份的方法。
我这里只简单的介绍下方法

直接上传phpMyBackupPro下载包到ftp中,然后点击导航上的configuration,依次配置下信息,很简单的英文,都能看懂。
首次登陆不需要密码,配置完成之后需要mysql密码

最主要的一点是要告诉大家,务必修改默认的导出路径export为别的路径,否则太容易暴漏了。
修改方法:
打开definitions.php,修改$_PMBP_EXPORT_DIR即可,注意,目录一定要以”/”结尾

整体的批量定期备份mysql就大工搞成了。phpMyBackupPro还是不错的,尤其是在批量备份上,还支持远程ftp备份,建议phpmyadmin增加个这样的功能

phpmyadmin设置关闭information_schema

2013年5月29日 没有评论

最近有需要向外开通phpmyadmin的需要,但是发现phpmyadmin中的所有用户都可以访问information_schema表
于是百度寻找了最新的解决办法,在phpmyadmin中关闭information_schema的显示方法
找到config.default.php,打开
将$cfg[‘Servers’][$i][‘hide_db’] = ‘information_schema’;更改掉,然后保存上传,这样用phpmyadmin打开之后就无法看到information_schema了。
在这里记录,方便以后查询和搜索。保证管用。
phpmyadmin设置关闭information_schema的方法就到此为止

Navicat for MySQL version: 11.0.7 Trial 版本发布

2013年5月29日 没有评论

前段时间我们聊到navicat软件重大改版的信息,是的,不光是这样,最近根据我看来,似乎Navicat软件更新版本也快的多了,似乎是一个周期更新一次啊,不错,值得推荐。

当然了,说到navicat for mysql 11.0.7版本的发布,我们肯定要同时关注下他的对手,也是鼓舞者,phpmyadmin,根据官方显示phpmyadmin软件也更新了,更新到phpMyAdmin-4.0.2-all-languages,同时一个礼拜更新一次软件,看似他们现在都在大大的抢占市场份额啊,之前我在文章当中提到navicat for mysql 11.0.6正式版发布及下载 同时也提到了phpmyadmin的版本升级,下面我贴上2个最新软件的下载地址:

Navicat for MySQL 11.0.7的正式版下载地址为:navicat110_mysql_en_x86

phpMyAdmin 4.0.2的正式版下载地址为:phpMyAdmin-4.0.2-all-languages.zip

后期我们会陆续关注2个软件的版本更新情况,拭目以待。

css.php