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><img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3RvY30&locale=en_GB&version=2" data-macro-name="toc"></p><p>依下达的指令不同,各作业系统的安装说明如下:</p><h4>CentOS、Fedora 安裝MySQL</h4><p><span style="color: rgb(0,0,0);">1.请使用yum安裝</span></p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#yum install mysql-server</pre></th></tr></tbody></table><p><span style="color: rgb(0,0,0);"><img class="confluence-embedded-image" src="/download/attachments/3245386/p1.png?version=1&modificationDate=1711707091740&api=v2" data-image-src="/download/attachments/3245386/p1.png?version=1&modificationDate=1711707091740&api=v2" data-linked-resource-id="3218685" data-linked-resource-type="attachment" data-linked-resource-default-alias="p1.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245386" title="null > p1.png" data-location="null > p1.png"><br /></span></p><p><span style="line-height: 1.4285715;"><br /></span>2.启动MySQL服务</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#service mysqld start</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245386/p2.png?version=1&modificationDate=1711707091742&api=v2" data-image-src="/download/attachments/3245386/p2.png?version=1&modificationDate=1711707091742&api=v2" data-linked-resource-id="3218686" data-linked-resource-type="attachment" data-linked-resource-default-alias="p2.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245386" title="null > p2.png" data-location="null > p2.png"></p><p><span style="line-height: 1.4285715;"><br /></span>3.设置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>4.连线至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/3245386/p4.png?version=1&modificationDate=1711707091744&api=v2" data-image-src="/download/attachments/3245386/p4.png?version=1&modificationDate=1711707091744&api=v2" data-linked-resource-id="3218688" data-linked-resource-type="attachment" data-linked-resource-default-alias="p4.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245386" title="null > p4.png" data-location="null > p4.png"></p><p> </p><h4>Ubuntu、Debian 安裝MySQL</h4><p>1.请使用apt-get安装MySQL</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#apgt-get install mysql-server</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245386/p4%20%281%29.png?version=1&modificationDate=1711707091743&api=v2" data-image-src="/download/attachments/3245386/p4%20%281%29.png?version=1&modificationDate=1711707091743&api=v2" data-linked-resource-id="3218687" 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="3245386" title="null > p4 (1).png" data-location="null > p4 (1).png"></p><p><span style="line-height: 1.4285715;"><br /></span>2.启动MySQL服务</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#service mysql start</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245386/p6.png?version=1&modificationDate=1711707091747&api=v2" data-image-src="/download/attachments/3245386/p6.png?version=1&modificationDate=1711707091747&api=v2" data-linked-resource-id="3218690" data-linked-resource-type="attachment" data-linked-resource-default-alias="p6.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245386" title="null > p6.png" data-location="null > p6.png"></p><p><span style="line-height: 1.4285715;"><br /></span>3.设置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>4.连线至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/3245386/p4.png?version=1&modificationDate=1711707091744&api=v2" data-image-src="/download/attachments/3245386/p4.png?version=1&modificationDate=1711707091744&api=v2" data-linked-resource-id="3218688" data-linked-resource-type="attachment" data-linked-resource-default-alias="p4.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245386" title="null > p4.png" data-location="null > p4.png"></p><p> </p><hr style="line-height: 1.4285715;" /><h4>重设root密码</h4><p>若您忘记MySQL的root密码,可以用以下的方式重设密码:</p><p>1.请先将MySQL服务停止</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#service mysqld stop</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245386/p7.png?version=1&modificationDate=1711707091748&api=v2" data-image-src="/download/attachments/3245386/p7.png?version=1&modificationDate=1711707091748&api=v2" data-linked-resource-id="3218691" data-linked-resource-type="attachment" data-linked-resource-default-alias="p7.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245386" title="null > p7.png" data-location="null > p7.png"></p><p><span style="line-height: 1.4285715;"><br /></span>2.以不检查密码的方式启动MySQL</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#mysqld_safe --skip-grant-tables&</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245386/p8.png?version=1&modificationDate=1711707091749&api=v2" data-image-src="/download/attachments/3245386/p8.png?version=1&modificationDate=1711707091749&api=v2" data-linked-resource-id="3218692" data-linked-resource-type="attachment" data-linked-resource-default-alias="p8.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245386" title="null > p8.png" data-location="null > p8.png"></p><p><span style="line-height: 1.4285715;"><br />3.登入MySQL</span></p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#mysql</pre></th></tr></tbody></table><p> </p><p>4.将root密码重新设定为1234</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>mysql>update mysql.user set password=PASSWORD('1234') where user='root';</pre></th></tr></tbody></table><p> </p><p>5.执行上一个步骤所下达的密码设定指令</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>mysql> flush privileges;</pre></th></tr></tbody></table><p> </p><p>6.退出MySQL</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>mysql> quit</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245386/p9.png?version=1&modificationDate=1711707091750&api=v2" data-image-src="/download/attachments/3245386/p9.png?version=1&modificationDate=1711707091750&api=v2" data-linked-resource-id="3218693" data-linked-resource-type="attachment" data-linked-resource-default-alias="p9.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245386" title="null > p9.png" data-location="null > p9.png"></p><p><span style="line-height: 1.4285715;"><br /></span>7.重新启动MySQL</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#service mysqld restart</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245386/p10.png?version=1&modificationDate=1711707091752&api=v2" data-image-src="/download/attachments/3245386/p10.png?version=1&modificationDate=1711707091752&api=v2" data-linked-resource-id="3218694" data-linked-resource-type="attachment" data-linked-resource-default-alias="p10.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245386" title="null > p10.png" data-location="null > p10.png"></p><p><span style="line-height: 1.4285715;"><br /></span>8.验证密码是否已更改</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/3245386/p11.png?version=1&modificationDate=1711707091753&api=v2" data-image-src="/download/attachments/3245386/p11.png?version=1&modificationDate=1711707091753&api=v2" data-linked-resource-id="3218695" data-linked-resource-type="attachment" data-linked-resource-default-alias="p11.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245386" title="null > p11.png" data-location="null > p11.png"></p><p><br /><br /></p>
Attachments
Labels
Location
Edit
Preview
Save
Cancel
Next hint