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
privileges to the SELECT command, separated by commas. That is covered in Chapter13 .
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.
Search WWH ::




Custom Search