MySQL Basics In Pictures

Practice: Securing a Database

Task: Give restricted privileges to a user so he can access the hardware database from your computer.

  1. Connect to the MySQL server using your root MySQL password. Then go to the mysql database within it.
  2. Create a user fred at localhost with SELECT and INSERT privileges on the database hardware.* with a password of 'match5pad'.
  3. Close the MySQL database connection, then close the terminal window.