MySQL添加用戶遠程訪問權限
GRANT ALL PRIVILEGES ON *.* TO @localhost IDENTIFIED BY '' WITH GRANT OPTION;GRANT ALL PRIVILEGES ON *.* TO 用戶名@"%" IDENTIFIED BY '密碼' WITH GRANT OPTION;第一句是增加用戶和密碼,第二句是提升權限。只需更改紅色字體為你需要的就OK了。
GRANT ALL PRIVILEGES ON *.* TO @localhost IDENTIFIED BY '' WITH GRANT OPTION;GRANT ALL PRIVILEGES ON *.* TO 用戶名@"%" IDENTIFIED BY '密碼' WITH GRANT OPTION;第一句是增加用戶和密碼,第二句是提升權限。只需更改紅色字體為你需要的就OK了。