linux mysql数据库_sql_数据库_其他

<html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta charset="utf-8"> <meta name="generator" content="pdf2htmlEX"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <link rel="stylesheet" href="https://static.pudn.com/base/css/base.min.css"> <link rel="stylesheet" href="https://static.pudn.com/base/css/fancy.min.css"> <link rel="stylesheet" href="https://static.pudn.com/prod/directory_preview_static/627024fc40256a40ceb3e7f9/raw.css"> <script src="https://static.pudn.com/base/js/compatibility.min.js"></script> <script src="https://static.pudn.com/base/js/pdf2htmlEX.min.js"></script> <script> try{ pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({}); }catch(e){} </script> <title></title> </head> <body> <div id="sidebar" style="display: none"> <div id="outline"> </div> </div> <div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/627024fc40256a40ceb3e7f9/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">数据库<span class="_ _0"> </span><span class="ff2 sc1">Mysql<span class="_ _0"> </span></span>安装</div><div class="t m0 x2 h4 y3 ff3 fs1 fc0 sc1 ls0 ws0">1.<span class="ff1">首先下载安装包并使用命令<span class="_ _1"> </span></span>tar<span class="_ _1"> </span><span class="ff1">解压：</span></div><div class="t m0 x2 h4 y4 ff1 fs1 fc0 sc1 ls0 ws0">命令格式：<span class="ff3">tar -zxvf MySQL-version-OS.tar<span class="_ _2"></span>.gz</span></div><div class="t m0 x2 h4 y5 ff1 fs1 fc0 sc1 ls0 ws0">我的操作<span class="ff3">: tar –zxvf mysql-5.1.30.tar<span class="_ _2"></span>.gz</span></div><div class="t m0 x1 h4 y6 ff1 fs1 fc0 sc1 ls0 ws0">使用<span class="_ _1"> </span><span class="ff3">cd<span class="_ _1"> </span></span>命令进入解压后的目录</div><div class="t m0 x1 h4 y7 ff1 fs1 fc0 sc1 ls0 ws0">命令格式：<span class="ff3">cd MySQL-version-OS</span></div><div class="t m0 x1 h4 y8 ff3 fs1 fc0 sc1 ls0 ws0">./configure <span class="ff1">之前要<span class="_ _1"> </span></span>make clean <span class="ff1">一下吧</span>,<span class="ff1">为什么</span>,<span class="ff1">好像是防止原来编译过</span></div><div class="t m0 x2 h4 y9 ff1 fs1 fc0 sc1 ls0 ws0">注<span class="_ _3"></span>释<span class="_ _3"></span>：<span class="_ _3"></span>在<span class="_ _3"></span>执<span class="_ _3"></span>行<span class="_ _3"></span>“<span class="_ _4"></span><span class="ff4">mak<span class="_ _2"></span>e<span class="_ _3"></span> clean”<span class="_ _3"></span> <span class="_ _4"></span><span class="ff1">失<span class="_ _3"></span>败<span class="_ _3"></span>时<span class="_ _3"></span>，<span class="_ _3"></span>提<span class="_ _3"></span>示<span class="_ _3"></span>错<span class="_ _3"></span>误<span class="_ _5"> </span></span>checking <span class="_ _3"></span>for<span class="_ _3"></span> termcap functions</span></div><div class="t m0 x1 h4 ya ff4 fs1 fc0 sc1 ls0 ws0">library<span class="_ _6"></span>... congure: er<span class="_ _2"></span>ror: No curses/ter<span class="_ _2"></span>mcap library<span class="_ _3"></span> found <span class="ff1">。</span></div><div class="t m0 x2 h4 yb ff1 fs1 fc0 sc1 ls0 ws0">则在执行<span class="ff4">./congure<span class="_ _1"> </span></span>命令，执行命令代码为<span class="ff4">:</span></div><div class="t m0 x1 h5 yc ff2 fs1 fc0 sc1 ls0 ws0">./congure<span class="_ _4"></span> <span class="_ _4"></span>--prex=/usr/share/mysql/<span class="_ _3"></span> <span class="_ _4"></span>-with-<span class="_ _3"></span>chars<span class="_ _7"></span>et=<span class="_ _3"></span>utf8 <span class="_ _8"> </span>-with-extra-</div><div class="t m0 x1 h4 yd ff2 fs1 fc0 sc1 ls0 ws0">charsets=all <span class="_ _8"> </span>–with-named-curses-libs=/usr/lib/libncursesw<span class="_ _2"></span>.so.5(<span class="_ _9"> </span><span class="ff1 sc0">最<span class="_ _8"> </span>后<span class="_ _8"> </span>一</span></div><div class="t m0 x1 h4 ye ff1 fs1 fc0 sc0 ls0 ws0">段命令可以省略<span class="ff2 sc1">)</span></div><div class="t m0 x1 h4 yf ff1 fs1 fc0 sc0 ls0 ws0">出<span class="_ _8"> </span>现<span class="_ _8"></span>错<span class="_ _8"></span>误<span class="_ _8"></span>：<span class="_ _8"></span><span class="ff5 sc1">No<span class="_ _3"></span> <span class="_ _4"></span>curses/ter<span class="_ _3"></span>mcap<span class="_ _3"></span> <span class="_ _4"></span>library<span class="_ _4"></span> <span class="_ _4"></span>found<span class="_ _4"></span> <span class="_ _1"> </span> <span class="_ _9"> </span></span>或<span class="_ _8"></span>者<span class="_ _a"> </span><span class="ff5 sc1">see<span class="_ _4"></span> <span class="_ _4"></span>the<span class="_ _4"></span> <span class="_ _4"></span>install<span class="_ _3"></span> <span class="_ _4"></span>manual<span class="_ _4"></span> <span class="_ _4"></span>chapter<span class="_ _3"></span> <span class="_ _4"></span>in<span class="_ _4"></span> <span class="_ _4"></span>the</span></div><div class="t m0 x1 h6 y10 ff5 fs1 fc0 sc1 ls0 ws0">refer<span class="_ _2"></span>ence </div><div class="t m0 x1 h6 y11 ff5 fs1 fc0 sc1 ls0 ws0">yum –y install gcc yum install ncurses-devel </div><div class="t m0 x1 h5 y12 ff4 fs1 fc0 sc1 ls0 ws0"> </div><div class="t m0 x1 h4 y13 ff3 fs1 fc0 sc1 ls0 ws0">2.<span class="ff1">配置和编译安装环境</span></div><div class="t m0 x1 h4 y14 ff3 fs1 fc0 sc1 ls0 ws0">2.1<span class="_ _1"> </span><span class="ff1">配置安装环境</span> </div><div class="t m0 x1 h4 y15 ff1 fs1 fc0 sc1 ls0 ws0">命令格式：<span class="ff3">./configure –prefix=</span>安装路径</div><div class="t m0 x1 h4 y16 ff3 fs1 fc0 sc1 ls0 ws0">--prefix=/usr/local/mysql/ <span class="ff1">安装到此目录下</span></div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div> </body> </html>

<div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/627024fc40256a40ceb3e7f9/bg2.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h4 y17 ff1 fs1 fc0 sc1 ls0 ws0">我的操作<span class="ff3">: ./configure --prefix=/usr/local/mysql/</span></div><div class="t m0 x1 h4 y18 ff3 fs1 fc0 sc1 ls0 ws0">-with-charset=gbk -with-extra-charsets=all <span class="ff1">加入解决中文乱码</span></div><div class="t m0 x1 h7 y19 ff3 fs1 fc0 sc1 ls0 ws0">./configure --prefix=/usr/share/mysql/ -with-charset=gbk -with-extra-charsets=all</div><div class="t m0 x1 h4 y1a ff1 fs1 fc0 sc1 ls0 ws0">参数<span class="ff3">: --prefix= </span>指软件安装的路径</div><div class="t m0 x1 h4 y1b ff3 fs1 fc0 sc1 ls0 ws0">2.2<span class="_ _1"> </span><span class="ff1">编译安装环境</span></div><div class="t m0 x1 h4 y1c ff1 fs1 fc0 sc1 ls0 ws0">命令格式：<span class="ff3">make</span></div><div class="t m0 x1 h4 y1d ff1 fs1 fc0 sc1 ls0 ws0">执行<span class="_ _1"> </span><span class="ff3">make<span class="_ _1"> </span></span>命令时出现错误：<span class="ff3">exec g++ not found </span></div><div class="t m0 x1 h4 y1e ff1 fs1 fc0 sc1 ls0 ws0">安装<span class="_ _1"> </span><span class="ff3">gcc -c++</span></div><div class="t m0 x1 h4 y1f ff1 fs1 fc0 sc1 ls0 ws0">重新执行上一命令<span class="ff3">(config)</span></div><div class="t m0 x1 h4 y20 ff1 fs1 fc0 sc1 ls0 ws0">等待………<span class="ff3">.</span>时间太长了</div><div class="t m0 x1 h4 y21 ff3 fs1 fc0 sc1 ls0 ws0">2.3<span class="_ _1"> </span><span class="ff1">安装</span></div><div class="t m0 x1 h4 y22 ff1 fs1 fc0 sc1 ls0 ws0">命令格式：<span class="ff3">make install</span></div><div class="t m0 x1 h4 y23 ff3 fs1 fc0 sc1 ls0 ws0">3.<span class="ff1">创建<span class="_ _1"> </span></span>MySQL<span class="_ _1"> </span><span class="ff1">相关用户</span></div><div class="t m0 x1 h4 y24 ff1 fs1 fc0 sc1 ls0 ws0">使用命令<span class="_ _1"> </span><span class="ff3">groupadd<span class="_ _1"> </span></span>创建用户组</div><div class="t m0 x1 h4 y25 ff1 fs1 fc0 sc1 ls0 ws0">命令格式：<span class="ff3">groupadd mysql</span></div><div class="t m0 x1 h4 y26 ff1 fs1 fc0 sc1 ls0 ws0">使用命令<span class="_ _1"> </span><span class="ff3">useradd<span class="_ _1"> </span></span>创建用户并分配到<span class="_ _1"> </span><span class="ff3">mysql<span class="_ _1"> </span></span>组中</div><div class="t m0 x1 h4 y27 ff1 fs1 fc0 sc1 ls0 ws0">命令格式：<span class="ff3">useradd <span class="ff4">–</span>g mysql mysql</span></div><div class="t m0 x1 h4 y28 ff1 fs1 fc0 sc1 ls0 ws0">使用命令<span class="_ _1"> </span><span class="ff3">passwd<span class="_ _1"> </span></span>修改用户密码</div><div class="t m0 x1 h4 y29 ff1 fs1 fc0 sc1 ls0 ws0">命令格式：<span class="ff3">passwd mysql</span></div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>