阿里云ESC配置

mysql

• 版本：>= 8.0

 // 先要配置rpm包,https://repo.mysql.com 可以自己找一个合适的版本
[root@iZf8zd6gjqmdx8yymx6gntZ ~]# rpm -ivh https://repo.mysql.com/mysql80-community-release-el6-1.noarch.rpm
Retrieving https://repo.mysql.com/mysql80-community-release-el6-1.noarch.rpm
warning: /var/tmp/rpm-tmp.Q0eCRB: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...


// 配置最新的GPG-KEY
[root@iZf8zd6gjqmdx8yymx6gntZ ~]# rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2023

// 搜索MySQL相关的包：
[root@iZf8zd6gjqmdx8yymx6gntZ ~]# yum install mysql-community-server

...

Installed:
  compat-openssl10-1:1.0.2o-4.0.1.al8.x86_64    mysql-community-client-8.0.20-1.el6.x86_64    mysql-community-common-8.0.37-1.el6.x86_64    mysql-community-icu-data-files-8.0.37-1.el6.x86_64   
  mysql-community-libs-8.0.21-1.el6.x86_64      mysql-community-server-8.0.37-1.el6.x86_64   

Complete!


// 启动
[root@iZf8zd6gjqmdx8yymx6gntZ ~]# systemctl start mysqld
// 重启 systemctl restart mysqld


// 查看临时密码
[root@iZf8zd6gjqmdx8yymx6gntZ ~]# /var/log/ mysqld.log 

....
2024-06-16T13:26:31.060322Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: hhVlRUokl0.;
...


// 登录
[root@iZf8zd6gjqmdx8yymx6gntZ ~]# mysql -u root -p
passowrd：hhVlRUokl0.;

// 重置密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'S$$snackpub@ssw0rd!';
Query OK, 0 rows affected (0.01 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

// 设置允许任何主机访问
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
//////// 
ERROR 1410 (42000): You are not allowed to create a user with GRANT
///////

mysql> CREATE USER 'snackpub'@'%' IDENTIFIED BY 'S$$snackpub@ssw0rd!';
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'snackpub'@'%';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

// 开放
[root@iZf8zd6gjqmdx8yymx6gntZ log]# firewall-cmd --permanent --zone=public --add-port=3306/tcp
success
[root@iZf8zd6gjqmdx8yymx6gntZ log]# firewall-cmd --reload
success

JDK

• 版本：jdk 1.8

// 当前用户配置
[root@iZf8zd6gjqmdx8yymx6gntZ jdk1.8.0_202]# vim ~/.bashrc 
// 在文件末尾添加以下行，根据实际安装路径调整：

JAVA_HOME="/usr/local/mysoftware/jdk1.8.0_202"
PATH="$JAVA_HOME/bin:$PATH"
CLASSPATH=".:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/dt.jar"

// 于全局配置（所有用户适用），编辑 /etc/environment 或 /etc/profile 文件
[root@iZf8zd6gjqmdx8yymx6gntZ jdk1.8.0_202]# vim /etc/environment 

JAVA_HOME=/usr/local/mysoftware/jdk1.8.0_202
PATH=$JAVA_HOME/bin:$PATH
CLASSPATH=.:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/dt.jar

[root@iZf8zd6gjqmdx8yymx6gntZ jdk1.8.0_202]# vim /etc/profile

JAVA_HOME="/usr/local/mysoftware/jdk1.8.0_202"
PATH="$JAVA_HOME/bin:$PATH"
CLASSPATH=".:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/dt.jar"


// 使配置生效
[root@iZf8zd6gjqmdx8yymx6gntZ]# source /etc/environment
[root@iZf8zd6gjqmdx8yymx6gntZ]# source /etc/profile
[root@iZf8zd6gjqmdx8yymx6gntZ]# source ~/.bashrc

// 验证
java -version
javac -version

// 如果这两条命令都能显示出Java的版本信息，说明JDK环境变量配置成功。