Client

طبقه بندی موضوعی

۲ مطلب در دی ۱۳۹۲ ثبت شده است

Username: SHAHARIA

License Key:
===== LICENSE BEGIN =====
11597-12042010
00001zDBvOz1bVax"Z4AMJdb6nEB31
"f9z69pKTKKTrHYlZ7Tp6jnDcSxUPv
tfCgle00vu5Yq81i2s"C7VvxgH0!h9
===== LICENSE END =====

Here is the sample about how to create a MySQL user and grant access to the database. In this example I use mysql command line tool.

First, let’s create a MySQL user:

CREATE USER 'user_name'@'%' IDENTIFIED BY 'user_password';

After creating a database user let’s grant access to the database for the created user, so that the user can have all rights on the database:

GRANT ALL PRIVILEGES ON mydatabase.* TO 'user_name'@'%';