This is personal study note
Copyright and original reference:
https://www.youtube.com/watch?v=p5afjjnM1zY&list=PLVsNizTWUw7HhYtI-4GGmlJ5yxNdwNI_X
================================================================================
When MySQL server is installed in local computer
================================================================================
When MySQL server is installed in remote server
================================================================================
================================================================================
Create connection between linux MySQL server and local MySQL workbench
================================================================================
================================================================================
permissions
================================================================================
================================================================================
================================================================================
================================================================================
================================================================================
for employee table, only read permission for staff
================================================================================
connect to MySQL with various permission (director, CEO, staff, etc)
with director permission
================================================================================
with CEO permission