home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
General Forums
Newcomers Forum
MediaPortal 1.2.2 and SSHD2
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="mm1352000" data-source="post: 831073" data-attributes="member: 82144"><p>Hi again</p><p></p><p>I use MySQL Workbench.</p><p></p><p>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.</p><p></p><p>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).</p><p></p><p>Finally, you need to create the appropriate schema privileges (see create_privilege.png and user_privilege.png).</p><p></p><p>The user must have SELECT on the "mysql" and "information_schema" databases as well.</p><p></p><p>Hopefully you can follow that...</p><p>mm</p></blockquote><p></p>
[QUOTE="mm1352000, post: 831073, member: 82144"] 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 [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
General Forums
Newcomers Forum
MediaPortal 1.2.2 and SSHD2
Contact us
RSS
Top
Bottom
