怎样查看mysql版本的五种方法

查看版本信息 #1使用命令行模式进入mysql会看到最开始的提示符 Your MySQL connection id is 3 Server version: 5.1.69 Source distribution #2命令行中使用status可以看到 复制代码 代码如下:mysql>status-------------- mysql Ver 14.14 Distrib 5.1.69, for redhat-linux-gnu (x86_64) using readline 5.1 Connection id:3 Current database: Current user: root@localhost SSL: Not in use Current pager:stdout Using outfile:'' Using delimiter:Server version:5.1.69 Source distribution Protocol version:10 Connection: Localhost via UNIX socket Server characterset:utf8 Db characterset:utf8 Client characterset:utf8 Conn. characterset:utf8 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 3 days 14 hours 50 sec Threads: 1 Questions: 5 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.0 #3 使用系统函数 复制代码 代码如下:mysql>select version()+-----------+ | version() | +-----------+ | 5.1.69 | +-----------+ 1 row in set (0.12 sec) #4 $ mysql --help | grep Distrib mysql Ver 14.14 Distrib 5.1.69, for redhat-linux-gnu (x86_64) using readline 5.1 #5 包管理工具（根据不同系统 rh系列或则是bsd系列） $ rpm -qa|grep mysql qt-mysql-4.6.2-20.el6.x86_64 mysql-server-5.1.69-1.el6_4.x86_64 mysql-libs-5.1.69-1.el6_4.x86_64 mysql-5.1.69-1.el6_4.x86_64 mysql-devel-5.1.69-1.el6_4.x86_64

hpMyAdmin功能：

phpMyAdmin可以管理整个MySQL服务器(需要超级用户)，也可以管理单个数据库。为了实现后一种，你将需要合理设置MySQL用户，他只能对允许的数据库进行读/写。那要等到你看过MySQL手册中相关的部分。

phpMyAdmin安装教程

1.下载多国语言包

解压好后更名为 phpmyadmin 注意全是小写的,把它放在 \文件夹\htdocs下

2.将config.sample.inc.php 更名为 config.inc.php

3,配制 config.inc.php

修改 $cfg['Servers'][$i]['controluser'] 把前面的 //去掉,在后面写上数据库名字 如 'root'

$cfg['Servers'][$i]['controlpass'] 把前面的// 去掉,在后面写上数据库密码,如'123'

修改$cfg['blowfish_secret'] = '' 在后面'' 里面随便填上几个数字 '456'

4. 配制服务器的php.ini

将php下的 libmcrypt.dll 复制到 C:\WINDOWS\system32

修改php.ini

将 extension=php_mcrypt.dll前的去掉

5,重启apache即可

安装过程

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

更新日志

phpMyAdmin V4.5.1

- issue Invalid argument supplied for foreach()

- issue array_key_exists() expects parameter 2 to be array

- issue #11480 Notice Undefined index: drop_database

- issue #11486 Server variable edition in ANSI_QUOTES sql_mode: losing current value

- issue #11491 Propose table structure broken

- issue #11464 phpMyAdmin suggests upgrading to newer version not usable on that system

- issue #11495 'PMA_Microhistory' is undefined

- issue #11496 Incorrect definition for getTablesWhenOpen()

- issue #11500 Error when creating new user on MariaDB 10.0.21

- issue #11505 Notice on htmlspecialchars()

- issue Notice in Structure page of views

- issue #11510 AUTO_INCREMENT always exported when IF NOT EXISTS is on

- issue #11516 Some partitions are missing in copied table

- issue #11521 Notice of undefined variable when performing SHOW CREATE

- issue #11509 Error exporting sql query results with table alias

- issue #11512 SQL editing window does not recognise 'OUTER' keyword in 'LEFT OUTER JOIN'

- issue #11518 "NOT IN" clause not recognized (MySQL 5.6 and 5.7)

- issue #11524 Yellow star does not change in database Structure after add/remove from favorites

- issue #11531 Invalid SQL in table definition when exporting table

- issue #11526 Foreign key to other database's tables fails

- issue #11519 Bug while exporting results when a joined table field name is in SELECT query

- issue #11522 Strange behavior on table rename

- issue #11539 Rename table does not result in refresh in left panel

- issue #11541 Missing arguments for PMA_Table::generateAlter()

- issue #11544 Notices about undefined indexes on structure pages of information_schema tables

- issue Change minimum PHP version for Composer

- issue #11542 Import parser and backslash

- issue #11546 "Visualize GIS data" seems to be broken

- issue #11548 Confirm box on "Reset slave" option

- issue Fix cookies clearing on version change

- issue #11558 Cannot execute SQL with subquery

- issue #11520 Incorrect syntax creating a user using mysql_native_password with MariaDB

- issue #11561 Cannot use third party auth plugins

phpMyAdmin 4.3.11 更新日志

# SQL链接错误4774是完全错误的

错误4768：# MariaDB版本不匹配

错误4777缺少#一些图像设计师原创主题

错误4767：在细雨# mysql_charsets.inc.php未定义的索引

错误4753正常场#和多线领域有不同的利润率

错误4760不能重新导入设置#从本地存储

错误4778 SQL数据库列表时出错#通过附加的列进行排序

错误4780注意#时间戳列没有默认值

phpMyAdmin V4.4.6.1 Final

[安全] CSRF漏洞安装

[安全]漏洞允许中间人攻击

phpMyAdmin V4.5.5 更新内容：

Fixes include improvements to changing passwords on newer MariaDB servers and several fixes to the SQL parser which will resolve some errors users encountered entering commands in the SQL tab.

---