当前位置：网站首页>4. MySQL workbench create access user

4. MySQL workbench create access user

2022-04-21 22:44:00 【How to chase Capricorn】

One 、 Create user

1、 open MySQL Workbench, choice Server->Users and Privilegs

2、 Click on “Add Account”, Enter login and password , Click on “Apply”

 

Create success

Two 、 Assign permissions

1、 Click the user just created , choice “Schema Privileges”, Click on “Add Entry”

 2、 choice “Selected schema”, Select a database , Click on “OK”

 3、“Object Rights” Future generations , Click on “Apply”

  3、 ... and 、 Create a new connection

1、 Click on “ A small house ” Back to the main interface , Click on “+” Number , Enter the connection name , Enter the user name you just created , Click on “OK” 

 2、 Click to connect , Input password , Click on OK

 3、 Access to database , Have just assigned test database

 

版权声明
本文为[How to chase Capricorn]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204212036058691.html

边栏推荐

猜你喜欢

随机推荐