CentOS下MySQL安装详细步骤
<p>首先通过网络链接的方式在线安装上mysql服务器端吧！（备注：我开始登录服务器的时候是用的其他用户而不是超级管理员，所以安装MySQL的时候需要切换到超级管理员才可以实现软件的正确安装。命令则是：su root ，然后输入你的超级管理员密码即可登录到超级管理员终端。）</p>
<p>
<strong>第一步，安装MySQL。</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_824621">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># yum install mysql-server</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
静待终端提示：Complete！期间程序会询问提示：Is This ok ：你知道的这个应该是要输y的。</p>
<p>
<strong>第二步，让MYSQL随系统自动启动。</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_329017">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># chkconfig –levels 235 mysqld on</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain"></code><code class="bash comments"># /etc/init.d/mysqld start</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<strong>第三步，设置MySQL的用户名和密码。</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_623362">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments">#mysql_secure_installation</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
这样只要看懂一点英文知识的就可以看懂Mysql的数据信息设置了。</p>
<p>
然后就是用设置的密码测试下MYSQL安装的问题了。# mysql -u root -p 然后回车进入mysql>命令行中，增加一个和数据库管理用户吧！</p>
<p>
首先切换到root权限，编辑配置MySQL文件 ，利用vim命令中的插入命令i命令和ESC+:wq命令。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_660644">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments">#vim /etc/my.cnf ← 编辑MySQL的配置文件</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain"></code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">datadir=</code><code class="bash plain">/var/lib/mysql</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">socket=</code><code class="bash plain">/var/lib/mysql/mysql</code><code class="bash plain">.sock</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">old_passwords=1 ←找到这一行在这一行加入新的规则，让MySQL的默认编码为UTF-8</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">default-character-</code><code class="bash functions">set</code> <code class="bash plain">= utf8 ← 添加这一行代码</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain"></code><code class="bash comments"># chkconfig mysqld on ←改变指定服务mysqld的启动信息，on和off分别指定服务的开始和停止。</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain"></code><code class="bash comments"># chkconfig – -list mysqld ←列出系统mysqld的启动信息，如果2～5的状态为启动就OK。</code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">mysqld 0:关闭 1:关闭 2:启用 3:启用 4:启用 5:启用 6:关闭</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash plain"></code><code class="bash comments"># /etc/rc.d/init.d/mysqld start ←启动Mysql系统服务</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
正在启动 mysqld： [确定]</p>
<p>
好了，自此系统的MySQL服务设置成功启动了。</p>
<p>
<span><strong>下面开始设置数据库的用户密码。</strong></span></p>
<p>
1、先进入数据库（以超级管理员的用户名和密码mysql -u root，数据库安装默认的密码是空的。）：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_590978">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain"># mysql -u root</code>
</div>
<div class="line number2 index1 alt1">
<code class="sql plain">mysql> </code><code class="sql keyword">select</code> <code class="sql plain">Host,</code><code class="sql color2">User</code><code class="sql plain">,</code><code class="sql keyword">Password</code> <code class="sql keyword">from</code> <code class="sql plain">mysql.</code><code class="sql color2">user</code><code class="sql plain">; ←查询已经存在的数据库用户名和密码</code>
</div>
<div class="line number3 index2 alt2">
<code class="sql plain">+—————–+——+———-+</code>
</div>
<div class="line number4 index3 alt1">
<code class="sql plain">| Host | </code><code class="sql color2">User</code> <code class="sql plain">| </code><code class="sql keyword">Password</code> <code class="sql plain">|</code>
</div>
<div class="line number5 index4 alt2">
<code class="sql plain">+—————–+——+———-+</code>
</div>
<div class="line number6 index5 alt1">
<code class="sql plain">| localhost | root | |</code>
</div>
<div class="line number7 index6 alt2">
<code class="sql plain">| ywm.localdomain | root | |</code>
</div>
<div class="line number8 index7 alt1">
<code class="sql plain">| 127.0.0.1 | root | |</code>
</div>
<div class="line number9 index8 alt2">
<code class="sql plain">| localhost | | |</code>
</div>
<div class="line number10 index9 alt1">
<code class="sql plain">| ywm.localdomain | | |</code>
</div>
<div class="line number11 index10 alt2">
<code class="sql plain">+—————–+——+———-+</code>
</div>
<div class="line number12 index11 alt1">
<code class="sql spaces"> </code><code class="sql keyword">rows</code> <code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec)</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
2、通过数据库编程修改数据库用户名的密码，超级管理员root。此处需要修改两个位置的用户名密码：@localhost和@ywm.localdomain（主机安装的命名），密码需要用password(‘设置的新密码')设置添加到对应的数据表中。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_422980">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">mysql> </code><code class="bash functions">set</code> <code class="bash plain">password </code><code class="bash keyword">for</code> <code class="bash plain">root@localhost = password(‘sniper');</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">Query OK, 0 rows affected (0.00 sec)</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">mysql> </code><code class="bash functions">set</code> <code class="bash plain">password </code><code class="bash keyword">for</code> <code class="bash plain">root@ywm.localdomain = password(‘sniper');</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">Query OK, 0 rows affected (0.00 sec)</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
3、退出数据库设置的命令。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_598555">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">mysql> exit</code>
</div>
<div class="line number2 index1 alt1">
<code class="sql plain">Bye</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<span><strong>检测数据库中密码是否修改正确。</strong></span></p>
<p>
1、使用默认密码为空的登录数据库测试一下。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_444414">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># mysql -u root</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">ERROR 1045 (28000): Access denied </code><code class="bash keyword">for</code> <code class="bash plain">user ‘root</code><code class="bash string">'@'</code><code class="bash plain">localhost' (using password: NO)</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
2、使用已经设置修改的密码登录数据库测试一下。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_867495">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># mysql -u root -p</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">Enter password:</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">mysql></code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
成功登录数据库。</p>
<p>
原文链接：http://www.cnblogs.com/LaTaBaBa/archive/2016/11/08/6042388.html</p>
頁:
[1]