Centos 8 安装MySQL 方法

2025-11-09 17:19:14

1、OS版本CentOS Linux release 8.1.1911 (Core)

Centos 8 安装MySQL 方法

2、[root@localhost ~]# groupadd mysql

[root@localhost ~]# useradd -g mysql -s /sbin/nologin mysql

[root@localhost ~]#

Centos 8 安装MySQL 方法

3、[root@localhost ~]# tar zxf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz

[root@localhost ~]# mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql

[root@localhost ~]#

Centos 8 安装MySQL 方法

4、echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile

source /etc/profile

并测试mysql命令是否可用

Centos 8 安装MySQL 方法

5、[root@localhost ~]# mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

安装yum install libncurses* -y问题解决

[root@localhost ~]# yum install libncurses* -y

Centos 8 安装MySQL 方法

6、[root@localhost ~]# mkdir -p /data/mysql

[root@localhost ~]# chown -R mysql. /data/mysql/

[root@localhost ~]#

Centos 8 安装MySQL 方法

7、vim /etc/my.cnf

[client]

port = 3306

socket = /tmp/mysql.sock

[mysqld]

port = 3306

socket = /tmp/mysql.sock

pid_file = /data/mysql/mysql.pid

datadir = /data/mysql

default_storage_engine = InnoDB

max_allowed_packet = 512M

max_connections = 2048

open_files_limit = 65535

skip-name-resolve

lower_case_table_names=1

character-set-server = utf8mb4

collation-server = utf8mb4_unicode_ci

init_connect='SET NAMES utf8mb4'

innodb_buffer_pool_size = 512M

innodb_log_file_size = 1024M

innodb_file_per_table = 1

innodb_flush_log_at_trx_commit = 0

key_buffer_size = 64M

log-error = /data/mysql/mysql_error.log

log-bin = /data/mysql/mysql-bin

binlog_format = mixed

expire_logs_days = 10

slow_query_log = 1

slow_query_log_file = /data/mysql/slow_query.log

long_query_time = 1

server-id=1

Centos 8 安装MySQL 方法

8、[root@localhost ~]# mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

[root@localhost ~]# cat /data/mysql/mysql_error.log |grep localhost

2020-04-11T14:39:13.107122Z 1 [Note] A temporary password is generated for root@localhost: sTCJ5xwjoz/A

[root@localhost ~]#

Centos 8 安装MySQL 方法

9、[root@localhost ~]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

[root@localhost ~]#

[root@localhost ~]# chkconfig --add mysqld

[root@localhost ~]#

[root@localhost ~]# chkconfig mysqld on

[root@localhost ~]#

[root@localhost ~]# chkconfig --list |grep mysqld

Centos 8 安装MySQL 方法

10、[root@localhost ~]# /etc/init.d/mysqld start

Starting MySQL.. SUCCESS!

[root@localhost ~]# mysql -uroot -p'sTCJ5xwjoz/A'

Centos 8 安装MySQL 方法

声明：本网站引用、摘录或转载内容仅供网站访问者交流或参考，不代表本站立场，如存在版权或非法内容，请联系站长删除，联系邮箱：site.kefu@qq.com。