目录

文章目录

目录Centos7rpm安装检测本地是否有mariadb已存在的包如果存在，则使用yum命令卸载依次安装MySQL的组件初始化MySQL授权防火墙查看数据库密码登陆数据库（第一次登陆使用系统生成的密码，不便于记忆）修改密码查询远程访问开启远程访问开放3306端口设置时区安装jdk

Centos7

rpm安装

mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar

检测本地是否有mariadb已存在的包

rpm -qa | grep mariadb

如果存在，则使用yum命令卸载

rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

依次安装MySQL的组件

mysql-community-common rpm -ivh mysql-community-common-8.0.20-1.el7.x86_64.rpm mysql-community-libs rpm -ivh mysql-community-libs-8.0.20-1.el7.x86_64.rpm mysql-community-client rpm -ivh mysql-community-client-8.0.20-1.el7.x86_64.rpm mysql-community-server #libaio.so.1()(64bit) is needed by MySQL-server #yum install libaio rpm -ivh mysql-community-server-8.0.20-1.el7.x86_64.rpm

初始化MySQL

mysqld --initialize

授权防火墙

chown mysql:mysql /var/lib/mysql -R #开启mysql服务 [root@mycentos ~] systemctl start mysqld.service #设置开机自启mysql服务 [root@mycentos ~] systemctl enable mysqld

查看数据库密码

cat /var/log/mysqld.log | grep password

登陆数据库（第一次登陆使用系统生成的密码，不便于记忆）

mysql -u root -p;

修改密码

alter user 'root'@'localhost' identified with mysql_native_password by 新密码; #密码一定要加加引号

查询远程访问

mysql> use mysql; mysql> select host,user from user ; +-----------+------------------+ | host | user | +-----------+------------------+ | localhost | mysql.infoschema | | localhost | mysql.session | | localhost | mysql.sys | | localhost | root | | localhost | test | +-----------+------------------+

开启远程访问

/*二种方法都可以*/ update user set host = "%" where user = "root"; create user 'root'@'%' identified with mysql_native_password by "远程登陆密码"; #密码一定要加引号 grant all privileges on *.* to 'root'@'%' with grant option; flush privileges;

开放3306端口

#开放3306端口 firewall-cmd --zone=public --add-port=3306/tcp --permanent; #重启防火墙 systemctl restart firewalld; firewall-cmd --reload

设置时区

set global time_zone = '+8:00';

安装jdk

vim /etc/profile #配置环境变量 JAVA_HOME=/use/local/java/jdk-11.0.8 PATH=/use/local/java/jdk-11.0.8/bin:$PATH export JAVA_HOME PATH #让配置生效 source /etc/profile