因专注所以专业
我们一直在努力

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

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

phpMyAdmin v5.0.2/4.9.5 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 4.9.5 and 5.0.2 are released 2020-03-21

Hello,

The phpMyAdmin team announces the release of both 4.9.5 and 5.0.2.

Both versions contain several security fixes:

  • PMASA-2020-2 SQL injection vulnerability in the user accounts page, particularly when changing a password
  • PMASA-2020-3 SQL injection vulnerability relating to the search feature
  • PMASA-2020-4 SQL injection and XSS having to do with displaying results
  • Removing of the “options” field for the external transformation.

We are removing the ability for users to set “options” field for the external transformation. This must now be hard coded in the plugin file directly (where the program is configured). This feature allows users to pipe output directly to an executable file, however the options field presented a security risk and we have decided to move the options to be hard coded in the transformation plugin file. For further assistance, please reach out to our support team through email or Github pull request.

Version 5.0.3 also contains many bug fixes:

  • Fix for copying a user account
  • Removed SET AUTOCOMMIT=0 from SQL export
  • Fix for the display of table borders
  • Fix for ENUM radio button user interface problems
  • Improved the prompt for abandoning changes when no changes were made in the SQL window
  • Fix for inserting a primary key with “insert as new row”
  • Fix incorrect suggested latest available version to version 5

There are many other bugs fixes, please see the ChangeLog file included with this 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.

As a reminder, phpMyAdmin 4.9 is in the long-term support phase where it will only get important security fixes and critical bug fixes. Users are suggested to migrate to version 5.0.

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

For the phpMyAdmin team, Isaac

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.5/phpMyAdmin-4.9.5-all-languages.zip

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

赞(0) 打赏
转载请注明出处:亚洲在线 » phpMyAdmin v5.0.2/4.9.5 Final 多语言中文正式版-MySQL数据库管理
分享到: 更多 (0)

评论 抢沙发

评论前必须登录!

立即登录   我要注册

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

支付宝扫一扫打赏

微信扫一扫打赏

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