摘要:
ubuntu20 上安装了mysql之后,发现数据库的密码为空,需要重新的设置下密码 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by '123456'; flush privileges; exit 退出后 阅读全文
摘要:
一、创建只读账号GRANT Select ON *.* TO reader@"%" IDENTIFIED BY "123456" %如果替换成ip,则为只有对应的ip可以连接 二、创建增删改查账号 GRANT Select,Update,insert,delete ON *.* TO writer@ 阅读全文