doulai8405 2015-06-20 01:08
浏览 38

MySQL Workbench中的数据库权限不一致?

I am trying to add another user, in addition to root to my database. So, I did the following in MySQL Workbench:

enter image description here

  • clicked on the tab called "Management" shown in picture, and then clicked on "Users and Priveleges".

  • Then I clicked "add account" in the lower left hand corner, and entered a user name and password, and of course it shows up in the pane on the LHS.

However, then I go into the tab called "Schemas", also shown in the piccutre above, and I click on the "i" with a circle around it, as shown in the picture below.

enter image description here

  • Then, I click on the tab that says "Grants" and see if I'm there. but I'm not. How do I add my username?

I refreshed everything multiple times, so that isn't an issue.

The way I got to this problem was: I tried to access the DB using python mysql package, I get the common error:

_mysql_exceptions.OperationalError: (1044, "Access denied for user...

...which is why I went and added a user and tried to check the grants.

How do I change the permissions? Thanks.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 怎么在stm32门禁成品上增加记录功能
    • ¥15 Source insight编写代码后使用CCS5.2版本import之后,代码跳到注释行里面
    • ¥50 NT4.0系统 STOP:0X0000007B
    • ¥15 想问一下stata17中这段代码哪里有问题呀
    • ¥15 flink cdc无法实时同步mysql数据
    • ¥100 有人会搭建GPT-J-6B框架吗?有偿
    • ¥15 求差集那个函数有问题,有无佬可以解决
    • ¥15 【提问】基于Invest的水源涵养
    • ¥20 微信网友居然可以通过vx号找到我绑的手机号
    • ¥15 寻一个支付宝扫码远程授权登录的软件助手app