starRocks安装jdk环境与mysql客户端

一、安装jdk

• 1、starRocks与jdk版本对应
• v3.5.0及以上必须装JDK17或更高、V2.5.0至v3.4.x推荐JDK11、v2.5.0以下JDK8。
• 2.安装jdkJava 平台，标准版 11 参考 实现
• 2.1 创建目录并解压jdk
  cd usr
mkdir openjdk11
cd usr/openjdk11
tar -zvxf openjdk-11+28_linux-x64_bin.tar.gz
• 2.2 编辑/etc/profile文件
  vi /etc/profile
• 2.3增加如下代码
  # Java Environment
export JAVA_HOME=/usr/openjdk11/jdk-11
export JRE_HOME=$JAVA_HOME/jre
export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar:$JRE_HOME/lib:$CLASSPATH
export PATH=$JAVA_HOME/bin:$PATH
  
• 2.4 使环境变量生效
  source /etc/profile -2.5检查是否安装成功
  java -version
• 3、安装mysql客户端MySQL :: Begin Your Download
• 3.1通过 rpm -qa | grep mariadb 命令查看 mariadb 的安装包
• 3.2通过 rpm -e mariadb-libs-5.5.68-1.el7.x86_64 --nodeps 命令装卸 mariadb
• 3.3创建目录并解压
  cd usr
mkdir mysql8
cd usr/mysql8
tar -vxf mysql-8.0.44-1.el7.x86_64.rpm-bundle.tar
• 3.4按顺序执行以下命令
  
• rpm -ivh mysql-community-common-8.0.44-1.el7.x86_64.rpm --nodeps --force
• rpm -ivh mysql-community-libs-8.0.44-1.el7.x86_64.rpm --nodeps --force
• rpm -ivh mysql-community-client-8.0.44-1.el7.x86_64.rpm --nodeps --force
• rpm -ivh mysql-community-server-8.0.44-1.el7.x86_64.rpm --nodeps --force
• 3.5对mysql进行相关配置
  mysqld --initialize
chown mysql:mysql /var/lib/mysql -R
systemctl start mysqld.service
systemctl enable mysqld
• 3.6查看数据库密码
  cat /var/log/mysqld.log | grep password
• 3.7连接数据库
  mysql -uroot -p
• 3.8更改数据库密码
  ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '13.823'; -3.9 exit退出数据库使用新密码再连接
• 3.10远程访问的授权
  create user 'root'@'%' identified with mysql_native_password by '123';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;
• 3.11修改加密规则
  ALTER USER 'root'@'localhost' IDENTIFIED BY '123' PASSWORD EXPIRE NEVER;
• 3.12刷新修改后的权限
  flush privileges;
exit退出mysql
• 3.13关闭防火墙
  systemctl stop firewalld.service;
systemctl disable firewalld.service;
systemctl mask firewalld.service;