hrtsea.cc
点亮未来,见证精彩

phpMyAdmin v5.1.0 Snapshot 2020-01-08 + v5.0.1 + v4.9.4 Final

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

当前出现很多 GUI MySQL客户程序,其中最为出色的是基于 Web 的 phpMyAdmin 工具。这是一种 MySQL 数据库前台的基于PHP的工具。

PhpMyAdmin 的缺点是必须安装在 Web 服务器中,所以如果没有合适的访问权限,其它用户有可能损害到 SQL 数据。

更新日志

v5.0.0 (2019-12-26):
– 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

v4.9.3 (2019-12-26):
– 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)

v4.9.2 (2019-11-22):
– Fixes for the “Failed to set session cookie” error which relates to the cookie name. In some cases, data stored in the cookie (such as the previously-used user account) may not be loaded from a previous phpMyAdmin cookie the first time you run version 4.9.2
– Fix for Advisor with MySQL 8.0.3 and newer
– Fix PHP deprecation errors
– Fix a situation where exporting users after a delete query could remove users
– Fix incorrect “You do not have privileges to manipulate with the users!” warning
– Fix copying a database’s privileges and several other problems moving columns with MariaDB
– Fix for phpMyAdmin not selecting all the values when using shift-click to select during Export

官网 http://www.phpmyadmin.net

官方下载
https://files.phpmyadmin.net/snapshots/phpMyAdmin-5.1+snapshot-all-languages.zip
https://files.phpmyadmin.net/phpMyAdmin/5.0.1/phpMyAdmin-5.0.1-all-languages.zip
https://files.phpmyadmin.net/phpMyAdmin/4.9.4/phpMyAdmin-4.9.4-all-languages.zip

安装过程

PhpMyAdmin安装包下载安装

解压
将下载文件解压缩到 WEB 访问路径下。文件目录如phpmyadmin。

配置文件
然后配置目录下libraries文件下的 config.default.php 文件。
$cfg[‘PmaAbsoluteUri’] = ‘http://localhost/phpmyadmin’;
$cfg[‘blowfish_secret’] = ‘123456’;
$cfg[‘DefaultLang’] = ‘zh-gb2312’;
$cfg[‘DefaultCharset’] = ‘gb2312’;
$cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
保存之后,在浏览器里输入:http://localhost/phpmyadmin/user_password.php

赞(4) 打赏
允许疯狂转载:心海e站 » phpMyAdmin v5.1.0 Snapshot 2020-01-08 + v5.0.1 + v4.9.4 Final
分享到: 更多 (0)

评论 抢沙发

评论前必须登录!

 

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏