Exercise 14.01 – creating users and granting permissions
You are part of a new start-up that sells electric bikes on a web page and with a mobile app. Besides you, there is the founder of the company (Patrick) and a single developer (Mike) who develops the web page and mobile app. You have been tasked with setting up accounts for the developer, the founder, and the web server.
On the database server, there are two databases: employees and ebike. The web server should be limited to 300 connections to ensure the databases are still accessible even if the website becomes overloaded.
In order to implement this exercise, first, open the MySQL client and connect to the database server. Then, create accounts for Patrick, Mike, and the web server. You will grant Patrick access to the employees and the ebike schemas, and grant Mike and the web server access to the ebike schema.
To complete this exercise, perform the following steps:
- Open the MySQL client and connect...
