mysql> create database uml;
Create a user:
mysql> CREATE USER 'student'@'localhost' IDENTIFIED BY 'mysql';
Grant privileges:
mysql> GRANT ALL PRIVILEGES ON * . * TO 'student'@'localhost';
Log on:
$ mysql -u student -p
Enter password: mysql
Show users:
mysql> select host, user, password from mysql.user;
+-----------+------------------+-------------------------------------------+
| host | user | password |
+-----------+------------------+-------------------------------------------+
| localhost | root | |
| ultra20 | root | |
| 127.0.0.1 | root | |
| ::1 | root | |
| localhost | student | *E74858DB86EBA20BC33D0AECAE8A8108C56B17FA |
+-----------+------------------+-------------------------------------------+
9 rows in set (0.00 sec)
