Coupon code copied
Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Get help from a Microsoft Certified Engineer.

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.
Chat Now

How to Create a MySQL User

To create a MySQL User, Open MySQL Workbench

Under Server Administration, click on New Server Instance

Select Remote Host and type in the address of the server

Click Next

Fill in the requested information

  • Hostname – The IP address or hostname for the server
  • Port – 3306 is standard, modify if the server listens on an alternate port
  • Username – Usually root, but any account with similar privileges will work
  • Default Schema – Only if you are connecting to a specific DB instead of the whole server

Click Next

If the database conneciton is successful, hit Next

Leave the Do not use remote management option checked

Click Next

Choose a name for the connection and hit Finish

Connect to the instance that you set up:

Click on the Accounts tab

To add the user:

Click on Add Account

In the Server Access Management tab:

Fill the necessary fields

  • Login Name – The username for the account
  • Password and Confirm Password – Self explanatory

Choose any Administrative Roles you wish for the account to have

Set any Account Limits you wish for the account to have

Hit Apply

To grant the user privileges to specific databases:

Click on the Schema Privileges tab

Click on Add Entry

Options:

  • Any Schema – Grants privileges throughout the whole server
  • Schemas matching pattern or name – Generally not something we use, if the customer wants it they’ll specify it
  • Selected schema – Lets you choose a specific schema

Hit Ok

Choose the privileges thet you wish to give the user

Don’t assign GRANT privileges unless sepcifically requested by customer

Hit Save Changes

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST

Chat Now

Start Your Order

X

This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.