Q: How do I create a user for MTWeb in MySQL?

You can use the MySQL Administrator to create a user. To do so:

1. Launch the MySQL Administrator and sign in with root privileges.
2. Select the User Administration option from the left pane, and click Add new user.
3. Enter a username and a password in the Login Information section under the User Information tab.

   

4. Select the Schema Privileges tab.
5. Click the mtdatabase schemata from the left, and apply SELECT privileges, by selecting the row labeled SELECT and clicking the left arrow button.
6. Verify that SELECT now appears in the Assigned Privileges column.

   

7. Click Apply changes. You should now see a newly created user under the User Accounts group.
8. You must now add a valid host for this user. To do so, right-click the newly created account, located in the User Accounts group, and select Add host from which the user can connect
9. Enter a host name—IP address or DNS such as localhost, and then click OK.

   

Note: Specify the newly created username and password in mtweb.ini file, so that MTWeb could use them.