Flink指南

下载安装包

wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.25-linux-glibc2.17-x86_64-minimal.tar.xz

安装依赖包

apt-get install libaio1 libaio-dev sudo apt-get install libncurses5

新建用户组、用户

groupadd mysql
useradd -r -g mysql -s /bin/false mysql
mkdir -p /usr/local/mysql/data
chown -R mysql:mysql /usr/local/mysql
/usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/home/data/mysql_data
[Note] [MY-010454] [Server] A temporary password is generated for root@localhost: zS/UXy0r&a-s    #最后面的字符串为root密码。

groupadd mysql useradd -g mysql mysql -d /home/mysql -s /sbin/nologin

/usr/local/mysql/bin/mysql_ssl_rsa_setup –datadir=/home/data/mysql_data 拷贝配置文件和启动脚本 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld vi /etc/init.d/mysqld basedir=/usr/local/mysql datadir=/home/data/mysql_data

vi /etc/profile export MYSQL_HOME=/usr/local/mysql export PATH=$PATH:$MYSQL_HOME/bin 启动服务 /etc/init.d/mysqld start
设置root密码 使用初始化密码 /usr/local/mysql/bin/mysql -uroot -p’zS/UXy0r&a-s’ mysql>ALTER user ‘root’@’localhost’ IDENTIFIED BY ‘root’; 忘记初始化密码 vi /etc/my.cnf 在[mysqld]下增加一行 skip-grant-tables

/etc/init.d/mysqld restart /usr/local/mysql/bin/mysql -uroot mysql> use mysql; mysql> update user set authentication_string = ‘’ where user = ‘root’; mysql> exit

vi /etc/my.cnf 在[mysqld]下删除一行 skip-grant-tables

/usr/local/mysql/bin/mysql -uroot mysql> ALTER user ‘root’@’localhost’ IDENTIFIED BY ‘root’; mysql> exit

/etc/init.d/mysqld restart 设置开机启动 ####### CentOS ######## chkconfig mysqld on chkconfig –list

####### Ubuntu ######## update-rc.d mysql defaults update-rc.d -f mysql remove 设置防火墙 vi /etc/sysconfig/iptables -A INPUT -m state –state NEW -m tcp -p tcp –dport 3306 -j ACCEPT 添加到库 vi /etc/ld.so.conf /usr/local/mysql/lib

ldconfig

下载 MySQL 二进制安装包

wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.25-linux-glibc2.17-x86_64-minimal.tar.xz

##