C1hSrF7j

1mysql -h127.0.0.1 -u"root" -p
2
3Welcome to the MySQL monitor.  Commands end with ; or g.
4Your MySQL connection id is 5901
5Server version: 5.7.26-0ubuntu0.18.10.1 (Ubuntu)
6
7mysql> CREATE USER 'he-site'@'127.0.0.1' IDENTIFIED BY 'myPassword';
8mysql> GRANT ALTER, CREATE, DROP, INDEX, SELECT, INSERT, UPDATE, DELETE, REFERENCES ON `he-site`.`*` TO 'he-site'@'127.0.0.1';
9mysql> FLUSH PRIVILEGES;
10
11mysql> SELECT User,Host FROM mysql.user;
12+------------------+-----------+
13| User             | Host      |
14+------------------+-----------+
15| he-site          | 127.0.0.1 |
16| he-tips          | 127.0.0.1 |
17| debian-sys-maint | localhost |
18| mysql.session    | localhost |
19| mysql.sys        | localhost |
20| root             | localhost |
21+------------------+-----------+
226 rows in set (0.00 sec)
23
24mysql> SHOW GRANTS FOR 'he-site'@'127.0.0.1';
25+------------------------------------------------------------------------------------------------------------------------+
26| Grants for he-site@127.0.0.1                                                                                           |
27+------------------------------------------------------------------------------------------------------------------------+
28| GRANT USAGE ON *.* TO 'he-site'@'127.0.0.1'                                                                            |
29| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON `he-site`.`*` TO 'he-site'@'127.0.0.1' |
30+------------------------------------------------------------------------------------------------------------------------+
312 rows in set (0.00 sec) 
32     
33mysql -h127.0.0.1 -u"he-site" -p
34
35mysql> CREATE TABLE IF NOT EXISTS tasks (     task_id INT AUTO_INCREMENT,     title VARCHAR(255) NOT NULL,     description TEXT,     PRIMARY KEY (task_id) )  ENGINE=INNODB;
36ERROR 1142 (42000): CREATE command denied to user 'he-site'@'localhost' for table 'tasks'
37
38mysql> SELECT USER(),CURRENT_USER();
39+-------------------+-------------------+
40| USER()            | CURRENT_USER()    |
41+-------------------+-------------------+
42| he-site@localhost | he-site@127.0.0.1 |
43+-------------------+-------------------+
441 row in set (0.00 sec)