使用标准源分发安装MySQL

373405967 • 06/09 16:38 • 数据库 • 阅读 110

编译前安装准备OS:CentOS 6.9
Mysql:5.7.18
下载Mysql源官网源：mysql-boostmysql搜狐源：mysql-boost mysql安装Mysql之前卸载原有的版本查询Mysql目录文件卸载原有MySQL# rpm -qa | grep mysql# find / -name mysql# yum remove -y mysql-libs-5.1.73-3.el6_5.x86_64安装编译环境# yum -y install make wget gcc-c++ cmake bison-devel ncurses-develPreconfiguration setup# groupadd mysql# useradd -r -g mysql -s /bin/false mysqlBeginning of source-build specific instructions# mkdir ~/mysql && cd ~/mysql# mkdir -p /data/mysql_data# wget -c https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-boost-5.7.18.tar.gz# tar -zxvf mysql-boost-5.7.18.tar.gz && cd mysql-5.7.18/# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql_data -DSYSCONFDIR=/etc -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci# make# make installEnd of source-build specific instructionsPostinstallation setup# cd /usr/local/mysql# chown -R mysql .# chgrp -R mysql .Before MySQL 5.7.6# bin/mysql_install_db –user=mysqlMySQL 5.7.6 and up# bin/mysqld –initialize –user=mysql# bin/mysql_ssl_r开发云主机域名sa_setup# chown -R root .# chown -R mysql /data# bin/mysqld_safe –user=mysql &配置开机启动项# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql.server# chmod +x /etc/init.d/mysql.server# chkconfig –add mysql.server# chkconfig mysql.server on配置/etc/my.cnf 仅供参考，可以不配用默认的。启动mysql# service mysql.server start加入开机启动项# chkconfig –live 35 mysql.server on查看端口是否被占用# netstat -tulnp | grep 3306查看数据库版本# ln -s /usr/local/mysql/bin/mysql /usr/bin/# mysql –version登入数据库# mysql -u root -p查看数据库>show databases;重设密码，这里密码设置为?root?>set password = password(‘?root?’);退出数据库>exit;

相关推荐: mysql的慢查询日志记录哪些内容

本篇内容主要讲解“mysql的慢查询日志记录哪些内容”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“mysql的慢查询日志记录哪些内容”吧! 在mysql中，慢查询日志记录的是响应时间超过阈值的语句；响应时间阈值就是…