mysql没有权限_mysql本地用户没有权限

this.p={ m:2,

b:2,

loftPermalink:'',

id:'fks_085065081086087066093084080095080081088066087082082065',

blogTitle:'mysql本地用户没有权限',

blogAbstract:'某一天，我大脑短路，把mysql本地用户权限删掉了。

还好，还有一个可以远程访问的用户让我访问下数据库。

找了网上的贴，很多人说COPY 别的有权限的MYSQL 库考到原来的目录，比如把mysql/data/mysql目录重命名为mysql_old，然后从别的服务器上拷贝mysql目录过来，重启mysql，把mysql_old下的用户表改回来，然后再把mysql_old改为mysql，偶尝试了这种方法，失败，mysql根本不能启动。没办法，只能想别的辙。

用mysql的客户端远程登录mysql，然后把mysql.user表中的本地用户权限一个个改回来。做完这项原始的工作之后，重启mysql，OK，成功了。

敲一下mysql命令，use mysql，ok，也可以，本地用户的权限都回来了！

',

blogTag:'',

blogUrl:'blog/static/4791344220088280242396',

isPublished:1,

istop:false,

type:0,

modifyTime:0,

publishTime:1222575863096,

permalink:'blog/static/4791344220088280242396',

commentCount:0,

mainCommentCount:0,

recommendCount:0,

bsrk:-100,

publisherId:0,

recomBlogHome:false,

currentRecomBlog:false,

attachmentsFileIds:[],

vote:{},

groupInfo:{},

friendstatus:'none',

followstatus:'unFollow',

pubSucc:'',

visitorProvince:'',

visitorCity:'',

visitorNewUser:false,

postAddInfo:{},

mset:'000',

mcon:'',

srk:-100,

remindgoodnightblog:false,

isBlackVisitor:false,

isShowYodaoAd:false,

hostIntro:'',

hmcon:'0',

selfRecomBlogCount:'0',

lofter_single:''

}

{list a as x}

{if !!x}

{if x.visitorName==visitor.userName}

{else}

{/if}

{if x.moveFrom=='wap'}

{elseif x.moveFrom=='iphone'}

{elseif x.moveFrom=='android'}

{elseif x.moveFrom=='mobile'}

{/if}

${fn(x.visitorNickname,8)|escape}

{/if}

{/list}

{if !!a}

${fn(a.nickname,8)|escape}

${a.selfIntro|escape}{if great260}${suplement}{/if}

{/if}

{list a as x}

{if !!x}

推荐过这篇日志的人：

{list a as x}

{if !!x}

{if !!b&&b.length>0}

他们还推荐了：

{list b as y}

{if !!y}

{/if}

{list a as x}

{if !!x}

{list a as x}

{if !!x}

{list a as x}

{if !!x}

{list a as x}

{if x_index>4}{break}{/if}

{if !!x}

${fn1(x.title,60)|escape}${fn2(x.publishTime,'yyyy-MM-dd HH:mm:ss')}

{/if}

{/list}

{list a as x}

{if !!x}

{if !!(blogDetail.preBlogPermalink)}

网易新闻

${headlines.title|escape}

{if defined('newslist')&&newslist.length>0}

{list newslist as x}

{if x_index>7}{break}{/if}

被推荐日志

最新日志

该作者的其他文章

博主推荐

随机阅读

首页推荐

{list a as x}

{if !!x}

${x.nickName|escape}  投票给

{var first_option = true;}

{list x.voteDetailList as voteToOption}

{if voteToOption==1}

{if first_option==false},{/if}  “${b[voteToOption_index]}”

{/if}

{/list}

{if (x.role!="-1") },“我是${c[x.role]}”  {/if}

${fn1(x.voteTime)}

{if x.userName==''}{/if}

{/if}

{/list}