Cannot Be Done With Privileges

• There are some things that cannot be done with the MySQL privilege system:
  • One cannot explicitly specify that a given user should be denied access.
    • One cannot explicitly match an user and then refuse the connection.
  • One cannot specify that an user has privileges to create or drop tables in a database but not to create or drop the database itself.
  • A password applies globally to an account.
    • One cannot associate a password with a specific object such as a database, table, or routine.

What is the process of connecting to the server?

---

---

© 2007 John Michael Pierobon

Notes