mysql数据库安装
yum安装
1、下载rpm文件
yum locatinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
2、安装mysql
yum install mysql-community-server -y
本地安装
0、安装第三方依赖包
yum install perl -y
yum install net-tools -y
1、下载MySql压缩包文件,并上传到/root/mysql目录下
mysql-8.0.11-1.el7.x86_64.rpm-bundle.tar
2、解压tar压缩文件
tar xvf mysql-8.0.11-1.el7.x86_64.rpm-bundle.tar
3、卸载mysql
rpm -qa|grep mariadb
rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64 --nodeps
4、安装mysql
rpm -ivh mysql-community-common-8.0.11-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.11-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.11-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.11-1.el7.x86_64.rpm
5、修改/var/lib/mysql目录访问权限
chmod -R 777 /var/lib/mysql
6 、初始化
mysqld --initialize
chmod -R 777 /var/lib/mysql/*
7、启动数据库,前面在线安装后面本地安装
service mysql 或 mysqld start
8、查看临时密码
grep 'temporary password' /var/log/mysqld.log
mysql数据库配置
1、登陆数据库
mysql -u root -p
2、修改数据库密码
alter user user() identified by "abc123456";
3、允许远程使用root账户
UPDATE user SET host =‘%’ WHERE user = ‘root’
FLUSH PRIVILEGES
4、修改/etc/my.cnf
character_set_server = utf8
bind-address = 0.0.0.0
5、开启防火墙3306端口,加到public这个空间
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload