linux数据库创建远程连接账号(Navicat等)

来源:互联网 发布:永琪和知画圆房了几次 编辑:程序博客网 时间:2024/05/20 03:05
cd /var/lib/mysql   //进入数据库mysql -uroot -prootGRANT ALL PRIVILEGES ON *.* TO 'admin'@'127.0.0.1'IDENTIFIED BY '123' WITH GRANT OPTION;  //创建账号GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%'IDENTIFIED BY '123' WITH GRANT OPTION;flush privileges;  //刷新权限


1 0