-
数据库
站-
热门城市 全国站>
-
其他省市
-
-
400-636-0069
小标
2018-11-13
来源 ：
阅读 1050
评论 0
摘要：本文主要向大家介绍了MySQL数据库之关于连接mysql数据库时出现的时区错误timezone的解决办法 ，通过具体的内容向大家展现，希望对大家学习MySQL数据库有所帮助。
本文主要向大家介绍了MySQL数据库之关于连接mysql数据库时出现的时区错误timezone的解决办法 ，通过具体的内容向大家展现，希望对大家学习MySQL数据库有所帮助。
<
<p>错误来源：<a href="https://www.2cto.com/database/MySQL/" target="_blank" class="keylink">mysql</a>运行报The server time zone value ‘D1ú±ê×ê±’ is unrecognized or represents more than one time zone的解决方法</p>
<p>sql 命令结尾要加分后！！！</p>
<p>mysqldump 命令需要在cmd窗口cd到mysqldump.exe 所在目下下执行。</p>
<p>(一) 连接MYSQL：</p>
<p>格式： mysql -h主机地址 -u用户名 －p用户密码</p>
<p>1、例1：连接到本机上的MYSQL</p>
<p>首先在打开DOS窗口，然后进入mysql安装目录下的bin目录下，例如： D:/mysql/bin，再键入命令mysql -uroot -p，回车后提示你输密码，如果刚安装好MYSQL，超级用户root是没有密码的，故直接回车即可进入到MYSQL中了，MYSQL的提示符是：mysql></p>
<p>2、例2：连接到远程主机上的MYSQL (远程：IP地址)</p>
<p>假设远程主机的IP为：10.0.0.1，用户名为root,密码为123。则键入以下命令：</p>
<p>mysql -h10.0.0.1 -uroot -p123</p>
<p>（注：u与root可以不用加空格，其它也一样）</p>
<p>3、退出MYSQL命令</p>
<p>exit （回车）</p>
<p>(二) 修改密码：</p>
<p>格式：mysqladmin -u用户名 -p旧密码 password 新密码</p>
<p>1、例1：给root加个密码123。首先在DOS下进入目录C:/mysql/bin，然后键入以下命令：</p>
<p>mysqladmin -uroot -password 123</p>
<p>注：因为开始时root没有密码，所以-p旧密码一项就可以省略了。</p>
<p>2、例2：再将root的密码改为456</p>
<p>mysqladmin -uroot -pab12 password 456</p>
<p>(三) 增加新用户：（注意：和上面不同，下面的因为是MYSQL环境中的命令，所以后面都带一个分号作为命令结束符）</p>
<p>格式：grant select on <a href="https://www.2cto.com/database/" target="_blank" class="keylink">数据库</a>.* to 用户名@登录主机 identified by “密码”</p>
<p>例1、增加一个用户test1密码为abc，让他可以在任何主机上登录，并对所有数据库有查询、插入、修改、删除的权限。首先用以root用户连入MYSQL，然后键入以下命令： grant select,insert,update,delete on <em>.</em> to test2@localhost identified by “abc”;</p>
<p>如果你不想test2有密码，可以再打一个命令将密码消掉。 grant select,insert,update,delete on mydb.* to test2@localhost identified by “”;</p>
<p>(四) 显示命令</p>
<p>1、显示数据库列表：</p>
<p>show databases; 刚开始时才两个数据库：mysql和test。mysql库很重要它里面有MYSQL的<a href="https://www.2cto.com/os/" target="_blank" class="keylink">系统</a>信息，我们改密码和新增用户，实际上就是用这个库进行操作。</p>
<p>2、显示库中的数据表：</p>
<p>use mysql； //打开库 show tables;</p>
<p>3、显示数据表的结构：</p>
<p>describe 表名;</p>
<p>4、建库：</p>
<p>create database 库名;</p>
<p>5、建表：</p>
<p>use 库名； create table 表名 (字段设定列表)；</p>
<p>6、删库和删表:</p>
<p>drop database 库名; drop table 表名；</p>
<p>7、将表中记录清空：</p>
<p>delete from 表名;</p>
<p>8、显示表中的记录：</p>
<p>select * from 表名;</p>
<p>导出sql脚本</p>
<p>mysqldump -u 用户名 -p 数据库名 > 存放位置</p>
<p>mysqldump -u root -p test > c:/a.sql</p>
<p>MySQL导出导入命令的用例</p>
<p>1.导出整个数据库</p>
<p>mysqldump -u 用户名 -p 数据库名 > 导出的文件名</p>
<p>mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql</p>
<p>2.导出一个表</p>
<p>mysqldump -u 用户名 -p 数据库名表名> 导出的文件名</p>
<p>mysqldump -u wcnc -p smgp_apps_wcnc users> wcnc_users.sql</p>
<p>3.导出一个数据库结构</p>
<p>mysqldump -u wcnc -p -d –add-drop-table smgp_apps_wcnc >d:wcnc_db.sql</p>
<p>-d 没有数据 –add-drop-table 在每个create语句之前增加一个drop table</p>
<p>4.导入数据库</p>
<p>常用source 命令</p>
<p>进入my<a href="https://www.2cto.com/database/" target="_blank" class="keylink">sql数据库</a>控制台,</p>
<p>如mysql -u root -p</p>
<p>mysql>use 数据库</p>
<p>然后使用source命令,后面参数为脚本文件(如这里用到的.sql)</p>
<p>mysql>source d:wcnc_db.sql</p>
<p>mysql运行报The server time zone value ‘D1ú±ê×ê±’ is unrecognized or represents more than one time zone的解决方法</p>
<p>set global time_zone=”+8:00”; //修改时区为北京时区</p>
<div><div id="highlighter_697808" class="syntaxhighlighter sql"><div class="toolbar"><span><a href="#" class="toolbar_item command_help help">?</a></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><div class="line number79 index78 alt2">79</div><div class="line number80 index79 alt1">80</div><div class="line number81 index80 alt2">81</div><div class="line number82 index81 alt1">82</div><div class="line number83 index82 alt2">83</div><div class="line number84 index83 alt1">84</div><div class="line number85 index84 alt2">85</div><div class="line number86 index85 alt1">86</div><div class="line number87 index86 alt2">87</div><div class="line number88 index87 alt1">88</div><div class="line number89 index88 alt2">89</div><div class="line number90 index89 alt1">90</div><div class="line number91 index90 alt2">91</div><div class="line number92 index91 alt1">92</div><div class="line number93 index92 alt2">93</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="sql plain">import java.sql.</code><code class="sql keyword">Connection</code><code class="sql plain">;</code></div><div class="line number2 index1 alt1"><code class="sql plain">import java.sql.DriverManager;</code></div><div class="line number3 index2 alt2"><code class="sql plain">import java.sql.PreparedStatement;</code></div><div class="line number4 index3 alt1"><code class="sql plain">import java.sql.ResultSet;</code></div><div class="line number5 index4 alt2"><code class="sql plain">import java.sql.SQLException;</code></div><div class="line number6 index5 alt1"><code class="sql plain">import java.sql.Statement;</code></div><div class="line number7 index6 alt2"> </div><div class="line number8 index7 alt1"><code class="sql keyword">public</code> <code class="sql plain">class DatabaseBean {</code></div><div class="line number9 index8 alt2"> </div><div class="line number10 index9 alt1"><code class="sql spaces"> </code><code class="sql plain">/**</code></div><div class="line number11 index10 alt2"><code class="sql spaces"> </code><code class="sql plain">* 获取数据库连接对象</code></div><div class="line number12 index11 alt1"><code class="sql spaces"> </code><code class="sql plain">* @</code><code class="sql keyword">return</code> <code class="sql keyword">Connection</code></div><div class="line number13 index12 alt2"><code class="sql spaces"> </code><code class="sql plain">*/</code></div><div class="line number14 index13 alt1"><code class="sql spaces"> </code><code class="sql keyword">public</code> <code class="sql keyword">static</code> <code class="sql keyword">Connection</code> <code class="sql plain">getConnection(){</code></div><div class="line number15 index14 alt2"> </div><div class="line number16 index15 alt1"><code class="sql spaces"> </code><code class="sql keyword">Connection</code> <code class="sql plain">conn = </code><code class="sql color1">null</code><code class="sql plain">;</code></div><div class="line number17 index16 alt2"><code class="sql spaces"> </code><code class="sql plain">String driver = </code><code class="sql string">"com.mysql.cj.jdbc.Driver"</code><code class="sql plain">;</code></div><div class="line number18 index17 alt1"><code class="sql spaces"> </code><code class="sql plain">String url = </code><code class="sql string">"jdbc:<a href="mysql://localhost:3306/shop_db">mysql://localhost:3306/shop_db</a>"</code><code class="sql plain">;</code></div><div class="line number19 index18 alt2"><code class="sql spaces"> </code><code class="sql plain">String </code><code class="sql color2">user</code> <code class="sql plain">= </code><code class="sql string">"root"</code><code class="sql plain">;</code></div><div class="line number20 index19 alt1"><code class="sql spaces"> </code><code class="sql plain">String pwd = </code><code class="sql string">"mysql"</code><code class="sql plain">;</code></div><div class="line number21 index20 alt2"><code class="sql spaces"> </code><code class="sql plain">try { </code></div><div class="line number22 index21 alt1"><code class="sql spaces"> </code><code class="sql plain">Class.forName(driver);</code></div><div class="line number23 index22 alt2"><code class="sql spaces"> </code><code class="sql plain">System.</code><code class="sql keyword">out</code><code class="sql plain">.println(</code><code class="sql string">"com here"</code><code class="sql plain">);</code></div><div class="line number24 index23 alt1"><code class="sql spaces"> </code><code class="sql plain">conn = DriverManager.getConnection(url, </code><code class="sql color2">user</code><code class="sql plain">, pwd);</code></div><div class="line number25 index24 alt2"><code class="sql spaces"> </code><code class="sql plain">System.</code><code class="sql keyword">out</code><code class="sql plain">.println(</code><code class="sql string">"conn "</code> <code class="sql plain">+ conn);</code></div><div class="line number26 index25 alt1"><code class="sql spaces"> </code><code class="sql plain">} catch (SQLException ex) {</code></div><div class="line number27 index26 alt2"><code class="sql spaces"> </code><code class="sql plain">ex.printStackTrace();</code></div><div class="line number28 index27 alt1"><code class="sql spaces"> </code><code class="sql plain">} catch(Exception e) {</code></div><div class="line number29 index28 alt2"> </div><div class="line number30 index29 alt1"><code class="sql spaces"> </code><code class="sql plain">}</code></div><div class="line number31 index30 alt2"><code class="sql spaces"> </code><code class="sql keyword">return</code> <code class="sql plain">conn;</code></div><div class="line number32 index31 alt1"> </div><div class="line number33 index32 alt2"><code class="sql spaces"> </code><code class="sql plain">}</code></div><div class="line number34 index33 alt1"> </div><div class="line number35 index34 alt2"><code class="sql spaces"> </code><code class="sql plain">/**</code></div><div class="line number36 index35 alt1"><code class="sql spaces"> </code><code class="sql plain">* 释放数据库连接资源</code></div><div class="line number37 index36 alt2"><code class="sql spaces"> </code><code class="sql plain">* @param rs</code></div><div class="line number38 index37 alt1"><code class="sql spaces"> </code><code class="sql plain">* @param psmt</code></div><div class="line number39 index38 alt2"><code class="sql spaces"> </code><code class="sql plain">* @param conn </code></div><div class="line number40 index39 alt1"><code class="sql spaces"> </code><code class="sql plain">*/</code></div><div class="line number41 index40 alt2"><code class="sql spaces"> </code><code class="sql keyword">public</code> <code class="sql keyword">static</code> <code class="sql plain">void release(ResultSet rs, PreparedStatement psmt, </code><code class="sql keyword">Connection</code> <code class="sql plain">conn) {</code></div><div class="line number42 index41 alt1"><code class="sql spaces"> </code><code class="sql plain">try {</code></div><div class="line number43 index42 alt2"><code class="sql spaces"> </code><code class="sql plain">if (rs != </code><code class="sql color1">null</code><code class="sql plain">) {</code></div><div class="line number44 index43 alt1"><code class="sql spaces"> </code><code class="sql plain">rs.</code><code class="sql keyword">close</code><code class="sql plain">();</code></div><div class="line number45 index44 alt2"><code class="sql spaces"> </code><code class="sql plain">}</code></div><div class="line number46 index45 alt1"><code class="sql spaces"> </code><code class="sql plain">if (psmt != </code><code class="sql color1">null</code><code class="sql plain">) {</code></div><div class="line number47 index46 alt2"><code class="sql spaces"> </code><code class="sql plain">psmt.</code><code class="sql keyword">close</code><code class="sql plain">();</code></div><div class="line number48 index47 alt1"><code class="sql spaces"> </code><code class="sql plain">}</code></div><div class="line number49 index48 alt2"><code class="sql spaces"> </code><code class="sql plain">if (conn != </code><code class="sql color1">null</code><code class="sql plain">) {</code></div><div class="line number50 index49 alt1"><code class="sql spaces"> </code><code class="sql plain">conn.</code><code class="sql keyword">close</code><code class="sql plain">();</code></div><div class="line number51 index50 alt2"><code class="sql spaces"> </code><code class="sql plain">}</code></div><div class="line number52 index51 alt1"><code class="sql spaces"> </code><code class="sql plain">} catch (SQLException ex) {</code></div><div class="line number53 index52 alt2"><code class="sql spaces"> </code><code class="sql plain">ex.printStackTrace();</code></div><div class="line number54 index53 alt1"><code class="sql spaces"> </code><code class="sql plain">}</code></div><div class="line number55 index54 alt2"><code class="sql spaces"> </code><code class="sql plain">}</code></div><div class="line number56 index55 alt1"> </div><div class="line number57 index56 alt2"><code class="sql spaces"> </code><code class="sql plain">/**</code></div><div class="line number58 index57 alt1"><code class="sql spaces"> </code><code class="sql plain">* 释放数据库连接资源</code></div><div class="line number59 index58 alt2"><code class="sql spaces"> </code><code class="sql plain">* @param psmt</code></div><div class="line number60 index59 alt1"><code class="sql spaces"> </code><code class="sql plain">* @param conn </code></div><div class="line number61 index60 alt2"><code class="sql spaces"> </code><code class="sql plain">*/</code></div><div class="line number62 index61 alt1"><code class="sql spaces"> </code><code class="sql keyword">public</code> <code class="sql keyword">static</code> <code class="sql plain">void release(PreparedStatement psmt, </code><code class="sql keyword">Connection</code> <code class="sql plain">conn) {</code></div><div class="line number63 index62 alt2"><code class="sql spaces"> </code><code class="sql plain">try {</code></div><div class="line number64 index63 alt1"><code class="sql spaces"> </code><code class="sql plain">if (psmt != </code><code class="sql color1">null</code><code class="sql plain">) {</code></div><div class="line number65 index64 alt2"><code class="sql spaces"> </code><code class="sql plain">psmt.</code><code class="sql keyword">close</code><code class="sql plain">();</code></div><div class="line number66 index65 alt1"><code class="sql spaces"> </code><code class="sql plain">}</code></div><div class="line number67 index66 alt2"><code class="sql spaces"> </code><code class="sql plain">if (conn != </code><code class="sql color1">null</code><code class="sql plain">) {</code></div><div class="line number68 index67 alt1"><code class="sql spaces"> </code><code class="sql plain">conn.</code><code class="sql keyword">close</code><code class="sql plain">();</code></div><div class="line number69 index68 alt2"><code class="sql spaces"> </code><code class="sql plain">}</code></div><div class="line number70 index69 alt1"><code class="sql spaces"> </code><code class="sql plain">} catch (SQLException ex) {</code></div><div class="line number71 index70 alt2"><code class="sql spaces"> </code><code class="sql plain">ex.printStackTrace();</code></div><div class="line number72 index71 alt1"><code class="sql spaces"> </code><code class="sql plain">}</code></div><div class="line number73 index72 alt2"><code class="sql spaces"> </code><code class="sql plain">}</code></div><div class="line number74 index73 alt1"> </div><div class="line number75 index74 alt2"><code class="sql spaces"> </code><code class="sql keyword">public</code> <code class="sql keyword">static</code> <code class="sql plain">void main(String[] args) throws SQLException {</code></div><div class="line number76 index75 alt1"> </div><div class="line number77 index76 alt2"><code class="sql spaces"> </code><code class="sql keyword">Connection</code> <code class="sql plain">conn = DatabaseBean.getConnection();</code></div><div class="line number78 index77 alt1"> </div><div class="line number79 index78 alt2"><code class="sql spaces"> </code><code class="sql plain">if (conn == </code><code class="sql color1">null</code><code class="sql plain">) {</code></div><div class="line number80 index79 alt1"><code class="sql spaces"> </code><code class="sql plain">System.</code><code class="sql keyword">out</code><code class="sql plain">.println(</code><code class="sql string">"connection 为null"</code><code class="sql plain">);</code></div><div class="line number81 index80 alt2"><code class="sql spaces"> </code><code class="sql plain">}</code></div><div class="line number82 index81 alt1"><code class="sql spaces"> </code><code class="sql plain">String sql = </code><code class="sql string">"select * from tb_customer"</code><code class="sql plain">;</code></div><div class="line number83 index82 alt2"><code class="sql spaces"> </code><code class="sql plain">PreparedStatement psmt = conn.prepareStatement(sql);</code></div><div class="line number84 index83 alt1"><code class="sql spaces"> </code><code class="sql plain">ResultSet rs = psmt.executeQuery();</code></div><div class="line number85 index84 alt2"><code class="sql spaces"> </code><code class="sql plain">while (rs.</code><code class="sql keyword">next</code><code class="sql plain">()) {</code></div><div class="line number86 index85 alt1"><code class="sql spaces"> </code><code class="sql plain">System.</code><code class="sql keyword">out</code><code class="sql plain">.println(</code><code class="sql string">"cid "</code> <code class="sql plain">+ rs.getInt(</code><code class="sql string">"cid"</code><code class="sql plain">));</code></div><div class="line number87 index86 alt2"><code class="sql spaces"> </code><code class="sql plain">System.</code><code class="sql keyword">out</code><code class="sql plain">.println(</code><code class="sql string">"cname "</code> <code class="sql plain">+ rs.getString(</code><code class="sql string">"cname"</code><code class="sql plain">));</code></div><div class="line number88 index87 alt1"><code class="sql spaces"> </code><code class="sql plain">}</code></div><div class="line number89 index88 alt2"> </div><div class="line number90 index89 alt1"><code class="sql spaces"> </code><code class="sql plain">}</code></div><div class="line number91 index90 alt2"> </div><div class="line number92 index91 alt1"> </div><div class="line number93 index92 alt2"><code class="sql plain">}</code></div></div></td></tr></tbody></table></div></div>
本文由职坐标整理并发布，希望对同学们学习MySQL有所帮助，更多内容请关注职坐标数据库MySQL数据库频道！
喜欢 | 0
不喜欢 | 0
您输入的评论内容中包含违禁敏感词
我知道了
请输入正确的手机号码
请输入正确的验证码
您今天的短信下发次数太多了，明天再试试吧！
我们会在第一时间安排职业规划师联系您！
您也可以联系我们的职业规划师咨询：
版权所有 职坐标-一站式IT培训就业服务领导者 沪ICP备13042190号-4
上海海同信息科技有限公司 Copyright ©2015 www.zhizuobiao.com，All Rights Reserved.
沪公网安备 31011502005948号
索取资料
答疑解惑
技术交流
职业测评
面试技巧
高薪秘笈
