国产吧祝大家新年快乐,万事如意,Happy New Year!
因专注所以专业
我们一直在努力

phpMyAdmin v5.0.0/4.9.3 Final 多语言中文正式版-MySQL数据库管理

phpMyAdmin(MySQL数据库管理)是一个用PHP编写的,可以通过web方式控制和操作MySQL数据库。通过phpMyAdmin可以完全对数据库进行操作,例如建立、复制、删除数据等等。如果使用合适的工具,MySQL数据库的管理就会变得相当简单。应用MySQL命令行方式需要对MySQL知识非常熟悉,对SQL语言也是同样的道理。不仅如此,如果数据库的访问量很大,列表中数据的读取就会相当困难。

phpMyAdmin v5.0.0/4.9.3 Final 多语言中文正式版-MySQL数据库管理

phpMyAdmin是一个非常受欢迎的基于web的MySQL数据库管理工具。它能够创建和删除数据库,创建/删除/修改表格,删除/编辑/新增字段,执行SQL脚本等。

当前出现很多 GUI MySQL客户程序,其中最为出色的是基于 Web 的 phpMyAdmin 工具。这是一种 MySQL 数据库前台的基于PHP的工具。PhpMyAdmin 的缺点是必须安装在 Web 服务器中,所以如果没有合适的访问权限,其它用户有可能损害到 SQL 数据。

phpMyAdmin 5.0.0版本于今天正式发布。该版本同4.9.3版本同时存在,不过官方推荐没有安装旧版PHP的用户尽量使用5.0.0版本。本次5.0版本更新中在涵盖了4.9分支的大量改进之外,还引入了诸多新功能。

团队表示也希望为那些运行旧版PHP的用户尽量维护phpMyAdmin 4分支,有关受支持的版本和寿命终止日期的完整详细信息,请参阅https://www.phpmyadmin.net/downloads/上的“受支持的版本”一栏。phpMyAdmin 5.0.0版本移除了对旧版PHP版本(5.5、5.6、7.0和HHVM)的支持,这些旧版本已经不再得到PHP团队的支持。

在什么情况下会用到 phpMyAdmin

1、需要修复数据库的时候

2、设置数据库用户权限的时候

3、检查和浏览数据库的时候

4、执行 SQL  语句的时候

5、恢复和备份数据库的时候

6、还会用到一些常见问题上

phpMyAdmin 5.0.0版本对用户界面进行了诸多现代化改进,在更加透明的同时让代码维护变得更加轻松。改进的部分功能包括:

● 默认情况下启用CSV导出的列名称

● 添加Metro主题

● 创建自动递增列时自动添加索引

● 改进了导出视图

● 在没有WHERE子句的UPDATE查询之前,提示用户进行确认

● 改进了向用户显示错误的方式(包括允许更轻松地将错误文本复制到剪贴板)

● 添加了击键以清除行(ctrl + l)并清除整个控制台窗口(ctrl + u)

● 导出格式为MS Excel时使用字符集“ Windows-1252”

已知的问题

由于MySQL对身份验证方法的更改,7.4之前的PHP版本无法向MySQL 8.0或更高版本的服务器进行身份验证(我们的测试表明,问题实际上始于MySQL 8.0.11)。这与PHP错误https://bugs.php.net/bug.php?id=76243有关。

临时解决方法就是,将您的用户帐户设置mysql_native_password为使用当前样式的密码哈希方式。不幸的是,这种缺乏协调的行为导致了所有PHP应用程序的不兼容性,受影响的不仅仅是phpMyAdmin。有关更多详细信息,您可以在https://github.com/phpmyadmin/phpmyadmin/issues/14220上查看我们的错误跟踪器项。

更新记录:

phpMyAdmin 5.0.0 Released 2019-12-26.

Welcome to the release of phpMyAdmin version 5.0.0.

This release includes many new features and improvements from the 4.9 series. We expect to maintain version 4 in a security capacity
to support users with older PHP installations. For full details about supported versions and end of life dates, see the "Supported versions"
grid at .

With this release, we are removing support of old PHP versions (5.5, 5.6, 7.0, and HHVM). These versions are outdated and are no longer supported by the PHP team.

Version 5.0 includes many coding improvements that modernize the interface. Many of these changes are transparent to users, but make the code easier to maintain.
Much of this refactoring work is completed by our contract developer, Maurício Meneghini Fauth. We always consider applications for new (paid) contract developers,
see  for program details.

Some of the changes and new features include:

* Enable columns names by default for CSV exports
* Add Metro theme
* Automatically add the index when creating an auto increment column
* Improvements to exporting views
* Prompt the user for confirmation before running an UPDATE query with no WHERE clause
* Improvements to how errors are show to the user (including allowing easier copying of the error text to the clipboard)
* Added keystrokes to clear the line (ctrl+l) and clear the entire console window (ctrl+u)
* Use charset 'windows-1252' when export format is MS Excel

There are several more changes, please refer to the ChangeLog file included with the release for full details.

Known shortcomings:

Due to changes in the MySQL authentication method, PHP versions prior to 7.4 are unable to authenticate to a MySQL 8.0 or newer server (our tests show the problem actually began with MySQL 8.0.11). This relates to a PHP bug https://bugs.php.net/bug.php?id=76243. There is a workaround, that is to set your user account to use the current-style password hash method, mysql_native_password. This unfortunate lack of coordination has caused the incompatibility to affect all PHP applications, not just phpMyAdmin. For more details, you can see our bug tracker item at https://github.com/phpmyadmin/phpmyadmin/issues/14220. We suggest upgrading your PHP installation to take advantage of the authentication methods.

Downloads are available now at https://phpmyadmin.net/downloads/

Our work would not be possible without the donations of our generous sponsor, and this release in particular is brought to you thanks to the hard work of our Google Summer of Code students and many other contributors.

For the phpMyAdmin team,
Isaac

Current version compatible with PHP 7.1 and newer and MySQL 5.5 and newer.

phpMyAdmin 4.9.3 Released 2019-12-26.

Welcome to phpMyAdmin 4.9.3, a routine bugfix release.

This is planned as the final bugfix release of phpMyAdmin version 4. Version 4 works with PHP versions 5.5 through (at least) 7.4,
and MySQL versions 5.5 and newer (and the corresponding MariaDB versions). Version 5 will require PHP 7.1 or newer, but
we plan to maintain security fixes for version 4 as part of our LTS program. For end of life details and supported
versions, please see the "Supported versions" grid at .

This release includes fixes for many bugs, including:

* Several PHP notices and warnings including "Undefined index table_create_time,"
  a notice about error_reporting() being disabled for security reasons, and several Undefined Index errors.
* Support CloudFront-Forwarded-Proto header for Amazon CloudFront proxy
* Early compatibility with development versions of PHP 8
* Fix replication actions (start, stop, etc)

There are many, many more bug fixes thanks to the efforts of our developers and other contributors.
For full details, you can see the ChangeLog file included with this release.

The phpMyAdmin team

Older version compatible with PHP 5.5 to 7.4 and MySQL 5.5 and newer. Currently supported for security fixes only.

官网地址: https://www.phpmyadmin.net/

官网更新日志: https://www.phpmyadmin.net/news/

官网软件下载地址:

https://files.phpmyadmin.net/phpMyAdmin/4.9.3/phpMyAdmin-4.9.3-all-languages.zip

https://files.phpmyadmin.net/phpMyAdmin/5.0.0/phpMyAdmin-5.0.0-all-languages.zip

赞(0) 打赏
转载请注明出处:国产吧 » phpMyAdmin v5.0.0/4.9.3 Final 多语言中文正式版-MySQL数据库管理
分享到: 更多 (0)

评论 抢沙发

评论前必须登录!

立即登录   我要注册

如果文章对您有帮助,请打赏一下作者吧,感谢您!

支付宝扫一扫打赏

微信扫一扫打赏

请通过支付宝、微信 APP 扫一扫,海外读者可使用 PayPal 打赏
使用 PayPal 打赏