Home > Database > Mysql Tutorial > Ubuntu MySQL的root用户权限被删除解决思路

Ubuntu MySQL的root用户权限被删除解决思路

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 16:55:29
Original
1127 people have browsed it

目前来说只有两种:1、跳过授权表启动MySQL:Windows或者Ubuntu等Linux下都可以用MySQLD --SKIP-GRANT-TABLES

目前来说只有两种:

1、跳过授权表启动MySQL:

Windows或者Ubuntu等Linux下都可以用

MySQLD --SKIP-GRANT-TABLES

来启动 MySQL。

这个时候你对所有的表都具有操作权限。

更新的MySQL.USER表的所有字段中为N的为Y就可以了。

2、就是COPY 别的有权限的MySQL 库考到你原来的目录:

不过原来的一定要备份。

之后的操作和上面的一样。

linux

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
MySQL stops process
From 1970-01-01 08:00:00
0
0
0
Error when installing mysql on linux
From 1970-01-01 08:00:00
0
0
0
phpstudy cannot start mysql?
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template