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