MySQL Users
When anything tries to connect to MySQL, we call it a client, whereas MySQL is the database server. To manage who, how, and for what purpose clients can connect, MySQL has a sophisticated user privilege system. Its settings are stored in grant tables in the database called mysql.
In Day 2, you saw how to connect to MySQL as the its root user. root can do anything on a MySQL database, but for any kind of database development work this is simply too much power to grant to ordinary users, whether they be real people or software applications.
MySQL's privilege system enables you to create users and assign them privileges. You can let users do things on a global level, or just within a given database, or you can exercise precise control ...
Get Sams Teach Yourself MySQL in 21 Days, Second Edition 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.
