WINISME - 个人工作知识笔记

标题

类别

是否隐藏

内容详情

在操作mysql时误删除root用户，如何进行恢复在安装hive时候误删除root用户，存在的用户没有权限，解决方法如下。1、首先在/etc/my.cnf文件中 mysqlID下面添加<div class="cnblogs_code"><pre>skip-grant-tables</pre></div>用来跳过安全密码验证2、在服务上重启mysql服务<div class="cnblogs_code"><pre>[root@master2 bin]# systemctl restart mysqld.service</pre></div>3、使用mysql直接进入mysql<div class="cnblogs_code"><pre>[root@master2 bin]# mysql</pre></div>4、使用mysql数据库<div class="cnblogs_code"><pre>mysql&gt; use mysql;</pre></div>&nbsp;5、重新添加用户<div class="cnblogs_code"><pre>insert into user(user,host,password,ssl_type,ssl_cipher,x509_issuer,x509_subject) values('root','localhost',PASSWORD('MyPass@123'),'','','','');</pre></div>6、对新添加用户进行授权<div class="cnblogs_code"><pre>mysql&gt; grant all privileges on *.* to root@"loaclhost" identified by 'MyPass@123';</pre></div>此时报错，因为处于skip-grant-tables<div class="cnblogs_code"><pre>ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement</pre></div>解决：先执行<div class="cnblogs_code"><pre>flush privileges;</pre></div>再执行<div class="cnblogs_code"><pre>mysql&gt; grant all privileges on *.* to root@"loaclhost" identified by 'MyPass@123';</pre><pre>flush privileges;</pre></div>此时查看新添加用户的权限<div class="cnblogs_code"><pre>mysql&gt; select * from mysql.user where user='root'\G;</pre></div><img src="https://img2018.cnblogs.com/blog/1593919/201903/1593919-20190301114129026-603826713.png" alt="">此时退出mysql，在服务上的/etc/my.cnf文件上删除掉skip-grant-tables重启mysql服务<div class="cnblogs_code"><pre>[root@master2 bin]# vim /etc/my.cnf
[root@master2 bin]# systemctl restart mysqld.service</pre></div>重新初始化<div class="cnblogs_code">[root@master2 bin]# schematool -initSchema -dbType mysql 原文连接&nbsp;https://www.cnblogs.com/learn-bigdata/p/10454976.html</div>