金仓KingbaseES数据库安装至Linux系统
<h1>金仓KingbaseES数据库安装至Linux系统</h1><h2>下载</h2>
<p>官网下载</p>
<p>https://www.kingbase.com.cn/download.html#database</p>
<p>或</p>
<p>https://www.kingbase.com.cn/download.html#database_list</p>
<p>注意:此处还能下载180天授权文件</p>
<p>不授权一般来说是试用,长时间使用可以和金仓购买授权.</p>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163749310-530784077.png"></p>
<h2>基本配置</h2>
<h3>创建必备目录</h3>
<p>如果设置的目录不同,在后面的路径配置也要进行更改</p>
<p>mkdir -p /opt/software/ <br>mkdir -p /opt/software/KingbaseESV9 <br>mkdir -p /opt/Kingbase/ES/V9<br>chmod o+rwx /opt/Kingbase/ES/V9</p>
<h3>挂载iso</h3>
<p> iso格式的安装程序包需要先挂载才能使用,需要使用root用户挂载iso文件 </p>
<p>cd /opt/software/<br>mount KingbaseES_V009R003C011B0003_Lin64_install.iso KingbaseESV9/</p>
<h2>创建专属用户</h2>
<p>专门用于处理kingbase的用户,按需求创建</p>
<p>root@192-168-13-5:~# adduser kingbase<br>Adding user `kingbase' ...<br>Adding new group `kingbase' (1000) ...<br>Adding new user `kingbase' (1000) with group `kingbase' ...<br>Creating home directory `/home/kingbase' ...<br>Copying files from `/etc/skel' ...<br>Enter new UNIX password: <br>Retype new UNIX password: <br>Sorry, passwords do not match<br>passwd: Authentication token manipulation error<br>passwd: password unchanged<br>Try again? <br>Changing the user information for kingbase<br>Enter the new value, or press ENTER for the default<br> Full Name []: <br> Room Number []: <br> Work Phone []: <br> Home Phone []: <br> Other []: <br>Is the information correct? Y<br><br></p>
<p>测试</p>
<p>root@192-168-13-5:~# su kingbase<br>kingbase@192-168-13-5:/root$ exit</p>
<h2>安装</h2>
<p>官网操作手册,如果你需要更加详情的配置推荐看官方文档</p>
<p>https://bbs.kingbase.com.cn/docHtml?recId=ef7404928de44316a3e72c84e64af712&url=aHR0cHM6Ly9iYnMua2luZ2Jhc2UuY29tLmNuL2tpbmdiYXNlLWRvYy92OS4zLjExL2ludHJvL3JlbGVhc2Vub3Rlcy1leHRlcm5hbC12OS9pbmRleC5odG1s</p>
<p> 先切换到kingbase用户，然后执行命令进行安装 </p>
<p># 切换到kingbase用户<br>su kingbase<br># 启动安装<br>cd /opt/software/KingbaseESV9<br>sh setup.sh -i console</p>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163749317-2137473155.png"></p>
<p>大约8次确认后会出现同意协议的确认步骤:</p>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163749194-461540608.png"></p>
<p>输入Y后回车确认</p>
<h3>选择安装集</h3>
<p> 选择安装集，这里以完整版为例，输入1回车。 </p>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163749199-1050439517.png"></p>
<h3>选择授权文件</h3>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163749206-907742270.png"></p>
<p>有的话输入,没有的话为空跳过</p>
<h3>选择安装路径</h3>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163749230-295373377.png"></p>
<p>可以看到,默认安装路径为/optKingbase/ES/V9</p>
<p>可以填入绝对路径进行更换,或者为空保持默认路径</p>
<h3>安装配置汇总</h3>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163748691-459464794.png"></p>
<p>回车继续</p>
<h3>再次确认</h3>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163748678-1571445191.png"></p>
<p>之后会进入安装读条,等待1分钟</p>
<h3>选择数据存储路径</h3>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163748716-1299644992.png"></p>
<p>选择一个文件夹,必须为空文件夹,默认为opt/Kingbase/ES/V9/data</p>
<p>使用默认或者填入后回车继续</p>
<h3>指定监听端口</h3>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163748650-161346470.png"></p>
<h3>设置数据库管理员用户名密码</h3>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163749194-646846551.png"></p>
<p>默认用户名为system</p>
<p>密码必填</p>
<p>会确认密码</p>
<h3>选择服务器编码</h3>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163749221-1176322456.png"></p>
<p>设置服务器编码和本地编码</p>
<p>如果报错:</p>
<p>Locale net supported by the OS,please select another one.</p>
<p>意思为本地不支持所选语言(中文),请换一个,改为3 英文(输入3回车)</p>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163749213-1322395389.png"></p>
<h3>选择数据库模式</h3>
<h3>大小写是否敏感</h3>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163748802-651348132.png"></p>
<h3>设置块大小</h3>
<h3>选择认证方法</h3>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163749246-1072133878.png"></p>
<h3>设置自定义参数</h3>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163748815-1206227779.png"></p>
<p>回车跳过</p>
<h3>确认开始安装</h3>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163749226-2063506054.png"></p>
<p>等待大概几十秒</p>
<h3>安装完成</h3>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163749217-1864705271.png"></p>
<p>列出了安装位置和注册服务的命令</p>
<p>回车退出安装</p>
<h4>注册系统服务</h4>
<p>切换回root用户注册服务</p>
<p>exit<br>或者<br>sudo root<br><br>#执行<br>/opt/Kingbase/ES/V9/install/script/root.sh</p>
<h4>服务启动/关闭控制</h4>
<p># 查询状态<br>sudo service kingbased status<br><br># 启动服务<br>sudo service kingbased start<br><br># 停止服务<br>sudo service kingbased stop<br><br># 重启服务<br>sudo service kingbased restart<br><br></p>
<p>查看服务状态</p>
<p><img src="https://img2024.cnblogs.com/blog/3575900/202512/3575900-20251201163749499-244995114.png"></p>
<h2>测试</h2>
<p>/opt/Kingbase/ES/V9/ClientTools/bin/ksql -U system -d test -h 127.0.0.1</p>
<p>注意system是用户名 test是数据库名称</p>
<h2>取消挂载</h2>
<p>安装完成后可以取消挂载</p>
<p> umount /opt/software/KingbaseESV9</p>
<h2>查看金仓数据库</h2>
<p>下载数据库连接工具</p>
<p>(其他能连的也行)</p>
<p>https://www.kingbase.com.cn/download.html#tool</p><br><br>
来源：https://www.cnblogs.com/fffffff/p/19293410
頁:
[1]