Database Reference
In-Depth Information
The user in the previous example,
russell
on localhost, cannot add, change, or delete
data. If you want to give a user more than viewing privileges, you should add additional
For now, to give a user all privileges, replace
SELECT
with
ALL
. Here's another example
using the
ALL
setting:
mysql -u root -p -e "GRANT ALL ON *.* TO 'russell'@'localhost';"
The user in this example,
russell
on localhost, has all basic privileges. So that you can
experiment while reading this topic, you should create a user with full privileges, but use a
name other than mine, something that better suits you.
With the MySQL or MariaDB installation software downloaded and installed, all of the
binary files and minimal data in place and properly set, and a full privileged user created,
the database system is now ready to use and you can begin learning how touse it.
[
2
]
A
daemon
is a background process that runs continuously; a Unix term for what most people call a “serv-
er.”
[
3
]
tar
is an archive tool developed on Unix, but its format is understood by many archiving tools on many
operating systems.