这里下载mysql-8.0.28-1.el7.aarch64.rpm-bundle.tar 包到本地
scp /Users/yun/Desktop/mysql-8.0.29-1.el7.aarch64.rpm-bundle.tar root@10.211.55.3:/root
scp /Users/yun/Desktop/mysql-8.0.29-1.el7.aarch64.rpm-bundle.tar root@10.211.55.3:/root
将tar包传到虚拟机内
连接虚拟机
yum install vim cd /etc/sysconfig/network-scripts onboot=yes #设定网卡在系统启动时初始化 reboot #重新启动虚拟机生效 ssh root@10.211.55.3
操作虚拟机
使用vim命令修改/etc/profile文件,在文件末尾加入如下配置
JAVA_HOME=/usr/local/jdk1.8.0_171 PATH=$JAVA_HOME/bin:$PATH
tar -zxvf jdk-8u171-linux-x64.tar.gz -C /usr/local #配置java环境变量 vim /etc/profile
重新加载profile文件
为了使更改的配置立即生效,需要重新加载profile文件,执行命令:
source /etc/profile
检查安装是否成功
java -version安装mysql
rpm -qa | grep mariadb 查询当前系统中安装的名称带mariadb的软件
卸载 mariadb,具体指令为:rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64解包
tar -xvf mysql-8.0.28-1.el7.aarch64.rpm-bundle.tar -C /usr/local/mysql
顺序- rpm -ivh mysql-community-common-8.0.28-1.el7.aarch64.rpm
- rpm -ivh mysql-community-client-plugins-8.0.28-1.el7.aarch64.rpm
- rpm -ivh mysql-community-libs-8.0.28-1.el7.aarch64.rpm
- rpm -ivh mysql-community-libs-compat-8.0.28-1.el7.aarch64.rpm
- rpm -ivh mysql-community-client-8.0.28-1.el7.aarch64.rpm
- rpm -ivh mysql-community-icu-data-files-8.0.28-1.el7.aarch64.rpm
- rpm -ivh mysql-community-embedded-compat-8.0.28-1.el7.aarch64.rpm
- yum install openssl-devel
- rpm -ivh mysql-community-devel-8.0.28-1.el7.aarch64.rpm
- yum install net-tools
-
rpm -ivh mysql-community-server-8.0.28-1.el7.aarch64.rpm
-
yum install perl-Data-Dumper -y yum install perl-JSON -y yum install perl-Test-Simple -y
-
rpm -ivh mysql-community-test-8.0.28-1.el7.aarch64.rpm
- mysqld --initialize --user=mysql
- cat /var/log/mysqld.log
- systemctl start mysqld
- mysql -uroot -p
- ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
修改MySQL用户的host属性
当你远程登录MySQL时,使用的账号要有特殊要求。
默认的账号的host属性都是localhost,意思是这个账号只能本地使用,如果要使用某个账号来远程登录,必须将账号的host属性值更改成%。
执行的sql语句如下:
- update mysql.user set host = '%' where user = 'root';
- flush privileges;



