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
如有问题,可以QQ搜索群1028468525加入群聊,欢迎一起研究技术
转载请注明:mysql8 出自老鄢博客 | 欢迎分享