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权限可远程连接
最新推荐文章于 2024-01-23 08:00:00 发布