MySQL Basics In Pictures
Add a local user
  1. Open a terminal window.
  2. Connect to the MySQL server using your root MySQL password and go to the mysql database within it:

    mysql -u root -p mysql
  3. At the mysql> prompt, type:

    GRANT ALL PRIVILEGES ON *.* TO mary@localhost IDENTIFIED BY 'ship3marker';

    then press ENTER.

    This command string creates a new account on the MySQL server for the user mary. Her password is ship3marker.