Activities in MySQL Laboratory: Security for the Database

There are guidelines to access your databases and you can create your own user and set your own password that no one can access but you.

Here are the examples:

Create user:

This statement creates new user accounts in mysql.

Grant:

The grant statement gives you the power to enable all, or a selection of, user privileges for a database or for a specific table.

Revoke:

Enables administrators to remove account privileges to access the user.

Account Management

It is stored in the tables of the mysql database.

CREATE USER

This statement creates new user accounts in mysql.

The grant statement gives you the power to enable all, or a selection of, user privileges for a database or for a specific table.

This statement state the syntax of renaming the user in your mysql.

Enables administrators to remove account privileges to access the user.

This statement removes one or more user accounts.

This statement assigns a password to an existing user account.

Privilages System

Some commands:

Select_priv Permission to run SELECT queries

Insert_priv Permission to run INSERT statements

Update_priv Permission to run UPDATE statements

Delete_priv Permission to run DELETE statements

Create_priv Permission to CREATE tables and databases

Drop_priv Permission to DROP tables and databases

Reload_priv Permission to RELOAD the database (a FLUSH statement for example)

Shutdown_priv Permission to SHUTDOWN the database server

Process_priv Permission to view or kill PROCESSes.

File_priv Permission to read and write FILEs (for example LOAD DATA INFILE)

Grant_priv Permission to GRANT available permissions to other users

References_priv Permissions to create, modify or drop INDEXes

Alter_priv Permission to ALTER table structures.

Activities in MySQL Laboratory