Database Reference
In-Depth Information
Summary
When you first start as a database administrator, you may have a tendency to create a min-
imal number of user accounts — you may even try to use only the
root
user account.
However, you should learn not to use
root
and to instead use various user accounts. You
should also learn to give each person at least one personal user account — try not to allow
sharing of user accounts, if practical. Additionally, learn to give access only to databases
and tables that are needed by each user account and only the privileges needed. This may
be tedious, but it's a good security practice — not just to protect sensitive data, but to pro-
tect data from being lost and schema being changed or deleted inadvertently.
There are several options related to user accounts and security that we did not discuss.
Some options limit the number of connections at a time or per hour for a user account.
There are several functions for encrypting and decrypting strings that may be used for pass-
words. You probably won't need these often, especially not as a newcomer to MySQL and
MariaDB. However, you can find more information on them in my book,
MySQL in a Nut-
shell
,
or on the
MySQL Resources site
.
