给FATE的mysql数据库添加用户并赋权,实现远程连接
备注:虚拟机安装的FATE
1.登录到mysql:
(1)cd /data/projects/fate/common/mysql/mysql-8.0.13/bin
(2)mysql -uroot -pfate_dev -S /data/projects/fate/common/mysql/mysql-8.0.13/run/mysql.sock
2.添加用户并赋权
(1)CREATE USER ‘fate’@’%’ IDENTIFIED BY ‘fate_dev’ ;
(2)GRANT ALL PRIVILEGES ON . TO ‘fate’@’%’ ;
(3)FLUSH PRIVILEGES;