centos7安装mysql并jdbc测试实例详解
<p><strong>centos7安装mysql并jdbc测试实例详解</strong></p>
<p>
<strong>前言：</strong></p>
<p>
之前用rpm安装方式安装不成功，换成yum安装之后安装ok了，在网上搜索到很多的rmp安装和tar包安装的方式，但是是centos7.x与centos6.x做了很大的改变，可能别人的6.x不适合7.x的安装，尤其是对于像博主一样的新人来说，照搬教程可能导致安装不成功，如果你rmp安装失败，那么尝试跟着本教程来吧。</p>
<p>
先卸载已经存在的MySQL。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_597367">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># rpm -qa|grep mysql</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain"></code><code class="bash comments"># rpm -qa mysql</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain"></code><code class="bash comments"># rpm -qa|grep -i mysql</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">MySQL-client-5.5.54-1.el7.x86_64</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain"></code><code class="bash comments"># rpm -e --nodeps M</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">ModemManager ModemManager-glib MySQL-client</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain"></code><code class="bash comments"># rpm -e --nodeps MySQL-client</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的yum源</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_692604">
<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"># wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain"></code><code class="bash comments"># rpm -ivh mysql-community-release-el7-5.noarch.rpm</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
yum安装</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_564257">
<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-community-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>
不出意外，mysql就已经安装成功，因为yum安装是傻瓜式安装嘛，现在启动mysql服务。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_762392">
<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"># 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>
查看mysql是否启动，可以监听它的端口号，mysql监听的段口号是3306，现在我们来监听3306端口是否已经启动：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_46404">
<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 functions">netstat</code> <code class="bash plain">-anp |</code><code class="bash functions">grep</code> <code class="bash plain">3306</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">tcp6 0 0 :::3306 :::* LISTEN -</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服务已经起来了，可以登陆数据库了，第一次登陆数据密码为空，然后再去给数据库配置root的密码。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_449632">
<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 -uroot</code>
</div>
<div class="line number2 index1 alt1">
<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 string">'root'</code><code class="bash plain">@</code><code class="bash string">'localhost'</code> <code class="bash plain">=password(</code><code class="bash string">'root'</code><code class="bash plain">);</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">mysql></code><code class="bash functions">exit</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_703992">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># mysql -uroot -proot</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">mysql> show database;</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">ERROR 1064 (42000): You have an error </code><code class="bash keyword">in</code> <code class="bash plain">your SQL syntax; check the manual that corresponds to your MySQL server version </code><code class="bash keyword">for</code> <code class="bash plain">the right syntax to use near </code><code class="bash string">'database'</code> <code class="bash plain">at line 1</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">mysql> show databases;</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">+--------------------+</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">| Database |</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">+--------------------+</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">| information_schema |</code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">| mysql |</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash plain">| performance_schema |</code>
</div>
<div class="line number11 index10 alt2">
<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>
到这里已经成功的登陆本地数据库了，停止mysql服务的命令是:</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_276881">
<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"># service mysqld stop</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服务已经搭建起来了，作为一个Java程序员，那么下面请继续</p>
<p>
<strong>测试jdbc</strong></p>
<p>
首先需要准备好jar包，mysql只需要一个jar包:mysql-connector-java-3.0.14-production-bin.jar，如果你是用vi/vim作为编辑工具，那么你的jar包需要放在jdk的lib文件夹下面，或者放在一个独立的地方，然后将其加入classpath里面，我在centos下面用ide eclipse来开发，这里以eclipse为例子说来(感觉自己在Linux用ide，有点low).复制+粘帖，放在项目的lib下面。接着来开放我们的jdbc测试用例。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_798293">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash functions">import</code> <code class="bash plain">java.sql.Connection;</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash functions">import</code> <code class="bash plain">java.sql.DriverManager;</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash functions">import</code> <code class="bash plain">java.sql.ResultSet;</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash functions">import</code> <code class="bash plain">java.sql.SQLException;</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash functions">import</code> <code class="bash plain">java.sql.Statement;</code>
</div>
<div class="line number6 index5 alt1">
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">public class JdbcTest {</code>
</div>
<div class="line number8 index7 alt1">
</div>
<div class="line number9 index8 alt2">
<code class="bash spaces"> </code><code class="bash plain">public static void main(String[] args) {</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash spaces"> </code><code class="bash plain">Connection conn = null;</code>
</div>
<div class="line number11 index10 alt2">
<code class="bash spaces"> </code><code class="bash plain">Statement sm = null;</code>
</div>
<div class="line number12 index11 alt1">
<code class="bash spaces"> </code><code class="bash plain">ResultSet rs = null;</code>
</div>
<div class="line number13 index12 alt2">
</div>
<div class="line number14 index13 alt1">
<code class="bash spaces"> </code><code class="bash plain">try {</code>
</div>
<div class="line number15 index14 alt2">
<code class="bash spaces"> </code><code class="bash plain">Class.forName(</code><code class="bash string">"com.mysql.jdbc.Driver"</code><code class="bash plain">);</code>
</div>
<div class="line number16 index15 alt1">
<code class="bash spaces"> </code><code class="bash plain">String url = </code><code class="bash string">"jdbc:mysql://localhost:3306/shopping?zeroDateTimeBehavior=convertToNull"</code><code class="bash plain">;</code>
</div>
<div class="line number17 index16 alt2">
<code class="bash spaces"> </code><code class="bash plain">conn = DriverManager.getConnection(url, </code><code class="bash string">"root"</code><code class="bash plain">, </code><code class="bash string">"root"</code><code class="bash plain">);</code>
</div>
<div class="line number18 index17 alt1">
<code class="bash spaces"> </code><code class="bash plain">sm = conn.createStatement();</code>
</div>
<div class="line number19 index18 alt2">
<code class="bash spaces"> </code><code class="bash plain">rs = sm.executeQuery(</code><code class="bash string">"select * from user"</code><code class="bash plain">);</code>
</div>
<div class="line number20 index19 alt1">
<code class="bash spaces"> </code><code class="bash keyword">while</code><code class="bash plain">(rs.next()) {</code>
</div>
<div class="line number21 index20 alt2">
<code class="bash spaces"> </code><code class="bash plain">System.out.println(</code><code class="bash string">"id:"</code> <code class="bash plain">+ rs.getInt(</code><code class="bash string">"id"</code><code class="bash plain">) + </code><code class="bash string">" name:"</code> <code class="bash plain">+ rs.getString(</code><code class="bash string">"name"</code><code class="bash plain">));</code>
</div>
<div class="line number22 index21 alt1">
<code class="bash spaces"> </code><code class="bash plain">}</code>
</div>
<div class="line number23 index22 alt2">
<code class="bash spaces"> </code><code class="bash plain">} catch (ClassNotFoundException e) {</code>
</div>
<div class="line number24 index23 alt1">
<code class="bash spaces"> </code><code class="bash plain">e.printStackTrace();</code>
</div>
<div class="line number25 index24 alt2">
<code class="bash spaces"> </code><code class="bash plain">} catch (SQLException e) {</code>
</div>
<div class="line number26 index25 alt1">
<code class="bash spaces"> </code><code class="bash plain">e.printStackTrace();</code>
</div>
<div class="line number27 index26 alt2">
<code class="bash spaces"> </code><code class="bash plain">} finally {</code>
</div>
<div class="line number28 index27 alt1">
<code class="bash spaces"> </code><code class="bash plain">try{</code>
</div>
<div class="line number29 index28 alt2">
<code class="bash spaces"> </code><code class="bash keyword">if</code><code class="bash plain">(rs != null) {</code>
</div>
<div class="line number30 index29 alt1">
<code class="bash spaces"> </code><code class="bash plain">rs.close();</code>
</div>
<div class="line number31 index30 alt2">
<code class="bash spaces"> </code><code class="bash plain">rs = null;</code>
</div>
<div class="line number32 index31 alt1">
<code class="bash spaces"> </code><code class="bash plain">}</code>
</div>
<div class="line number33 index32 alt2">
<code class="bash spaces"> </code><code class="bash keyword">if</code><code class="bash plain">(sm != null) {</code>
</div>
<div class="line number34 index33 alt1">
<code class="bash spaces"> </code><code class="bash plain">sm.close();</code>
</div>
<div class="line number35 index34 alt2">
<code class="bash spaces"> </code><code class="bash plain">sm = null;</code>
</div>
<div class="line number36 index35 alt1">
<code class="bash spaces"> </code><code class="bash plain">}</code>
</div>
<div class="line number37 index36 alt2">
<code class="bash spaces"> </code><code class="bash keyword">if</code><code class="bash plain">(conn != null) {</code>
</div>
<div class="line number38 index37 alt1">
<code class="bash spaces"> </code><code class="bash plain">conn.close();</code>
</div>
<div class="line number39 index38 alt2">
<code class="bash spaces"> </code><code class="bash plain">conn = null;</code>
</div>
<div class="line number40 index39 alt1">
<code class="bash spaces"> </code><code class="bash plain">}</code>
</div>
<div class="line number41 index40 alt2">
<code class="bash spaces"> </code><code class="bash plain">} catch(Exception e) {</code>
</div>
<div class="line number42 index41 alt1">
<code class="bash spaces"> </code><code class="bash plain">e.printStackTrace();</code>
</div>
<div class="line number43 index42 alt2">
<code class="bash spaces"> </code><code class="bash plain">}</code>
</div>
<div class="line number44 index43 alt1">
<code class="bash spaces"> </code><code class="bash plain">}</code>
</div>
<div class="line number45 index44 alt2">
</div>
<div class="line number46 index45 alt1">
<code class="bash spaces"> </code><code class="bash plain">}</code>
</div>
<div class="line number47 index46 alt2">
</div>
<div class="line number48 index47 alt1">
<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>
在安装好mysql之后，为在我的mysql中创建了shopping的数据库，并在其中添加了user的表，表结构只有一个int型的id和varchar类型的name.</p>
<p>
到这一步,java开放中的数据库准备基本完成。linux安装软件会比window麻烦，这篇博客也并非符合一切机器，当你遇到困难或者安装失败的时候，请耐心，尽力之后终于有解决办法。</p>
<p>
感谢阅读，希望能帮助到大家，谢谢大家对本站的支持！</p>
<p>
原文链接：http://blog.csdn.net/zhang5476499/article/details/53791710</p>
頁:
[1]