- Mysql安装包官方下载地址:
https://downloads.mysql.com/archives/community/
2.通过Xshell登录linux服务器,并通过xftp将下载的安装包上传到服务器上
3.解压 tar -xzvf mysql-8.0.23-linux-glibc2.12-x86_64.tar.xz -C /usr/local/
4.创建用户和用户组
[root@localhost ~]# groupadd mysql
[root@localhost ~]# useradd -r -g mysql mysql
5.将安装目录所有者及所属组改为mysql
[root@localhost ~]# chown -R mysql.mysql /usr/local/mysql
6创建data文件夹,用于存放数据库表之类的数据
[root@localhost mysql]# mkdir data #进入mysql文件夹
7安装依赖包:
[root@localhost mysql]# yum install libaio
进行初始化:
[root@localhost mysql]# /usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize
8.编辑配置文件/etc/my.cnf,如果没有就新增:
[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
socket=/tmp/mysql.sock
user=mysql
port=3306
character-set-server=utf8
# 取消密码验证
# skip-grant-tables
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# skip-grant-tables
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
9.将mysql加入到服务中:
[root@localhost mysql]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
10.开机启动
[root@localhost mysql]# service mysql start
11.启动mysql服务
[root@localhost mysql]# service mysql start
12登录mysql
root@localhost mysql]# /usr/local/mysql/bin/mysql -uroot -p
13.修改密码
use mysql;
alter user ‘root’@‘localhost’ identified by ‘123456’;
14.远程可以访问(通过navicat可以连接)
update user set host = ‘%’ where user = ‘root’;
FLUSH PRIVILEGES;
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
FLUSH PRIVILEGES;
重启mysql service mysql restart
如果远程访问依然不行的话,注意查看看是否开启了防火墙,开启的话需要将对应的端口开发,执行下面命令:
查看开放的端口号:
firewall-cmd --list-all
启动默认服务的(http):
firewall-cmd --add-service=http --permanent
开放端口:【红色部分为需要开放的端口】
firewall-cmd --add-port=8080/tcp --permanent
重新加载:
firewall-cmd --reload