CentOS MySQL 5.7编译安装步骤详细说明
<p><strong>CentOS MySQL 5.7编译安装</strong></p>
<p>
MySQL 5.7 GA版本的发布，也就是说从现在开始5.7已经可以在生产环境中使用，有任何问题官方都将立刻修复。</p>
<p>
<strong>MySQL 5.7主要特性：</strong></p>
<ul>
<li>
更好的性能：对于多核CPU、固态硬盘、锁有着更好的优化，每秒100W QPS已不再是MySQL的追求，下个版本能否上200W QPS才是吾等用户更关心的</li>
<li>
更好的InnoDB存储引擎</li>
<li>
更为健壮的复制功能：复制带来了数据完全不丢失的方案，传统金融客户也可以选择使用MySQL数据库。此外，GTID在线平滑升级也变得可能</li>
<li>
更好的优化器：优化器代码重构的意义将在这个版本及以后的版本中带来巨大的改进，Oracle官方正在解决MySQL之前最大的难题</li>
<li>
原生JSON类型的支持</li>
<li>
更好的地理信息服务支持：InnoDB原生支持地理位置类型，支持GeoJSON，GeoHash特性</li>
<li>
新增sys库：以后这会是DBA访问最频繁的库</li>
</ul>
<p>
MySQL 5.7已经作为数据库可选项添加到《OneinStack》</p>
<p>
<strong>安装依赖包</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_486700">
<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">yum -y </code><code class="bash functions">install</code> <code class="bash plain">gcc gcc-c++ ncurses ncurses-devel cmake</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>下载相应源码包</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_422183">
<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 functions">cd</code> <code class="bash plain">/root/oneinstack/src</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">wget http:</code><code class="bash plain">//downloads</code><code class="bash plain">.sourceforge.net</code><code class="bash plain">/project/boost/boost/1</code><code class="bash plain">.59.0</code><code class="bash plain">/boost_1_59_0</code><code class="bash plain">.</code><code class="bash functions">tar</code><code class="bash plain">.gz</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">wget http:</code><code class="bash plain">//cdn</code><code class="bash plain">.mysql.com</code><code class="bash plain">/Downloads/MySQL-5</code><code class="bash plain">.7</code><code class="bash plain">/mysql-5</code><code class="bash plain">.7.11.</code><code class="bash functions">tar</code><code class="bash plain">.gz</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_883312">
<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">useradd</code> <code class="bash plain">-M -s </code><code class="bash plain">/sbin/nologin</code> <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>
<strong>预编译</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_86334">
<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>
<div class="line number18 index17 alt1">
18</div>
<div class="line number19 index18 alt2">
19</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash functions">tar</code> <code class="bash plain">xzf boost_1_59_0.</code><code class="bash functions">tar</code><code class="bash plain">.gz</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash functions">tar</code> <code class="bash plain">xzf mysql-5.7.11.</code><code class="bash functions">tar</code><code class="bash plain">.gz</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash functions">mkdir</code> <code class="bash plain">-p </code><code class="bash plain">/data/mysql</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash functions">cd</code> <code class="bash plain">mysql-5.7.11</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">cmake . -DCMAKE_INSTALL_PREFIX=</code><code class="bash plain">/usr/local/mysql</code> <code class="bash plain">\</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">-DMYSQL_DATADIR=</code><code class="bash plain">/data/mysql</code> <code class="bash plain">\</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">-DDOWNLOAD_BOOST=1 \ </code><code class="bash comments">#从MySQL 5.7.5开始Boost库是必需的</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">-DWITH_BOOST=..</code><code class="bash plain">/boost_1_59_0</code> <code class="bash plain">\</code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">-DSYSCONFDIR=</code><code class="bash plain">/etc</code> <code class="bash plain">\</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash plain">-DWITH_INNOBASE_STORAGE_ENGINE=1 \</code>
</div>
<div class="line number11 index10 alt2">
<code class="bash plain">-DWITH_PARTITION_STORAGE_ENGINE=1 \</code>
</div>
<div class="line number12 index11 alt1">
<code class="bash plain">-DWITH_FEDERATED_STORAGE_ENGINE=1 \</code>
</div>
<div class="line number13 index12 alt2">
<code class="bash plain">-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \</code>
</div>
<div class="line number14 index13 alt1">
<code class="bash plain">-DWITH_MYISAM_STORAGE_ENGINE=1 \</code>
</div>
<div class="line number15 index14 alt2">
<code class="bash plain">-DENABLED_LOCAL_INFILE=1 \</code>
</div>
<div class="line number16 index15 alt1">
<code class="bash plain">-DENABLE_DTRACE=0 \</code>
</div>
<div class="line number17 index16 alt2">
<code class="bash plain">-DDEFAULT_CHARSET=utf8mb4 \</code>
</div>
<div class="line number18 index17 alt1">
<code class="bash plain">-DDEFAULT_COLLATION=utf8mb4_general_ci \</code>
</div>
<div class="line number19 index18 alt2">
<code class="bash plain">-DWITH_EMBEDDED_SERVER=1</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>编译安装</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_832336">
<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 functions">make</code> <code class="bash plain">-j `</code><code class="bash functions">grep</code> <code class="bash plain">processor </code><code class="bash plain">/proc/cpuinfo</code> <code class="bash plain">| </code><code class="bash functions">wc</code> <code class="bash plain">-l` </code><code class="bash comments">#编译很消耗系统资源，小内存可能编译通不过</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash functions">make</code> <code class="bash functions">install</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>启动脚本，设置开机自启动</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_581218">
<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">/bin/cp</code> <code class="bash plain">/usr/local/mysql/support-files/mysql</code><code class="bash plain">.server </code><code class="bash plain">/etc/init</code><code class="bash plain">.d</code><code class="bash plain">/mysqld</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash functions">chmod</code> <code class="bash plain">+x </code><code class="bash plain">/etc/init</code><code class="bash plain">.d</code><code class="bash plain">/mysqld</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">chkconfig --add mysqld</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">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>
<strong>/etc/my.cnf，仅供参考</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_847668">
<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>
<div class="line number18 index17 alt1">
18</div>
<div class="line number19 index18 alt2">
19</div>
<div class="line number20 index19 alt1">
20</div>
<div class="line number21 index20 alt2">
21</div>
<div class="line number22 index21 alt1">
22</div>
<div class="line number23 index22 alt2">
23</div>
<div class="line number24 index23 alt1">
24</div>
<div class="line number25 index24 alt2">
25</div>
<div class="line number26 index25 alt1">
26</div>
<div class="line number27 index26 alt2">
27</div>
<div class="line number28 index27 alt1">
28</div>
<div class="line number29 index28 alt2">
29</div>
<div class="line number30 index29 alt1">
30</div>
<div class="line number31 index30 alt2">
31</div>
<div class="line number32 index31 alt1">
32</div>
<div class="line number33 index32 alt2">
33</div>
<div class="line number34 index33 alt1">
34</div>
<div class="line number35 index34 alt2">
35</div>
<div class="line number36 index35 alt1">
36</div>
<div class="line number37 index36 alt2">
37</div>
<div class="line number38 index37 alt1">
38</div>
<div class="line number39 index38 alt2">
39</div>
<div class="line number40 index39 alt1">
40</div>
<div class="line number41 index40 alt2">
41</div>
<div class="line number42 index41 alt1">
42</div>
<div class="line number43 index42 alt2">
43</div>
<div class="line number44 index43 alt1">
44</div>
<div class="line number45 index44 alt2">
45</div>
<div class="line number46 index45 alt1">
46</div>
<div class="line number47 index46 alt2">
47</div>
<div class="line number48 index47 alt1">
48</div>
<div class="line number49 index48 alt2">
49</div>
<div class="line number50 index49 alt1">
50</div>
<div class="line number51 index50 alt2">
51</div>
<div class="line number52 index51 alt1">
52</div>
<div class="line number53 index52 alt2">
53</div>
<div class="line number54 index53 alt1">
54</div>
<div class="line number55 index54 alt2">
55</div>
<div class="line number56 index55 alt1">
56</div>
<div class="line number57 index56 alt2">
57</div>
<div class="line number58 index57 alt1">
58</div>
<div class="line number59 index58 alt2">
59</div>
<div class="line number60 index59 alt1">
60</div>
<div class="line number61 index60 alt2">
61</div>
<div class="line number62 index61 alt1">
62</div>
<div class="line number63 index62 alt2">
63</div>
<div class="line number64 index63 alt1">
64</div>
<div class="line number65 index64 alt2">
65</div>
<div class="line number66 index65 alt1">
66</div>
<div class="line number67 index66 alt2">
67</div>
<div class="line number68 index67 alt1">
68</div>
<div class="line number69 index68 alt2">
69</div>
<div class="line number70 index69 alt1">
70</div>
<div class="line number71 index70 alt2">
71</div>
<div class="line number72 index71 alt1">
72</div>
<div class="line number73 index72 alt2">
73</div>
<div class="line number74 index73 alt1">
74</div>
<div class="line number75 index74 alt2">
75</div>
<div class="line number76 index75 alt1">
76</div>
<div class="line number77 index76 alt2">
77</div>
<div class="line number78 index77 alt1">
78</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash functions">cat</code> <code class="bash plain">> </code><code class="bash plain">/etc/my</code><code class="bash plain">.cnf << EOF</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain"></code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">port = 3306</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">socket = </code><code class="bash plain">/tmp/mysql</code><code class="bash plain">.sock</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">default-character-</code><code class="bash functions">set</code> <code class="bash plain">= utf8mb4</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain"></code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">port = 3306</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">socket = </code><code class="bash plain">/tmp/mysql</code><code class="bash plain">.sock</code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">basedir = </code><code class="bash plain">/usr/local/mysql</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash plain">datadir = </code><code class="bash plain">/data/mysql</code>
</div>
<div class="line number11 index10 alt2">
<code class="bash plain">pid-</code><code class="bash functions">file</code> <code class="bash plain">= </code><code class="bash plain">/data/mysql/mysql</code><code class="bash plain">.pid</code>
</div>
<div class="line number12 index11 alt1">
<code class="bash plain">user = mysql</code>
</div>
<div class="line number13 index12 alt2">
<code class="bash plain">bind-address = 0.0.0.0</code>
</div>
<div class="line number14 index13 alt1">
<code class="bash plain">server-</code><code class="bash functions">id</code> <code class="bash plain">= 1</code>
</div>
<div class="line number15 index14 alt2">
<code class="bash plain">init-connect = </code><code class="bash string">'SET NAMES utf8mb4'</code>
</div>
<div class="line number16 index15 alt1">
<code class="bash plain">character-</code><code class="bash functions">set</code><code class="bash plain">-server = utf8mb4</code>
</div>
<div class="line number17 index16 alt2">
<code class="bash comments">#skip-name-resolve</code>
</div>
<div class="line number18 index17 alt1">
<code class="bash comments">#skip-networking</code>
</div>
<div class="line number19 index18 alt2">
<code class="bash plain">back_log = 300</code>
</div>
<div class="line number20 index19 alt1">
<code class="bash plain">max_connections = 1000</code>
</div>
<div class="line number21 index20 alt2">
<code class="bash plain">max_connect_errors = 6000</code>
</div>
<div class="line number22 index21 alt1">
<code class="bash plain">open_files_limit = 65535</code>
</div>
<div class="line number23 index22 alt2">
<code class="bash plain">table_open_cache = 128</code>
</div>
<div class="line number24 index23 alt1">
<code class="bash plain">max_allowed_packet = 4M</code>
</div>
<div class="line number25 index24 alt2">
<code class="bash plain">binlog_cache_size = 1M</code>
</div>
<div class="line number26 index25 alt1">
<code class="bash plain">max_heap_table_size = 8M</code>
</div>
<div class="line number27 index26 alt2">
<code class="bash plain">tmp_table_size = 16M</code>
</div>
<div class="line number28 index27 alt1">
<code class="bash plain">read_buffer_size = 2M</code>
</div>
<div class="line number29 index28 alt2">
<code class="bash plain">read_rnd_buffer_size = 8M</code>
</div>
<div class="line number30 index29 alt1">
<code class="bash plain">sort_buffer_size = 8M</code>
</div>
<div class="line number31 index30 alt2">
<code class="bash plain">join_buffer_size = 8M</code>
</div>
<div class="line number32 index31 alt1">
<code class="bash plain">key_buffer_size = 4M</code>
</div>
<div class="line number33 index32 alt2">
<code class="bash plain">thread_cache_size = 8</code>
</div>
<div class="line number34 index33 alt1">
<code class="bash plain">query_cache_type = 1</code>
</div>
<div class="line number35 index34 alt2">
<code class="bash plain">query_cache_size = 8M</code>
</div>
<div class="line number36 index35 alt1">
<code class="bash plain">query_cache_limit = 2M</code>
</div>
<div class="line number37 index36 alt2">
<code class="bash plain">ft_min_word_len = 4</code>
</div>
<div class="line number38 index37 alt1">
<code class="bash plain">log_bin = mysql-bin</code>
</div>
<div class="line number39 index38 alt2">
<code class="bash plain">binlog_format = mixed</code>
</div>
<div class="line number40 index39 alt1">
<code class="bash plain">expire_logs_days = 30</code>
</div>
<div class="line number41 index40 alt2">
<code class="bash plain">log_error = </code><code class="bash plain">/data/mysql/mysql-error</code><code class="bash plain">.log</code>
</div>
<div class="line number42 index41 alt1">
<code class="bash plain">slow_query_log = 1</code>
</div>
<div class="line number43 index42 alt2">
<code class="bash plain">long_query_time = 1</code>
</div>
<div class="line number44 index43 alt1">
<code class="bash plain">slow_query_log_file = </code><code class="bash plain">/data/mysql/mysql-slow</code><code class="bash plain">.log</code>
</div>
<div class="line number45 index44 alt2">
<code class="bash plain">performance_schema = 0</code>
</div>
<div class="line number46 index45 alt1">
<code class="bash plain">explicit_defaults_for_timestamp</code>
</div>
<div class="line number47 index46 alt2">
<code class="bash comments">#lower_case_table_names = 1</code>
</div>
<div class="line number48 index47 alt1">
<code class="bash plain">skip-external-locking</code>
</div>
<div class="line number49 index48 alt2">
<code class="bash plain">default_storage_engine = InnoDB</code>
</div>
<div class="line number50 index49 alt1">
<code class="bash comments">#default-storage-engine = MyISAM</code>
</div>
<div class="line number51 index50 alt2">
<code class="bash plain">innodb_file_per_table = 1</code>
</div>
<div class="line number52 index51 alt1">
<code class="bash plain">innodb_open_files = 500</code>
</div>
<div class="line number53 index52 alt2">
<code class="bash plain">innodb_buffer_pool_size = 64M</code>
</div>
<div class="line number54 index53 alt1">
<code class="bash plain">innodb_write_io_threads = 4</code>
</div>
<div class="line number55 index54 alt2">
<code class="bash plain">innodb_read_io_threads = 4</code>
</div>
<div class="line number56 index55 alt1">
<code class="bash plain">innodb_thread_concurrency = 0</code>
</div>
<div class="line number57 index56 alt2">
<code class="bash plain">innodb_purge_threads = 1</code>
</div>
<div class="line number58 index57 alt1">
<code class="bash plain">innodb_flush_log_at_trx_commit = 2</code>
</div>
<div class="line number59 index58 alt2">
<code class="bash plain">innodb_log_buffer_size = 2M</code>
</div>
<div class="line number60 index59 alt1">
<code class="bash plain">innodb_log_file_size = 32M</code>
</div>
<div class="line number61 index60 alt2">
<code class="bash plain">innodb_log_files_in_group = 3</code>
</div>
<div class="line number62 index61 alt1">
<code class="bash plain">innodb_max_dirty_pages_pct = 90</code>
</div>
<div class="line number63 index62 alt2">
<code class="bash plain">innodb_lock_wait_timeout = 120</code>
</div>
<div class="line number64 index63 alt1">
<code class="bash plain">bulk_insert_buffer_size = 8M</code>
</div>
<div class="line number65 index64 alt2">
<code class="bash plain">myisam_sort_buffer_size = 8M</code>
</div>
<div class="line number66 index65 alt1">
<code class="bash plain">myisam_max_sort_file_size = 10G</code>
</div>
<div class="line number67 index66 alt2">
<code class="bash plain">myisam_repair_threads = 1</code>
</div>
<div class="line number68 index67 alt1">
<code class="bash plain">interactive_timeout = 28800</code>
</div>
<div class="line number69 index68 alt2">
<code class="bash plain">wait_timeout = 28800</code>
</div>
<div class="line number70 index69 alt1">
<code class="bash plain"></code>
</div>
<div class="line number71 index70 alt2">
<code class="bash plain">quick</code>
</div>
<div class="line number72 index71 alt1">
<code class="bash plain">max_allowed_packet = 16M</code>
</div>
<div class="line number73 index72 alt2">
<code class="bash plain"></code>
</div>
<div class="line number74 index73 alt1">
<code class="bash plain">key_buffer_size = 8M</code>
</div>
<div class="line number75 index74 alt2">
<code class="bash plain">sort_buffer_size = 8M</code>
</div>
<div class="line number76 index75 alt1">
<code class="bash plain">read_buffer = 4M</code>
</div>
<div class="line number77 index76 alt2">
<code class="bash plain">write_buffer = 4M</code>
</div>
<div class="line number78 index77 alt1">
<code class="bash plain">EOF</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>初始化数据库</strong></p>
<p>
<span>注：</span></p>
<ul>
<li>
之前版本mysql_install_db是在mysql_basedir/script下，5.7放在了mysql_install_db/bin目录下,且已被废弃</li>
<li>
"--initialize"会生成一个随机密码(~/.mysql_secret)，而"--initialize-insecure"不会生成密码</li>
<li>
--datadir目标目录下不能有数据文件</li>
</ul>
<p>
<strong>启动数据库</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_898650">
<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">/usr/local/mysql/bin/mysqld</code> <code class="bash plain">--initialize-insecure --user=mysql --basedir=</code><code class="bash plain">/usr/local/mysql</code> <code class="bash plain">--datadir=</code><code class="bash plain">/data/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>
<strong>设置数据库密码</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_889943">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">dbrootpwd=oneinstack </code><code class="bash comments">#数据库root密码</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">/usr/local/mysql/bin/mysql</code> <code class="bash plain">-e </code><code class="bash string">"grant all privileges on *.* to root@'127.0.0.1' identified by \"$dbrootpwd\" with grant option;"</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">/usr/local/mysql/bin/mysql</code> <code class="bash plain">-e </code><code class="bash string">"grant all privileges on *.* to root@'localhost' identified by \"$dbrootpwd\" with grant option;"</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>
頁:
[1]