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