大网数据广告活动
服务器运维问答

How can I tell if I have community, enterprise, or standard edition mysql?

· 52CE 我爱测

We are in the process of upgrading our servers and I was asked about the version of mysql we have currently (as we would like to stick with the same type, just upgrade the version). I need to know which edition I have installed. …

问题原文

原帖链接 · AllisonC · CC BY-SA 3.0

We are in the process of upgrading our servers and I was asked about the version of mysql we have currently (as we would like to stick with the same type, just upgrade the version). I need to know which edition I have installed. Here's the information I got when I ran SHOW VARIABLES;

protocol_version    10
version 5.0.67
version_comment SUSE MySQL RPM
version_compile_machine x86_64
version_compile_os  suse-linux-gnu

EDIT I also found the license in the variables, which says GPL

已采纳解答

原帖链接 · Esa Jokinen · CC BY-SA 3.0

Normally, the version and version_comment would have this information, and STATUS command would also show them combined in Server version:, e.g.

Server version:         5.0.67-standard MySQL Community Edition - Standard     (GPL)

However, you are using version that comes from SUSE RPM repository; it's community edition.

You could check that with (shell, not SQL) command rpm -q mysql. The name of the package might actually contain mysqlXX-community-release-... to confirm that.

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2017-08-10)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。