Centos8目前是最新版本的操作系统,采用最小化安装。下面是在Centos8上安装mysql数据库,以下是具体的操作方法、步骤
方法/步骤
1、OS版本CentOSLinuxrelease8.1.1911(Core)
2、[root@localhost~]#groupaddmysql[root@localhost~]#useradd-gmysql-s/sbin/nologinmysql[root@localhost~]#
3、[root@localhost~]#tarzxfmysql-5.7.26-linux-glibc2.12-x86_64.tar.gz[root@localhost~]#mvmysql-5.7.26-linux-glibc2.12-x86_64/usr/local/mysql[root@localhost~]#
4、echo"exportPATH=$PATH:/usr/local/mysql/bin">>/etc/profilesource/etc/profile并测试mysql命令是否可用
5、[root@localhost~]#mysqlERROR2002(HY000):Can'tconnecttolocalMySQLserverthroughsocket'/tmp/mysql.sock'(2)安装yuminstalllibncurses*-y问题解决[root@localhost~]#yuminstalllibncurses*-y
6、[root@localhost~]#mkdir-p/data/mysql[root@localhost~]#chown-Rmysql./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='SETNAMESutf8mb4'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--us娣定撰钠er=mysql-幻腾寂埒-basedir=/usr/local/mysql--datadir=/data/mysql[root@localhost~]#cat/data/mysql/mysql_error.log|greplocalhost2020-04-11T14:39:13.107122Z1[Note]Atemporarypasswordisgeneratedforroot@localhost:sTCJ5xwjoz/A[root@localhost~]#
9、[root@localhost~]#cp/usr/local/mysql/supp艺皱麾酪ort-files/mysql.serv髫潋啜缅er/etc/init.d/mysqld[root@localhost~]#[root@localhost~]#chkconfig--addmysqld[root@localhost~]#[root@localhost~]#chkconfigmysqldon[root@localhost~]#[root@localhost~]#chkconfig--list|grepmysqld
10、[root@localhost~]#/etc/init.d/mysqldstartStartingMySQL..SUCCESS![root@localhost~]#mysql-uroot-p'sTCJ5xwjoz/A'