嗨, 大家好: 网站在新年后正式开通,欢迎大家加入我们,共同维护一个良好氛围的中国技术社区。 欢迎举报不良帖子,欢迎提供建议。
我们的QQ群:136102234,欢迎进群找答案,里边会有很多资深的大师们。 point overflow

使用命令行登录的时候,直接mysql就能进入mysql命令行界面。

但是很多时候却没有这个情况?

这该如何处理?

asked 2016-03-08 11:45:15

%E6%88%91%E6%9C%89%E4%B8%80%E5%8F%AA%E5%B0%8F%E6%AF%9B%E9%A9%B4's gravatar image

我有一只小毛驴
11112
accept rate: 0%


登录后,看看information_schema.processlist 是不是空用户?

如果是的话,删除mysql.user表里边的user=''的用户,然后flush privileges;

link

answered 2016-03-08 16:39:32

jkant's gravatar image

jkant ♦♦
11134138139
accept rate: 3%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×1

Asked: 2016-03-08 11:45:15

Seen: 1,014 times

Last updated: 2016-03-08 16:39:32

Related questions