php - Database permissions in MySQL Workbench inconsistent? -


i trying add user, in addition root database. so, did following in mysql workbench:

enter image description here

  • clicked on tab called "management" shown in picture, , clicked on "users , priveleges".

  • then clicked "add account" in lower left hand corner, , entered user name , password, , of course shows in pane on lhs.

however, go tab called "schemas", shown in piccutre above, , click on "i" circle around it, shown in picture below.

enter image description here

  • then, click on tab says "grants" , see if i'm there. i'm not. how add username?

i refreshed multiple times, isn't issue.

the way got problem was: tried access db using python mysql package, common error:

_mysql_exceptions.operationalerror: (1044, "access denied user... 

...which why went , added user , tried check grants.

how change permissions? thanks.


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -