详解Ubuntu下安装mysql和简单操作

老衲要吃肉 發表於 2023-7-8 00:00:00

<p>
ubuntu上安装mysql非常简单只需要几条命令就可以完成。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_325426">
<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">sudo</code> <code class="bash plain">apt-get </code><code class="bash functions">install</code> <code class="bash plain">mysql-server</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">apt-get isntall mysql-client</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash functions">sudo</code> <code class="bash plain">apt-get </code><code class="bash functions">install</code> <code class="bash plain">libmysqlclient-dev</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
安装过程中会提示设置密码什么的，注意设置了不要忘了，安装完成之后可以使用如下命令来检查是否安装成功：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_211595">
<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">sudo</code> <code class="bash functions">netstat</code> <code class="bash plain">-tap | </code><code class="bash functions">grep</code> <code class="bash plain">mysql</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
通过上述命令检查之后，如果看到有mysql 的socket处于 listen 状态则表示安装成功。</p>
<p>
登陆mysql数据库可以通过如下命令：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_253668">
<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 -u root -p</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
-u 表示选择登陆的用户名， -p 表示登陆的用户密码，上面命令输入之后会提示输入密码，此时输入密码就可以登录到mysql。</p>
<p>
<img style="max-width:100%!important;height:auto!important;"title="详解Ubuntu下安装mysql和简单操作" alt="详解Ubuntu下安装mysql和简单操作" src="https://zhuji.jb51.net/uploads/img/202305/675b5cf08d97236b8e3037eedae5b62a.jpg"></p>
<p>
然后通过 show databases; 就可以查看当前的数据库。</p>
<p>
我们选择 mysql数据库就行下一步操作，使用use mysql 命令，显示当前数据库的表单：show tables</p>
<p>
<img style="max-width:100%!important;height:auto!important;"title="详解Ubuntu下安装mysql和简单操作" alt="详解Ubuntu下安装mysql和简单操作" src="https://zhuji.jb51.net/uploads/img/202305/22af3ef543da2f1b6e64e7f65566822e.jpg">　　　</p>
<p>
写一个简单的程序来访问该数据库，实现 show tables 功能：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightercpp" id="highlighter_818459">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="cpp preprocessor">#include <mysql/mysql.h></code>
</div>
<div class="line number2 index1 alt1">
<code class="cpp preprocessor">#include <stdio.h></code>
</div>
<div class="line number3 index2 alt2">
<code class="cpp preprocessor">#include <stdlib.h></code>
</div>
<div class="line number4 index3 alt1">
<code class="cpp color1 bold">int</code> <code class="cpp plain">main() </code>
</div>
<div class="line number5 index4 alt2">
<code class="cpp plain">{</code>
</div>
<div class="line number6 index5 alt1">
<code class="cpp spaces">  </code><code class="cpp plain">mysql *conn;</code>
</div>
<div class="line number7 index6 alt2">
<code class="cpp spaces">  </code><code class="cpp plain">mysql_res *res;</code>
</div>
<div class="line number8 index7 alt1">
<code class="cpp spaces">  </code><code class="cpp plain">mysql_row row;</code>
</div>
<div class="line number9 index8 alt2">
<code class="cpp spaces">  </code><code class="cpp color1 bold">char</code> <code class="cpp plain">server[] = </code><code class="cpp string">"localhost"</code><code class="cpp plain">;</code>
</div>
<div class="line number10 index9 alt1">
<code class="cpp spaces">  </code><code class="cpp color1 bold">char</code> <code class="cpp plain">user[] = </code><code class="cpp string">"root"</code><code class="cpp plain">;</code>
</div>
<div class="line number11 index10 alt2">
<code class="cpp spaces">  </code><code class="cpp color1 bold">char</code> <code class="cpp plain">password[] = </code><code class="cpp string">"mima"</code><code class="cpp plain">;</code>
</div>
<div class="line number12 index11 alt1">
<code class="cpp spaces">  </code><code class="cpp color1 bold">char</code> <code class="cpp plain">database[] = </code><code class="cpp string">"mysql"</code><code class="cpp plain">;</code>
</div>
<div class="line number13 index12 alt2">
<code class="cpp spaces">  </code>
</div>
<div class="line number14 index13 alt1">
<code class="cpp spaces">  </code><code class="cpp plain">conn = mysql_init(null);</code>
</div>
<div class="line number15 index14 alt2">
<code class="cpp spaces">  </code>
</div>
<div class="line number16 index15 alt1">
<code class="cpp spaces">  </code><code class="cpp keyword bold">if</code> <code class="cpp plain">(!mysql_real_connect(conn, server,user, password, database, 0, null, 0)) </code>
</div>
<div class="line number17 index16 alt2">
<code class="cpp spaces">  </code><code class="cpp plain">{</code>
</div>
<div class="line number18 index17 alt1">
<code class="cpp spaces">    </code><code class="cpp functions bold">fprintf</code><code class="cpp plain">(stderr, </code><code class="cpp string">"%s\n"</code><code class="cpp plain">, mysql_error(conn));</code>
</div>
<div class="line number19 index18 alt2">
<code class="cpp spaces">    </code><code class="cpp functions bold">exit</code><code class="cpp plain">(1);</code>
</div>
<div class="line number20 index19 alt1">
<code class="cpp spaces">  </code><code class="cpp plain">}</code>
</div>
<div class="line number21 index20 alt2">
<code class="cpp spaces">  </code>
</div>
<div class="line number22 index21 alt1">
<code class="cpp spaces">  </code><code class="cpp keyword bold">if</code> <code class="cpp plain">(mysql_query(conn, </code><code class="cpp string">"show tables"</code><code class="cpp plain">)) </code>
</div>
<div class="line number23 index22 alt2">
<code class="cpp spaces">  </code><code class="cpp plain">{</code>
</div>
<div class="line number24 index23 alt1">
<code class="cpp spaces">    </code><code class="cpp functions bold">fprintf</code><code class="cpp plain">(stderr, </code><code class="cpp string">"%s\n"</code><code class="cpp plain">, mysql_error(conn));</code>
</div>
<div class="line number25 index24 alt2">
<code class="cpp spaces">    </code><code class="cpp functions bold">exit</code><code class="cpp plain">(1);</code>
</div>
<div class="line number26 index25 alt1">
<code class="cpp spaces">  </code><code class="cpp plain">}</code>
</div>
<div class="line number27 index26 alt2">
<code class="cpp spaces">  </code>
</div>
<div class="line number28 index27 alt1">
<code class="cpp spaces">  </code><code class="cpp plain">res = mysql_use_result(conn);</code>
</div>
<div class="line number29 index28 alt2">
<code class="cpp spaces">  </code>
</div>
<div class="line number30 index29 alt1">
<code class="cpp spaces">  </code><code class="cpp functions bold">printf</code><code class="cpp plain">(</code><code class="cpp string">"mysql tables in mysql database:\n"</code><code class="cpp plain">);</code>
</div>
<div class="line number31 index30 alt2">
<code class="cpp spaces">  </code>
</div>
<div class="line number32 index31 alt1">
<code class="cpp spaces">  </code><code class="cpp keyword bold">while</code> <code class="cpp plain">((row = mysql_fetch_row(res)) != null)</code>
</div>
<div class="line number33 index32 alt2">
<code class="cpp spaces">  </code><code class="cpp plain">{</code>
</div>
<div class="line number34 index33 alt1">
<code class="cpp spaces">    </code><code class="cpp functions bold">printf</code><code class="cpp plain">(</code><code class="cpp string">"%s \n"</code><code class="cpp plain">, row);</code>
</div>
<div class="line number35 index34 alt2">
<code class="cpp spaces">  </code><code class="cpp plain">}</code>
</div>
<div class="line number36 index35 alt1">
<code class="cpp spaces">  </code>
</div>
<div class="line number37 index36 alt2">
<code class="cpp spaces">  </code><code class="cpp plain">mysql_free_result(res);</code>
</div>
<div class="line number38 index37 alt1">
<code class="cpp spaces">  </code><code class="cpp plain">mysql_close(conn);</code>
</div>
<div class="line number39 index38 alt2">
<code class="cpp spaces">  </code>
</div>
<div class="line number40 index39 alt1">
<code class="cpp spaces">  </code><code class="cpp functions bold">printf</code><code class="cpp plain">(</code><code class="cpp string">"finish! \n"</code><code class="cpp plain">);</code>
</div>
<div class="line number41 index40 alt2">
<code class="cpp spaces">  </code><code class="cpp keyword bold">return</code> <code class="cpp plain">0;</code>
</div>
<div class="line number42 index41 alt1">
<code class="cpp plain">}</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
编译代码的时候需要链接mysql的库，可以通过如下方式编译：</p>
<p>
g++ -wall mysql_test.cpp -o mysql_test -lmsqlclient</p>
<p>
然后运行编译好的代码：</p>
<p>
<img style="max-width:100%!important;height:auto!important;"title="详解Ubuntu下安装mysql和简单操作" alt="详解Ubuntu下安装mysql和简单操作" src="https://zhuji.jb51.net/uploads/img/202305/a7cb41de5da0941e67c844d77a50e551.jpg"></p>
<p>
可见结果和使用sql语句 show tables 是一样的。</p>
<p>
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持。</p>
<p>
原文链接：http://blog.csdn.net/fighter_yy/article/details/40753889</p>

頁: [1]

琼殿技术论坛's Archiver

详解Ubuntu下安装mysql和简单操作