- September 1, 2008
- 21,544
- 8,236
- Home Country
-
New Zealand
Hi again
I use MySQL Workbench.
First, you must log in as root and create the schema in the "SQL Development" section (see create_schema1.png and create_schema2.png). Use right click to bring up the "create schema..." option.
Then you can use the "Server Administration" section to create a user for the schema (see user_account1.png, user_account2.png and user_account3.png).
Finally, you need to create the appropriate schema privileges (see create_privilege.png and user_privilege.png).
The user must have SELECT on the "mysql" and "information_schema" databases as well.
Hopefully you can follow that...
mm
I use MySQL Workbench.
First, you must log in as root and create the schema in the "SQL Development" section (see create_schema1.png and create_schema2.png). Use right click to bring up the "create schema..." option.
Then you can use the "Server Administration" section to create a user for the schema (see user_account1.png, user_account2.png and user_account3.png).
Finally, you need to create the appropriate schema privileges (see create_privilege.png and user_privilege.png).
The user must have SELECT on the "mysql" and "information_schema" databases as well.
Hopefully you can follow that...
mm
