Database Reference
In-Depth Information
SHOW DATABASES
Use of
SHOW DATABASES
.
SHOW VIEW
Use of
SHOW CREATE VIEW
.
SHUTDOWN
Use of
mysqladmin shutdown
(used to shut
down MariaDB).
SUPER
Use of
CHANGE MASTER
,
KILL
,
LOGS
,
PURGE
MASTER
, and
SET GLOBAL
. Also allows
mysql-
admin debug
login.
UPDATE
Use of
UPDATE
.
USAGE
No access.
Using
GRANT
and
REVOKE
in conjunction with the privileges listed in Table
28.1, you have complete control over what users can and cannot do with your
precious data.
Note
Granting for the Future When using
GRANT
and
REVOKE
, the user account must
exist, but the objects being referred to need not. This allows administrators to design
and implement security before databases and tables are even created.
A side effect of this is that if a database or table is removed (with a
DROP
statement)
any associated access rights will still exist. And if the database or table is re-created in
the future, those rights will apply to them.
Tip
Simplifying Multiple Grants Multiple
GRANT
statements may be strung together by
listing the privileges comma delimited, as seen in this example:
GRANT SELECT, INSERT ON
crashcourse.* TO bforta;
To change
user passwords use the
SET PASSWORD
statement. New passwords
must be encrypted as seen here:
▼
Input
SET PASSWORD FOR bforta = Password('n3w p@$$w0rd');
▼
Analysis
SET PASSWORD
updates a user password. The new password must be
encrypted by being passed to the
Password()
function.
SET PASSWORD
can also be used to set your own password:
