First page Back Continue Last page Image

Granting Access Privileges to Users in MySQL

There are 2 steps to this process, the first is to create a User and the second is to specify which databases and abilities the user has access to

mysql> CREATE USER root_bk@localhost IDENTIFIED BY 'p@55w0rd';

mysql> CREATE USER nicole@localhost IDENTIFIED BY 'pa55word';

In this example I am creating 2 users, one will be a backup to the root user and one will be a regular user

The Name of your MySQL Instance

New User Name

The MySQL Commands for this function

The Users Initial Password

Note: These are not good passwords just examples