mysql
//赋予任何主机访问数据的权限
GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘IDENTIFIED BY ‘自定义密码‘ WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘IDENTIFIED BY ‘123456‘ WITH GRANT OPTION;
//指定ip地址访问权限
如：
配置192.168.16.130可以通过root:123456来访问数据库
GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘192.168.16.130‘IDENTIFIED BY ‘123456‘ WITH GRANT OPTION;
一看大写就头疼，
grant all privileges on *.* to ‘root‘ @‘%‘ identified by ‘123456‘ with grant option;
刷新权限
flush privileges;
词汇：
grant :（合法地）授予，允许；（勉强）承认，同意
privileges :特权;
identified : 被识别的；经鉴定的；被认同者
原文：https://www.cnblogs.com/zxh06820/p/12616567.html
如果您也喜欢它,动动您的小指点个赞吧
602392714
清零编程群