https://faceghost.com/article/515681
mysql> ALTER USER 'developer'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.00 sec)
mysql> DROP USER 'top'@'%';
Query OK, 0 rows affected (0.01 sec)
mysql> CREATE USER top@'%' IDENTIFIED BY 'pass';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO top@'%';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT GRANT OPTION ON *.* TO top@'%';
Query OK, 0 rows affected (0.00 sec)
https://segmentfault.com/q/1010000005966536
CREATE USER top@localhost IDENTIFIED BY 'pass';
GRANT ALL PRIVILEGES ON JUST_ONE_DATABASE.* TO top@localhost;
GRANT GRANT OPTION ON JUST_ONE_DATABASE.* TO top@localhost;
http://blog.sina.com.cn/s/blog_439f80c40100yoln.html
CREATE USER 'jack'@'localhost' IDENTIFIED BY 'test123';
https://www.jb51.net/article/142025.htm
ALTER user 'root'@'localhost' IDENTIFIEDBY 'Cliu123#'