CentOS Yum编译安装MySQL 5.6

陈庸玖 發表於 2023-7-14 00:00:00

<p>
本文实例为大家分享了<strong>centos yum安装mysql 5.6</strong>的具体代码，供大家参考，具体内容如下</p>
<p>
1.检查系统是否安装其他版本的MYSQL数据</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_529584">
<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 comments">#yum list installed | grep mysql</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash comments">#yum -y remove mysql-libs.x86_64</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_345606">
<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 comments"># wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash comments"># rpm -ivh mysql-community-release-el6-5.noarch.rpm</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash comments"># yum repolist all | grep 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>
安装MYSQL数据库</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_584152">
<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 comments"># yum install mysql-community-server -y</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、3、4都是on代表开机自动启动)</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_726866">
<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 comments"># chkconfig --list | grep mysqld</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash comments"># chkconfig mysqld on</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.设置远程root</p>
<p>
启动mysql</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_332021">
<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 comments"># service 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>
设置root密码</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_821408">
<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 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>
登陆root账号</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_340575">
<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 comments"># mysql -uroot -p </code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
建立远程root用户</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_922530">
<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">mysql> GRANT ALL PRIVILEGES ON *.* TO </code><code class="bash string">'root'</code><code class="bash plain">@</code><code class="bash string">'%'</code> <code class="bash plain">IDENTIFIED BY </code><code class="bash string">'你设置的密码'</code> <code class="bash plain">WITH GRANT OPTION;</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">mysql> flush privileges;</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>

<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
4.设置utf-8编码</p>
<p>
查看mysql原本编码：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_54132">
<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">mysql> show variables like </code><code class="bash string">'character%'</code><code class="bash plain">;</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>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_428868">
<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 comments"># vi /etc/my.cnf</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>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_607083">
<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>
<div class="line number13 index12 alt2">
13</div>
<div class="line number14 index13 alt1">
14</div>
<div class="line number15 index14 alt2">
15</div>
<div class="line number16 index15 alt1">
16</div>
<div class="line number17 index16 alt2">
17</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">character-</code><code class="bash functions">set</code><code class="bash plain">-server=utf8 </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">collation-server=utf8_general_ci</code>
</div>
<div class="line number4 index3 alt1">
</div>
<div class="line number5 index4 alt2">
<code class="bash plain"></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">
</div>
<div class="line number8 index7 alt1">
<code class="bash plain"></code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">default-character-</code><code class="bash functions">set</code> <code class="bash plain">= utf8</code>
</div>
<div class="line number10 index9 alt1">
</div>
<div class="line number11 index10 alt2">
</div>
<div class="line number12 index11 alt1">
<code class="bash plain"></code>
</div>
<div class="line number13 index12 alt2">
<code class="bash plain">default-character-</code><code class="bash functions">set</code> <code class="bash plain">= utf8</code>
</div>
<div class="line number14 index13 alt1">
</div>
<div class="line number15 index14 alt2">
</div>
<div class="line number16 index15 alt1">
<code class="bash plain"></code>
</div>
<div class="line number17 index16 alt2">
<code class="bash plain">default-character-</code><code class="bash functions">set</code> <code class="bash plain">= utf8</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>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_38753">
<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 comments"># service mysqld restart</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>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_207940">
<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>
<div class="line number13 index12 alt2">
13</div>
<div class="line number14 index13 alt1">
14</div>
<div class="line number15 index14 alt2">
15</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash comments"># mysql -uroot -p</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">mysql> show variables like </code><code class="bash string">'character%'</code><code class="bash plain">;</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">+--------------------------+----------------------------+</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">| Variable_name | Value |</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">+--------------------------+----------------------------+</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">| character_set_client | utf8 |</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">| character_set_connection | utf8 |</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">| character_set_database | utf8 |</code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">| character_set_filesystem | binary |</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash plain">| character_set_results | utf8 |</code>
</div>
<div class="line number11 index10 alt2">
<code class="bash plain">| character_set_server | utf8 |</code>
</div>
<div class="line number12 index11 alt1">
<code class="bash plain">| character_set_system | utf8 |</code>
</div>
<div class="line number13 index12 alt2">
<code class="bash plain">| character_sets_dir | </code><code class="bash plain">/usr/share/mysql/charsets/</code> <code class="bash plain">|</code>
</div>
<div class="line number14 index13 alt1">
<code class="bash plain">+--------------------------+----------------------------+</code>
</div>
<div class="line number15 index14 alt2">
<code class="bash plain">8 rows </code><code class="bash keyword">in</code> <code class="bash functions">set</code> <code class="bash 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>
5.加入环境变量，编辑 /etc/profile，这样可以在任何地方用mysql命令</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_903184">
<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 functions">export</code> <code class="bash plain">PATH=$PATH:</code><code class="bash plain">/usr/local/mysql//bin</code><code class="bash plain"><br></code><code class="bash functions">source</code> <code class="bash plain">/etc/profile</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/J-Cooper/p/7411804.html</p>

頁: [1]

琼殿技术论坛's Archiver

CentOS Yum编译安装MySQL 5.6