InMotion Hosting Support Center

Databases are created and maintained using MySQL. Another MySQL function is to verify credentials and permissions.

First, to initiate a connection to a database, MySQL must authenticate a database user and password combination (as well as the hostname from which the request was made).

Once the connection is authorized, commands to manipulate a particular database are validated. During validation, MySQL checks that privileges have been granted to the specified database for the database user.

The database user privileges need to be granted before MySQL will allow that user to execute the request on the database. MySQL maintains these privileges in its own database table mysql.

Common Privileges

The table below displays the most common MySQL user privileges that can be assigned to a database user.

MySQL Privileges
ALTER DELETE LOCK TABLES
ALTER ROUTINE DROP REFERENCES
CREATE EVENT SELECT
CREATE ROUTINE EXECUTE SHOW VIEW
CREATE TEMPORARY TABLES INDEX TRIGGER
CREATE VIEW INSERT UPDATE

To learn more about Database User Privileges check out the official MySQL documentation here. You can also learn how to create a database user and assign it privileges from the command line.

Was this article helpful?

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Forum Login

You are NOT logged in. You can still browse our Support Center.

To participate within our Community Support Forum:

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

0 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!