LAMPsig

By Solomon Chang

There comes a time in the life cycle of a company where everyone has to stop connecting as password-less root to their central database. All the inherent security protocols (such as "We only have 3 users," or "No one here is malicious enough or knowledgeable enough to crack our Production database!") begin to lose relevance as the DB user base starts to grow. This talk aims at the "why" and the "how" of setting user permissions, as well as how users are generally authenticated into the system. This talk also delves into the granularity of permissions for those who require extremely fine-tuned access to database resources.

Solomon Chang is a MySQL certified DBA and the current acting director of LAMPSIG. He works as a professional Database Administrator in Venice Beach, and is a co-author of the MySQL Cluster Certification Study Guide.