mysql> use jpress;
Database changed
mysql> create user 'jpress'@'%' identified by 'Root123.';
Query OK, 0 rows affected (0.06 sec)
mysql> grant all privileges on *.* to 'jpress'@'%' with grant option;
Query OK, 0 rows affected (0.02 sec)
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Root123.';
Query OK, 0 rows affected (0.01 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| jpress |
| mysql |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.01 sec)
mysql> select user,host from mysql.user;
+-