美文网首页
Mysql 5.7 局域网访问

Mysql 5.7 局域网访问

作者: jumper996 | 来源:发表于2019-02-24 16:07 被阅读0次
    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '1234' WITH GRANT OPTION;
    flush   privileges;
    
    %就是可以访问的ip
    root用户名
    1234密码
    

    mysql 8

    CREATE USER 'root'@'%' IDENTIFIED BY '1234';
    GRANT ALL ON *.* TO 'root'@'%';
    ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '1234';
    flush   privileges;
    
    

    相关文章

      网友评论

          本文标题:Mysql 5.7 局域网访问

          本文链接:https://www.haomeiwen.com/subject/hphbyqtx.html