时间:2021-07-01 10:21:17 帮助过:3人阅读
登录数据库
- <code class="hljs nginx"><span class="hljs-attribute">mysql -u root -p</span></code>
使用MYSQL数据库
- <code class="hljs nginx"><span class="hljs-attribute">use mysql</span></code>
查询MYSQL的root用户情况
- <code class="hljs sql"><span class="hljs-keyword">select host, <span class="hljs-keyword">user, <span class="hljs-keyword">plugin <span class="hljs-keyword">from <span class="hljs-keyword">user;</span></span></span></span></span></code>
修改root用户插件验证方式
- <code class="hljs sql"><span class="hljs-keyword">ALTER <span class="hljs-keyword">USER <span class="hljs-string">‘root‘@<span class="hljs-string">‘%‘ <span class="hljs-keyword">IDENTIFIED <span class="hljs-keyword">WITH mysql_native_password <span class="hljs-keyword">BY <span class="hljs-string">‘xxxxxxxxxx‘;</span></span></span></span></span></span></span></span></code>
刷新权限
分类: Docker&Kubernetes
- <code class="hljs sql"><span class="hljs-keyword">FLUSH <span class="hljs-keyword">PRIVILEGES;</span></span></code>
Docker For MYSQL 8.0 特别注意修复数据库新的验证方式
标签:info com mysql pass 用户 href down logs uber