mysql8

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

use mysql;
updateusersetauthentication_string=''whereuser='root'

ALTER user 'root'@'localhost' IDENTIFIEDBY 'Cliu123#'

    A+
发布日期:2019年09月19日  所属分类:未分类

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: