给数据库远程连接的权限

    技术2022-05-13  6

    GRANT ALL PRIVILEGES ON 数据库名字.* TO用户名@LOCALHOST IDENTIFIED BY ‘密码’ WITH GRANT OPTION;(LOCALHOST:只能从本机访问)

     

     

    GRANT ALL PRIVILEGES ON 数据库名字.* TO用户名@% IDENTIFIED BY ‘密码’ WITH GRANT OPTION;(%表示可以从任何地方访问)

    FLUSH PRIVILEGES;

    www.cxhygyl.com


    最新回复(0)