时间:2021-07-01 10:21:17 帮助过:20人阅读
- <ol class="linenums"><li class="L0"><code class="language-sh"><span class="pln">mysql</span><span class="pun">></span><span class="kwd">set</span><span class="pln"> password </span></code></li><li class="L1"><code class="language-sh"><span class="pln">mysql</span><span class="pun">></span><span class="pln">update mysql</span><span class="pun">.</span><span class="pln">user </span><span class="kwd">set</span><span class="pln"> password</span><span class="pun">=</span><span class="pln">PASSWORD</span><span class="pun">(</span><span class="str">‘password‘</span><span class="pun">)</span><span class="pln"> where clausse</span><span class="pun">;</span></code></li><li class="L2"><code class="language-sh"><span class="pln">mysql</span><span class="pun">></span><span class="pln">flush privileges</span><span class="pun">;</span></code></li><li class="L3"><code class="language-sh"><span class="com">#mysqladmin ...</span></code></li></ol>
- <ol class="linenums"><li class="L0"><code class="language-sh"><span class="pln">mysql</span><span class="pun">></span><span class="pln">drop user </span><span class="str">‘‘</span><span class="pun">@</span><span class="str">‘localhost‘</span><span class="pun">;</span></code></li><li class="L0"><code class="language-sh"><span class="pun">同样也可以通过mysql_sequre_installation来实现用户加密和删除</span></code></li></ol>
- <ol class="linenums"><li class="L0"><code class="language-sh"><span class="pun">[</span><span class="pln">root@localhost </span><span class="pun">~]#</span><span class="pln"> mysql </span><span class="pun">--</span><span class="pln">verbos </span><span class="pun">--</span><span class="pln">help #查看所有帮助信息</span></code></li></ol>
注意:其中有些参数支持运行时修改,会立即生效;有些参数不支持,切只支持修改配置文件然后重启服务才能生效 有些参数的作用域是全局的,切不可修改;有些可以为每个用户提供单独的设置
- <ol class="linenums"><li class="L0"><code class="language-sh"><span class="typ">MariaDB</span><span class="pln"> </span><span class="pun">[(</span><span class="pln">none</span><span class="pun">)]></span><span class="pln"> show variables</span><span class="pun">;</span></code></li></ol>
- <ol class="linenums"><li class="L0"><code class="language-sh"><span class="typ">MariaDB</span><span class="pln"> </span><span class="pun">[(</span><span class="pln">none</span><span class="pun">)]></span><span class="pln"> help </span><span class="kwd">set</span><span class="pun">; #查看set的帮助信息</span></code></li><li class="L0"><code class="language-sh"><span class="pun">Name: ‘SET‘
- Description:
- Syntax:
- SET variable_assignment [, variable_assignment] ...
- variable_assignment:
- user_var_name = expr
- | [GLOBAL | SESSION] system_var_name = expr
- | [@@global. | @@session. | @@]system_var_name = expr</span></code></li></ol>
- <ol class="linenums"><li class="L0"><code class="language-sh"><span class="typ">MariaDB</span><span class="pln"> </span><span class="pun">[(</span><span class="pln">none</span><span class="pun">)]></span><span class="pln"> </span><span class="kwd">set</span><span class="pln"> global system_var_name </span><span class="pun">=</span><span class="pln"> value</span><span class="pun">;</span></code></li><li class="L1"><code class="language-sh"><span class="typ">MariaDB</span><span class="pln"> </span><span class="pun">[(</span><span class="pln">none</span><span class="pun">)]></span><span class="pln"> </span><span class="kwd">set</span><span class="pln"> </span><span class="pun">@</span><span class="lit">@global</span><span class="pun">.</span><span class="pln">system_var_name</span><span class="pun">=</span><span class="pln">value</span><span class="pun">;</span></code></li></ol>
- <ol class="linenums"><li class="L0"><code class="language-sh"><span class="typ">MariaDB</span><span class="pln"> </span><span class="pun">[(</span><span class="pln">none</span><span class="pun">)]></span><span class="pln"> </span><span class="kwd">set</span><span class="pln"> </span><span class="pun">[</span><span class="pln">session</span><span class="pun">]</span><span class="pln"> system_var_name</span><span class="pun">=</span><span class="pln">value</span><span class="pun">;</span></code></li><li class="L0"><code class="language-sh"><span class="pun">MariaDB [(none)]> set @@[session.]system_var_name=value;</span></code></li></ol>
- <ol class="linenums"><li class="L0"><code class="language-sh"><span class="typ">MariaDB</span><span class="pln"> </span><span class="pun">[(</span><span class="pln">none</span><span class="pun">)]></span><span class="pln"> </span><span class="kwd">set</span><span class="pln"> global status</span><span class="pun">;</span></code></li><li class="L1"><code class="language-sh"><span class="typ">MariaDB</span><span class="pln"> </span><span class="pun">[(</span><span class="pln">none</span><span class="pun">)]></span><span class="pln"> </span><span class="kwd">set</span><span class="pln"> </span><span class="pun">[</span><span class="pln">session</span><span class="pun">]</span><span class="pln"> global status</span><span class="pun">;</span></code></li></ol>
mysql之一
标签:连接线 ppa 关闭 mariadb sign database oca 判断 表结构