---
title: Understanding the MySQL Authentication Process
osem_url: https://osem.seagl.org/conferences/seagl2021/program/proposals/818
beginning: '2021-11-06T10:00:00.000-07:00'
end: '2021-11-06T10:30:00.000-07:00'
resources:
  internet_archive_identifier: SeaGL2021-David_M_Stokes-Understanding_the_MySQL_Authentication_Process
presenters:
- name: David M. Stokes
  affiliation: Oracle, MySQL Community Team
  osem_url: https://osem.seagl.org/users/310
  gravatar_id: c0fe36ac77bf9a0ebe01f0b7844c8e7f
  biography: |-
    Dave Stokes is a MySQL Community Manager for Oracle.  Previously he was the MySQL Certification Manager for MySQL AB and SUN.  He has worked for companies ranging alphabetically from the American Heart Association to Xerox and work ranging from Anti-submarine warfare to web developer.  And he really wonders how many people really, really read these conference biographies. Twitter = @ Stoker, blog = http://elephantdolphin.blogspot.com/

    He lives in Texas and has the mandated pickup truck, hound dog, and Stetson hat.
---

MySQL is a popular database but few understand that sometimes the authentication process actually works, that it can be too permissive, and sometimes too many have dangerous permissions provided to them. This session will cover how the server decides which accounts are allowed to access the server, password options, how to use roles, set up dual passwords, setting functional limits on accounts, and more.
