CREATE USER admin IDENTIFIED BY ‘a123456’;
GRANT ALL PRIVILEGES ON . TO ‘admin’@‘localhost’ IDENTIFIED BY ‘a123456’; – localhost 127.0.0.1 访问
GRANT ALL PRIVILEGES ON . TO ‘admin’@’%’ IDENTIFIED BY ‘a123456’; – 可远程访问所有db
设置mysql权限可远程连接
CREATE USER admin IDENTIFIED BY ‘a123456’;
GRANT ALL PRIVILEGES ON . TO ‘admin’@‘localhost’ IDENTIFIED BY ‘a123456’; – localhost 127.0.0.1 访问
GRANT ALL PRIVILEGES ON . TO ‘admin’@’%’ IDENTIFIED BY ‘a123456’; – 可远程访问所有db
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
