Chapter 28. Users and Data Security
28.1 Introduction
This chapter describes the features that MySQL offers for protecting data in the tables against deliberate or accidental unauthorized use: SQL users, passwords, and privileges.
SQL users must be known to MySQL before they can access the database data. Chapter 3, “Installing the Software,” showed you how one user is created automatically during the installation of MySQL, and Chapter 4, “SQL in a Nutshell,” showed how a new SQL user called BOOKSQL was introduced. Logging on to MySQL without an existing user name is just not possible.
A password can also be assigned to each SQL user. When a password is required, accessing the database data becomes even more difficult because the name of an SQL ...
Get SQL for MySQL Developers: A Comprehensive Tutorial and Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
