List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 6 2000 4:56pm
Subject:Re: Authenication Process
View as plain text  
At 12:24 PM -0400 04-06-2000, Dave Seltzer wrote:
>I was just curious how mysqld authenticates users when they connect,
>I would assume it works like this:

You don't need to assume anything.  Read chapter 6 of the MySQL
reference manual, where the process is explained.  If you've
read that and there's something not clear, please ask.

>Check Hostname, if it appears user table continue
>Check Username, if it appears in user table continue
>If username requires identification, ask password
>if Password is correct check to see if user can logon
>from current hostname.
>if all are true, continue
>then every time the user accesses the DBMS permissions are checked
>on the DB/Table/Column levels...
>Have  I got it right?

Paul DuBois, paul@stripped
Authenication ProcessDave Seltzer6 Apr
  • Re: Authenication ProcessPaul DuBois6 Apr
  • Re: Authenication Processsinisa7 Apr