1、OS版本CentOS Linux release 8.1.1911 (Core)
2、[root@localhost ~]# groupadd mysql[root@localhost ~]# useradd -g mysql -s /sbin/nologin mysql[root@localhost ~]#
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 ~]#
4、echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profilesource /etc/profile并测试mysql命令是否可用
5、[root@localhost ~]# mysqlERROR 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
6、[root@localhost ~]# mkdir -p /data/mysql[root@localhost ~]# chown -R mysql. /data/mysql/[root@localhost ~]#
7、vim /etc/my.cnf[client]port = 3306socket = /tmp/mysql.sock[mysqld柯计瓤绘]port = 3306socket = /tmp/mysql.sockpid_file = /data/mysql/mysql.piddatadir = /data/mysqldefault_storage_engine = InnoDBmax_allowed_packet = 512Mmax_connections = 2048open_files_limit = 65535skip-name-resolvelower_case_table_names=1character-set-server = utf8mb4collation-server = utf8mb4_unicode_ciinit_connect='SET NAMES utf8mb4'innodb_buffer_pool_size = 512Minnodb_log_file_size = 1024Minnodb_file_per_table = 1innodb_flush_log_at_trx_commit = 0key_buffer_size = 64Mlog-error = /data/mysql/mysql_error.loglog-bin = /data/mysql/mysql-binbinlog_format = mixedexpire_logs_days = 10slow_query_log = 1slow_query_log_file = /data/mysql/slow_query.loglong_query_time = 1server-id=1
8、[root@localhost ~]# mysqld --initialize --user=mysql -幻腾寂埒-basedir=/usr/local/mysql --datadir=/data/mysql[root@localhost ~]# cat /data/mysql/mysql_error.log |grep localhost2020-04-11T14:39:13.107122Z 1 [Note] A temporary password is generated for root@localhost: sTCJ5xwjoz/A[root@localhost ~]#
9、[root@localhost ~]# cp /usr/local/mysql/support-files/mysql.serv髫潋啜缅er /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
10、[root@localhost ~]# /etc/init.d/mysqld startStarting MySQL.. SUCCESS![root@localhost ~]# mysql -uroot -p'sTCJ5xwjoz/A'
