flink结果入mysql_Flink从入门到真香(11、Sink自定义数据输出-以写入MySQL为例）

目标： Flink从txt文件中读取数据，写入到mysql中

环境准备： 如果没有mysql，可以按照下面命令安装一下

wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

yum -y install mysql80-community-release-el7-3.noarch.rpm

yum install mysql-community-server -y

systemctl restart mariadb

查看mysql默认密码

[root@localhost ~]# grep 'temporary password' /var/log/mysqld.log

2020-11-04T02:05:26.432219Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: qCk4b_3iEE;V

修改mysql默认密码

mysql -uroot -p'qCk4b_3iEE;V'

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Mafei@20201104';

Query OK, 0 rows affected (0.03 sec)

允许所有主机连接mysql

mysql> update user set host = '%' where user = 'root';

systemctl restart mysqld

创建mysql的