ACCESS RIGHTS IN UNDERSTANDING MYSQL

Hello.. hello my friends, welcome to my blog at “We Are Knowedge”..  Now. You are on my blog… you can look at my blog.  My Blog to fill many IT knowledge. You can get and take it FREE.

Now.. I want add my article about “database” so I want giving you knowledge about it, that is “MYSQL”, but with tutorial different. And for now tutorial is “ACCESS RIGHTS IN UNDERSTANDING MYSQL “. You will know that ? or you will to learn that ? so let’s do read my article… you can add your science.. have fun friends..

first you need to have a program to run, such as: xampp, wampp or sql. anada can choose one of them. without the software that you will not be able to make a program or follow my steps.

In MYSQL we are also required to determine the permissions on the database that we have, who are allowed to access the public or anyone who can not access it in general.

Remedy set, MYSQL has prepared syntax. you can find in it. In the MYSQL database there is a table - a table like this.

You try to read it and understand it. :

A. User

>> usefulness of this table is to store information on MYSQL, information such as user, password and host user, and this table stores information about user permissions

B. Db

>> This table also serves as a repository for information about user permissions to your database.

C. Host

>> For this table serves as a storage computer list, the list can be a computer, IP address, computer name to access his computer

D. Tables_priv

>> And for the following table is used for storing user permissions to a table. More simply, if you create a table using this you can control who can access it and what he can do.

E. Columns_priv

>> Almost the same as the previous bit different on these permissions to columns

F. Procs_priv

>> For these permissions are used to restrict users with procedure

G. Proc

This table is useful for storing information about the listing procedure in MYSQL

H. Func

This table is useful for storing information about the didefinisakan function in MYSQL, almost sma with the previous one, make sure you use the right, should not be confused with the other table functions.

Ok.. just it…

I hope you understand…

See you laters…