Linux下MySQL8.0安装配置

1、编译安装MySQL8.0版本信息#cat/etc/redhat-releaseCentOSLinuxrelease7.5.1804(Core)安装依赖包yum-yinstallwgetcmakegccgcc-c++ncursesncurses-devellibaio-developensslopenssl-develrpm-qa|greplibaiomuinstalllibaiolibaio-devel下载源码包wgethttps：//dev.mysql.com/get/Downloads/MySQL-8.0/mysql-boost-8.0.12.tar.gz创建用户并创建数据目录并赋予用户目录权限groupaddmysqluseradd-r-gmysql-s/sbin/nologinmysqlmkdir-p/usr/local/mysqlmkdir-p/data/mysqlchown-Rmysql.mysql/usr/local/mysqlchown-Rmysql.mysql/data/mysqlchmod-R755/usr/local/mysql/chmod-R755/data/mysql/解压和开始安装tar-zxfmysql-boost-8.0.12.tar.gz配置cdmysql-8.0.12cmake.-DCMAKE_INSTALL_PREFIX=/usr/local/mysql\-DMYSQL_DATADIR=/data/mysql\-DSYSCONFDIR=/etc\-DMYSQL_TCP_PORT=3306\-DWITH_BOOST=~/mysql-8.0.12/boost\-DDEFAULT_CHARSET=utf8\-DDEFAULT_COLLATION=utf8_general_ci\-DENABLED_LOCAL_INFILE=ON\-DWITH_INNODB_MEMCACHED=ON\-DWITH_INNOBASE_STORAGE_ENGINE=1\-DWITH_FEDERATED_STORAGE_ENGINE=1\-DWITH_BLACKHOLE_STORAGE_ENGINE=1\-DWITH_ARCHIVE_STORAGE_ENGINE=1\-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1\-DWITH_PERFSCHEMA_STORAGE_ENGINE=1配置参数说明：CMAKE_INSTALL_PREFIX：指定基本安装目录MYSQL_DATADIR：指定数据目录SYSCONFDIR=/etc：指定配置文件扫描目录MYSQL_TCP_PORT：指定端口号WITH_BOOST：指定boost所在目录locatedDEFAULT_CHARDEFAULT_COLLATION:指定默认排序规则ENABLED_LOCAL_INFILE=ON:是否启用localWITH_INNODB_MEMCACHED=ONforloaddatainfile:是否生成memcached共享库Compile&installmake&&makeinstallinitializedatabasemysqld--initialize-insecure--user=mysql--basedir=/usr/local/mysql--datadir=/data/mysql创建配置文件cat>/etc/my.cnf<>/etc/profilesource/etc/profile配置启动脚本cp../mysql-8.0.12/support-files/mysql.server/etc/init.d/mysqldvim/etc/init.d/mysqldchmod+x/etc/init.d/mysqld/etc/init.d/mysqldstartcentos7系统自启动脚本cat/usr/lib/systemd/system/mysqld.服务[单位]描述=mysqlserverdaemonDocumentation=man:mysql(8)Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.htmlAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=mysqlGroup=mysqlType=notifyTimeoutSec=0PermissionsStartOnly=trueExecStart=/usr/local/mysql/bin/mysqld$MYSQLD_OPTSLimitNOFILE=10000Restart=alwaysRestartPreventExitStatus=1Environment=MYSQLD_systemPARENT_PID=1PrivateTmp=ctlsesqlstart:MySQLservice使用WITH修改root密码认证方式mysql-urootALTERUSER'root'@'localhost'IDENTIFIEDWITHmysql_native_passwordBY'你的密码';ALTERUSER'root'@'localhost'IDENTIFIEDWITHcaching_sha2_passwordBY'你的密码';检查密码字段和加密方式selecthost,user,authentication_string,pluginfromuser;2、yum仓库安装MySQLwgethttps://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpmyumlocalinstallmysql80-community-release-el7-1.noarch.rpmyumrepolisenabled|grep"mysql.*-community.*"yumrepolilistall|grepmysqlyuminstallmysql-community-serversystemctlenablemysqldsystemctlstartmysqldnetstat-lntup|grep3306查看随机生成的密码grep'temporarypassword'/var/log/mysqld.logmysql-uroot-p修改密码，密码必须由大写和alteruser'root'@'localhost'identifiedby'PJY@123.com'的小写字母组成；选择版本（）；