I am trying to add another user, in addition to root
to my database. So, I did the following in MySQL Workbench:
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.
- 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.