Scribd
Upload
6 views3 pages

MySQL User Management Guide

The document describes user management in a database, including creating, renaming, and modifying user passwords, as well as assigning and revoking privileges.

Translated by

ScribdTranslations
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views3 pages

MySQL User Management Guide

The document describes user management in a database, including creating, renaming, and modifying user passwords, as well as assigning and revoking privileges.

Translated by

ScribdTranslations
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

DATABASE

USER MANAGEMENT

1. USER CREATION

To create a user, we proceed as follows:

2. RENAME A USER

To rename an already created user, the command is as follows.

Access to hosts:

@localhost: local node (the same node is both client and server)

can connect on all stations

etc

3. CHANGE A USER'S PASSWORD

The password change follows the same logic as for its assignment during the

creation of a user. You can do it as follows:

1
DATABASE

4. ALLOCATION OF PRIVILEGES

If you want to grant all rights on a database to a user, simply

to make the following request:

If we want to assign some privileges to a user, we will proceed as follows:

Now, for the new rights granted to be taken into account, it is necessary to

execute the FLUSH request.

5. REVOCATION OF PRIVILEGES

You can revoke all rights of a user with the following request.

2
DATABASE

6. VISUALIZE USERS AND ACCESS

a. USER DELETION

The deletion of a MySQL user depends on the version of MySQL. Starting from version

5.0.2, the following command is sufficient to delete the user.

You might also like