From the course: Linux for PHP Developers
Join today to access over 24,800 courses taught by industry experts.
Introduction to MySQL access privileges
From the course: Linux for PHP Developers
Introduction to MySQL access privileges
- [Instructor] MySQL has its own built-in system for controlling access independent of the operating system. How does it work? MySQL access privileges are given, not taken away. Therefore, instead of blocking someone, you just don't give them the privilege. What exactly is a privilege? A privilege is, by definition, a special right available only to a particular person. MySQL access control uses a system of privileges where users are granted privileges to perform actions or access resources. MySQL refers to these privileges and their storage as grants. There are dozens of individual privileges that mirror the actual data definition and manipulation statements. For example, there is a privilege allowing select statements. MySQL has a special internal database and table for storing users and their privileges, Mysql.users. Each user rows start with a host which defines the rules around the hostnames allowed. Then the user which is the username and a series of granular privileges that…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.