Episode 5: MySQL and Auth Design
- Show how to configure MySQL
- Create a database
- Create a user specific to the database
- Design the Users and Roles table
- Move roles migration file so it is created before users – rename it
- Edit user migration file so it uses role_id as foreign key
- Create log in form
- Create log in/out controller method
- Create authenticate controller method
- Create if/else to show login link or logout link
Leave a Reply