Practice: Securing a Database
Task: Give restricted privileges to a user so he can access the hardware database from your computer.
Connect to the MySQL server using your root MySQL password. Then go to the mysql database within it.
Create a user fred at localhost with SELECT and INSERT privileges on the database hardware.* with a password of 'match5pad'.
Close the MySQL database connection, then close the terminal window.