Mysql8.0不支持grant all privileges on 需要这样那样 才可以授权

mysql8 以上不在支持 grant all privileges on这种写法

需要如下方法授权:

先登录mysql

mysql -uroot -p

CREATE USER 'root'@'%' IDENTIFIED BY '123456';
grant all privileges on *.* to 'root'@'%' ;
本文版权归 123456.blog 所有
转载请附上原文出处链接和本声明
本文链接:
数字工·「」· https://123456.blog ip: 34.225.194.102
Copyright © 2022 Hotpot. All rights reserved. Made with ❤ , 3Q ; Deployed: Kubernetes(k8s),Docker
Design by HotpoT; VvE3 ,NuxT3 123456.blog@0.1.0