linux下安装mysql8

3）linux下安装mysql8
3.1）rpm -qa | grep mariadb
3.2）rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps
3.3）rpm -qa | grep mariadb
3.4）cd  cd /usr/local
3.5）ll
3.6）mkdir mysql
3.7）上传mysql-8.0.27-1.el7.x86_64.rpm-bundle.tar 到/usr/local/mysql下
3.8）tar -xvf mysql-8.0.27-1.el7.x86_64.rpm-bundle.tar
mysql-community-client-8.0.27-1.el7.x86_64.rpm
mysql-community-client-plugins-8.0.27-1.el7.x86_64.rpm
mysql-community-common-8.0.27-1.el7.x86_64.rpm
mysql-community-devel-8.0.27-1.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.27-1.el7.x86_64.rpm
mysql-community-libs-8.0.27-1.el7.x86_64.rpm
mysql-community-libs-compat-8.0.27-1.el7.x86_64.rpm
mysql-community-server-8.0.27-1.el7.x86_64.rpm
mysql-community-test-8.0.27-1.el7.x86_64.rpm
3.9）rpm -ivh mysql-community-common-8.0.27-1.el7.x86_64.rpm --nodeps --force
3.10）rpm -ivh mysql-community-libs-8.0.27-1.el7.x86_64.rpm --nodeps --force
3.11）rpm -ivh mysql-community-client-8.0.27-1.el7.x86_64.rpm --nodeps --force
3.12）rpm -ivh mysql-community-server-8.0.27-1.el7.x86_64.rpm --nodeps --force
3.13）rpm -qa | grep mysql
[root@localhost mysql]# rpm -qa | grep mysql
mysql-community-libs-8.0.27-1.el7.x86_64
mysql-community-server-8.0.27-1.el7.x86_64
mysql-community-common-8.0.27-1.el7.x86_64
mysql-community-client-8.0.27-1.el7.x86_64
3.14）mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
3.15）yum install libaio
3.16）mysqld --initialize;
3.17）chown mysql:mysql /var/lib/mysql -R
3.18）systemctl start mysqld.service
3.19）systemctl enable mysqld
3.20） cat /var/log/mysqld.log | grep password
3.21）mysql -uroot -p
3.22）ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'aabbcccc';
3.23）create database test1;
3.24） create user 'aabb'@'192.168.%' identified by 'aabbcccc'  PASSWORD EXPIRE NEVER;
3.25）ALTER USER 'aabb'@'192.168.%' IDENTIFIED WITH mysql_native_password BY 'aabbcccc';
3.26）GRANT ALL ON test1.* TO 'aabb'@'192.168.%';
3.27）firewall-cmd --zone=public --list-ports
3.28）firewall-cmd --add-port=3306/tcp --permanent
3.29）firewall-cmd --reload
3.30）firewall-cmd --remove-port=3306/tcp --permanent
3.31）firewall-cmd --reload
3.32）linux下mysql my.cnf所在目录  /etc/my.cnf
3.33）CREATE DATABASE aabb  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
3.34）安装java到/root/
3.35）tar  -zxvf jdk-8u181-linux-x64.tar.gz
3.36）vim /etc/profile
export JAVA_HOME=/root/jdk1.8.0_181
export PATH=$PATH:$JAVA_HOME/bin
3.37）source /etc/profile 生效java
3.38）ln -s /root/jdk1.8.0_181/bin/javaws /usr/bin/java 建立软连接
3.39）不使用这个使用 rpm -ivh  jdk-8u181-linux-x64.rpm  --nodeps --force
3.40）开机自启动
Chmod +x /etc/rc.d/rc.local
在rc.local中增加
/rootp/wzkjauto.sh
cd /root/apache-cassandra/bin
./cassandra
sleep 120
cd /root/aaaa/bin
./start.sh

Rc.local
touch /var/lock/subsys/local
/root/auto.sh

jdk-8u181-linux-x64.rpm
3.41) linux 设置时间  date -s "2021-11-9 19:23:15"

3.55）遇到 centos中没有java 在start.sh中启动不起来，需要使用软连接放置一下
Ln -s /root/jdk1.8/bin/java  /usr/bin/java