Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search
Copy Page
You are not logged in. Any changes you make will be marked as
anonymous
. You may want to
Log In
if you already have an account. You can also
Sign Up
for a new account.
This page is being edited by
.
image-effects
image-attributes
search
attachments
weblink
advanced
Paragraph
Paragraph
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
Preformatted
Quote
Bold
Italic
Underline
Colour picker
More colours
Formatting
Strikethrough
Subscript
Superscript
Monospace
Clear Formatting
Bullet list
Numbered list
Task list
Outdent
Indent
Align left
Align center
Align right
Link
Table
Insert
Insert Content
Image
Link
Attachment
Symbol
Emoticon
Wiki Markup
Horizontal rule
Task List
Insert Macro
User Mention
Info
JIRA Issue
Gliffy Diagram
Status
Gallery
Table of Contents
Other Macros
Page Layout
No Layout
Two column (simple)
Two column (simple, left sidebar)
Two column (simple, right sidebar)
Three column (simple)
Two column
Two column (left sidebar)
Two column (right sidebar)
Three column
Three column (left and right sidebars)
Undo
Redo
Find/Replace
Keyboard Shortcuts Help
Hide the toolbars
Launch editor full screen
<p><span style="color: rgb(0,0,0);"><img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3RvY30&locale=en_GB&version=2" data-macro-name="toc"><br /></span></p><p>若刚开始没有选择预载之用户,可以参考以下的步骤进行安装,由於32bit及64bit的安装过程有些许差异,故分开描述。</p><h4>SmartOS 32bit安装步骤</h4><p>1.请先搜寻MySQL的套件,并找到mysql-server最高版本</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># pkgin se mysql</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245446/p1.png?version=1&modificationDate=1713623738824&api=v2" data-image-src="/download/attachments/3245446/p1.png?version=1&modificationDate=1713623738824&api=v2" data-linked-resource-id="3219030" data-linked-resource-type="attachment" data-linked-resource-default-alias="p1.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > p1.png" data-location="null > p1.png"></p><p><span style="line-height: 1.4285715;"><br /></span>2.安装MySQL</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># pkgin in mysql-server-5.5.16nb1</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245446/p2.png?version=1&modificationDate=1713623738825&api=v2" data-image-src="/download/attachments/3245446/p2.png?version=1&modificationDate=1713623738825&api=v2" data-linked-resource-id="3219031" data-linked-resource-type="attachment" data-linked-resource-default-alias="p2.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > p2.png" data-location="null > p2.png"></p><p><span style="line-height: 1.4285715;"><br /></span>3.安装完成後,请先找到mysql.xml,并修改此档。</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># find / -name mysql.xml</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245446/p3.png?version=1&modificationDate=1713623738826&api=v2" data-image-src="/download/attachments/3245446/p3.png?version=1&modificationDate=1713623738826&api=v2" data-linked-resource-id="3219032" data-linked-resource-type="attachment" data-linked-resource-default-alias="p3.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > p3.png" data-location="null > p3.png"></p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># vi /opt/local/share/smf/manifest/mysq l.xml</pre></th></tr></tbody></table><p>进入编辑画面后, 请将下图中这二个参数路径改为/opt/local/share/smf/method/svc-mysql,指令如下</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre><exec_method name='start' type='method' exec='/opt/local/share/smf/method/svc-mysql start' timeout_seconds='18446744073709551615'/> <exec_method name='stop' type='method' exec='/opt/local/share/smf/method/svc-mysql stop' timeout_seconds='18446744073709551615'/></pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245446/p8.png?version=1&modificationDate=1713623738815&api=v2" data-image-src="/download/attachments/3245446/p8.png?version=1&modificationDate=1713623738815&api=v2" data-linked-resource-id="3219023" data-linked-resource-type="attachment" data-linked-resource-default-alias="p8.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > p8.png" data-location="null > p8.png"></p><p><span style="line-height: 1.4285715;"><br /></span>4.将mysql.xml汇入smf中</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># svccfg import /opt/local/share/smf/manifest/mysql.xml</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245446/p5.png?version=1&modificationDate=1713623738809&api=v2" data-image-src="/download/attachments/3245446/p5.png?version=1&modificationDate=1713623738809&api=v2" data-linked-resource-id="3219018" data-linked-resource-type="attachment" data-linked-resource-default-alias="p5.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > p5.png" data-location="null > p5.png"></p><p><span style="line-height: 1.4285715;"><br /></span>5.先关闭后再重新启动MySQL服务</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># svcadm disable mysql # svcadm enable mysql</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245446/p6.png?version=1&modificationDate=1713623738812&api=v2" data-image-src="/download/attachments/3245446/p6.png?version=1&modificationDate=1713623738812&api=v2" data-linked-resource-id="3219020" data-linked-resource-type="attachment" data-linked-resource-default-alias="p6.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > p6.png" data-location="null > p6.png"></p><p><span style="line-height: 1.4285715;"><br /></span>6.检视服务是否启动</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># svcs mysql</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245446/p7.png?version=1&modificationDate=1713623738814&api=v2" data-image-src="/download/attachments/3245446/p7.png?version=1&modificationDate=1713623738814&api=v2" data-linked-resource-id="3219022" data-linked-resource-type="attachment" data-linked-resource-default-alias="p7.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > p7.png" data-location="null > p7.png"></p><p><span style="line-height: 1.4285715;"><br /></span>7.设置MySQL登入密码,密码可自订,这里举例为1qaz</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># mysqladmin -u root password 1qaz</pre></th></tr></tbody></table><p> </p><p>8.连线至MySQL</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># mysql -uroot -p</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245446/p4.png?version=1&modificationDate=1713623738828&api=v2" data-image-src="/download/attachments/3245446/p4.png?version=1&modificationDate=1713623738828&api=v2" data-linked-resource-id="3219034" data-linked-resource-type="attachment" data-linked-resource-default-alias="p4.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > p4.png" data-location="null > p4.png"></p><p><br /><br /></p><h4>SmartOS 64bit安装步骤</h4><p>1.请先搜寻MySQL的套件</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># pkgin se mysql</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245446/p61.png?version=1&modificationDate=1713623738818&api=v2" data-image-src="/download/attachments/3245446/p61.png?version=1&modificationDate=1713623738818&api=v2" data-linked-resource-id="3219025" data-linked-resource-type="attachment" data-linked-resource-default-alias="p61.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > p61.png" data-location="null > p61.png"></p><p><span style="line-height: 1.4285715;"><br /></span>2.以安装5.1.58为例</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># pkgin in mysql-server-5.1.58</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245446/p62.png?version=1&modificationDate=1713623738819&api=v2" data-image-src="/download/attachments/3245446/p62.png?version=1&modificationDate=1713623738819&api=v2" data-linked-resource-id="3219026" data-linked-resource-type="attachment" data-linked-resource-default-alias="p62.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > p62.png" data-location="null > p62.png"></p><p><span style="line-height: 1.4285715;"><br /></span>3.先关闭后再启动MySQL服务</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># svcadm disable mysql # svcadm enable mysql</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245446/p6%20%281%29.png?version=1&modificationDate=1713623738811&api=v2" data-image-src="/download/attachments/3245446/p6%20%281%29.png?version=1&modificationDate=1713623738811&api=v2" data-linked-resource-id="3219019" data-linked-resource-type="attachment" data-linked-resource-default-alias="p6 (1).png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > p6 (1).png" data-location="null > p6 (1).png"></p><p><span style="line-height: 1.4285715;"><br /></span>4.检视服务是否启动</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># svcs mysql</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245446/p7%20%281%29.png?version=1&modificationDate=1713623738813&api=v2" data-image-src="/download/attachments/3245446/p7%20%281%29.png?version=1&modificationDate=1713623738813&api=v2" data-linked-resource-id="3219021" data-linked-resource-type="attachment" data-linked-resource-default-alias="p7 (1).png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > p7 (1).png" data-location="null > p7 (1).png"></p><p><span style="line-height: 1.4285715;"><br /></span>5.设置MySQL登入密码,密码可自订,这里举例为1qaz</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># mysqladmin -u root password 1qaz</pre></th></tr></tbody></table><p> </p><p>6.连线至MySQL</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># mysql -uroot -p</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245446/p4%20%281%29.png?version=1&modificationDate=1713623738827&api=v2" data-image-src="/download/attachments/3245446/p4%20%281%29.png?version=1&modificationDate=1713623738827&api=v2" data-linked-resource-id="3219033" data-linked-resource-type="attachment" data-linked-resource-default-alias="p4 (1).png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > p4 (1).png" data-location="null > p4 (1).png"></p><p><span style="line-height: 1.4285715;"><br /></span>7.外部连线设定</p><p>因为SmartOS 64因安全性考量,目前服务安装完成后预设IP是binding 127.0.0.1,所以3306 port服务外部不能连线,可以透过更新MySQL设定来开放外部连线:</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># vi /opt/local/etc/my.cnf</pre></th></tr></tbody></table><p><span style="color: rgb(0,0,0);line-height: 1.4285715;">修改下方紅色框部份</span></p><p><span style="line-height: 1.4285715;"><img class="confluence-embedded-image" src="/download/attachments/3245446/set.png?version=1&modificationDate=1713623738822&api=v2" data-image-src="/download/attachments/3245446/set.png?version=1&modificationDate=1713623738822&api=v2" data-linked-resource-id="3219029" data-linked-resource-type="attachment" data-linked-resource-default-alias="set.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > set.png" data-location="null > set.png"><br /></span>关闭服务,再重新啓动,连线设定即完成</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># svcadm disable mysql # svcadm enable mysql</pre></th></tr></tbody></table><p> </p><hr /><h4>重设root密码</h4><p>若您忘记MySQL的root密码,可以用以下的方式重设密码<br />1.请先将Mysql服务停止</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># svcadm disable mysql</pre></th></tr></tbody></table><p> </p><p>2.在/home/admin下建立一个档案名称为reset-mysql-root-password-init,并在档案内加入密码设定指令</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#vi /home/admin/reset-mysql-root-password-init</pre></th></tr></tbody></table><p> </p><p>在档案中加入下方指令。(密码您可以自行输入,这里以1234为范例)</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>UPDATE mysql.user SET Password=PASSWORD('1234') WHERE User='root'; FLUSH PRIVILEGES;</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245446/p63.png?version=1&modificationDate=1713623738820&api=v2" data-image-src="/download/attachments/3245446/p63.png?version=1&modificationDate=1713623738820&api=v2" data-linked-resource-id="3219027" data-linked-resource-type="attachment" data-linked-resource-default-alias="p63.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > p63.png" data-location="null > p63.png"></p><p><span style="line-height: 1.4285715;"><br /></span>3.使用特殊的MySQL伺服器 - 初始化文件选项</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># /opt/local/bin/mysqld_safe --init-file=/home/admin/reset-mysql-root-password-init &</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245446/p64.png?version=1&modificationDate=1713623738821&api=v2" data-image-src="/download/attachments/3245446/p64.png?version=1&modificationDate=1713623738821&api=v2" data-linked-resource-id="3219028" data-linked-resource-type="attachment" data-linked-resource-default-alias="p64.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > p64.png" data-location="null > p64.png"></p><p><span style="line-height: 1.4285715;"><br /></span>4.关闭MySQL</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># svcadm disable network/mysql</pre></th></tr></tbody></table><p> </p><p>5.删除创建的文件:</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># rm /home/admin/reset-mysql-root-password-init</pre></th></tr></tbody></table><p> </p><p>6.重新启动MySQL服务:</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># svcadm enable network/mysql</pre></th></tr></tbody></table><p> </p><p>7.验证密码是否已更改</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># mysql -uroot -p</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245446/p11.png?version=1&modificationDate=1713623738816&api=v2" data-image-src="/download/attachments/3245446/p11.png?version=1&modificationDate=1713623738816&api=v2" data-linked-resource-id="3219024" data-linked-resource-type="attachment" data-linked-resource-default-alias="p11.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245446" title="null > p11.png" data-location="null > p11.png"></p><p> </p>
Attachments
Labels
Location
Edit
Preview
Save
Cancel
Next hint