MySQL安装

10:35
MySQL安装
1 下载软件包： mysql-8.0.15-
1.el7.x86_64.rpm-bundle.tar 和 mysql-connector-java-8.0.15.zip文件。
2、将软件包通过moba上传到linux 系统。/usr/local/soft/
3、解压软件包
tar -xvf mysql-8.0.15-1.el7.x86_64.rpm-
bundle.tar
4、卸载系统自带mariadb
rpm -qa I grep mariadbyum -y remove mariadb-libs-5.5.52-1.el7.x86_645、下载依赖包yum -y install openssl-devel perl-JSONyum Install-y openssopenssl.x86_64yum install -y perl.x86_64 perl-devel.x86_64yum Install-y autoconyum install net-tools -yrpm -ivh mysql-community-libs-8.0.15-1.el7.x86_64.rpmrpm -Iyh mysql-community-server-8.0.15-1.el7.x86_64.rpmrpm -ivh mysql-cc .0.15-安装完默认是mvsal用户、用户组和权限chown -R mysql:mysql /var/lib/mysql7、重启mysql服务若启动失败查看tail-n 100 /var/log/mysald.loa8、查看密码cat /var/log/mysqld.log I grep passcd /var/logcat mysqld.log9、数据库登陆输入第八步中的密码进行登陆10、设置登陆密码复杂度set global vali11、修改密码ALTER USER ‘rootroot123’;12、开放所有IP都能访问use mysqlCREATE USER ‘root’@’% IDENTIFIED BYroot123;grant all privilegegrant option;13、修改加密方式ALTER USER ‘root’@’%’ IDENTIFIED WITH mysqLnatlve_password BY root123’;string, plugin14、重启数据库qult/bin/systemctl restart mysqld.service或：systemctlstart mysqld设置开机自启动