linux操作系统下mysql 8.0安装教程

linux操作系统下mysql 8.0安装教程

1、下载

MySQL :: Download MySQL Community Server (Archived Versions)

2、解压

tar -xf mysql-8.0.25-linux-glibc2.12-x86_64.tar.xz    #解压

mv mysql-8.0.25-linux-glibc2.12-x86_64 /usr/local/mysql

3、创建mysql用户组和mysql用户

groupadd mysql

useradd -s /sbin/nologin -M -g mysql mysql

4、设置mysql目录访问权限，用户组

mkdir -p /data/mysql

mkdir -p /data/mysql/{data,logs,tmp}

chown -R mysql.mysql /usr/local/mysql

chown -R mysql.mysql /data/mysql/

5、初始化mysql

/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/data/

6、配置文件

[client]

socket=/data/mysql/tmp/mysql.sock

[mysqld]

server_id=1

user=mysql

port=3306

basedir=/usr/local/mysql

datadir=/data/mysql/data

socket=/data/mysql/tmp/mysql.sock

log_error=/data/mysql/logs/mysqld.log

log-bin = bin.log

max_binlog_size=100M

expire_logs_days=10

skip-name-resolve

character_set_server=utf8mb4

default-time-zone = '+8:00'

log_timestamps = SYSTEM

#skip-grant-tables

7、配置mysql自动启动

touch /data/mysql/logs/mysqld.log

touch /data/mysql/tmp/mysql.sock

touch /data/mysql/tmp/mysqld.pid

chown -R mysql.mysql /data/mysql/

cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld

chmod +x /etc/rc.d/init.d/mysqld

加入启动项：

chkconfig --add mysqld

chkconfig mysqld on

启动：

/etc/init.d/mysqld start

8、配置mysql到环境变量

vim /etc/profile

#mysql

PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH

export PATH

source /etc/profile

9、修改密码

忘记密码：

skip-grant-tables

mysql>alter user 'root'@'localhost' identified by '123456';

mysql>flush privileges;

mysql>quit;

10、远程访问

修改root用户可以远程连接 update user set host = '%' where user = 'root';

刷新权限 flush privileges;