CentOS7 源码安装mysql 5.7
来源:互联网 发布:sql查询字段包含分号 编辑:程序博客网 时间:2024/05/17 06:49
CentOS 7 源码安装mysql 5.7
Mysql官网
下载mysql安装包到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz md5sum mysql-5.6.25.tar.gz
一、安装环境
卸载Mariadb
rpm -qa|grep -i mariadb-libsyum remove mariadb-libs-*.*.**-**.x86_64
安装Mysql所需包
yum -y install make bison-devel ncures-devel libaio libaio-devel perl-Data-Dumper net-toolsyum -y install bison*yum -y install gcc-c++yum -y install cmake*yum -y install ncursesyum -y install ncurses-develmkdir /usr/local/boostcd /usr/local/boostwget https://jaist.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gztar -zxvf boost_1_59_0.tar.gz
二、安装
打包mysql
tar -zxvf mysql-5.7.17.tar.gzcd mysql-5.7.17cmake \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc/my.cnf -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=/usr/local/boost/
打包失败删除文件重新打包
rm -rf CMakeCache.txt
打包完成后安装命令
make&&make install
检查系统是否已经有mysql用户,如果没有则创建
cat /etc/passwd | grep mysqlcat /etc/group | grep mysql
创建mysql用户(但是不能使用mysql账号登陆系统)
groupadd mysqluseradd mysql -g mysql -M -s /sbin/nologin
修改权限
chown -R mysql:mysql /usr/local/mysql
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
下载mysql到制定目录下
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
源码安装(安装多个数据库需要这个)
添加mysql用户 , 操作文件夹都用chown mysql权限
a、安装环境
只有cmake 不对。 就是环境问题。
b、下载源码包
mysql官网
c、解压源码包
tar -zxvf *.tar.gz
d、编译安装
rm -rf CMakeCache.txt (第二次执行 cmake 时注意删除CMakeCache)
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql3310 -DSYSCONFDIR=/usr/local/mysql3310/etc -DMYSQL_DATADIR=/mnt/mysql3310/data -DMYSQL_TCP_PORT=3310 - DMYSQL_UNIX_ADDR=/usr/local/mysql3310/mysqld.sock -DMYSQL_USER=mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_SSL=bundled
make
make install
e、初始化话数据库
./scripts/mysql_install_db –user=mysql –datadir=/mnt/mysql3311/data
f、设置my。cn配置文件
a、cp my.cnf etc/my.cnf
[mysqld]
basedir = /usr/local/mysql3310
datadir = /mnt/mysql3310/data
port = 3310
server_id = 3310
socket=/usr/local/mysql3310/mysqld.sock
log_bin=log_bin
g、设置启动服务
1、配置
cp support-files/mysql.server /etc/init.d/mysql3311 (ubuntu 只需要这一步)
chkconfig –add mysql3311 (linux 还需要这一步)
2、启动
sudo service mysql3311 start (ubuntu)
service mysql3311 start (linux)
h、修改密码
/usr/local/mysql3311/bin/mysqladmin -u root password bfmx2016 #只有刚安装完后,此命令有有效。设置超级管理员密码
i、登录 设置权限
grant all privileges on . to root@’%’ identified by ‘bfmx2016’;
flush privileges;
- CentOS7 源码安装mysql 5.7
- Centos7源码安装mysql
- docker centos7 源码安装MySQL-5.7
- docker centos7 源码安装MySQL-5.7
- centos7下mysql 5.7.20源码安装
- CentOS7 源码安装 MySQL 5.6
- CentOS7 源码安装 MySQL 5.6
- CentOS7 安装mysql 5.7
- Centos7 安装Mysql 5.7
- CentOS7 安装MySQL 5.7
- Centos7使用编译源码方式安装mysql
- CentOS7 yum 安装 MySQL 5.7
- Centos7安装mysql-5.7.11
- centos7 配置安装 mysql 5.7
- Centos7 离线安装mysql 5.7
- centos7安装MySQL 5.7.19
- Linux(CentOS7)安装MySQL-5.7
- CentOS7下nginx-1.8.1+mysql-5.7.11+php-5.5.33环境的LNMP源码安装
- 树的子结构
- pyhton题目-----stack by list
- Automation错误 定义的应用程序或对象错误-"Scripting.FileSystemObject"
- js正则操作
- JavaScript桶排序
- CentOS7 源码安装mysql 5.7
- Android案例之新闻客户端和服务器端采用php+mysql实现,完全属于自己的新闻展示平台
- 设置验证级别防止非法登陆
- 优化Redis内存的9个要点
- 十大算法
- 更换kernel启动logo图片
- android Intent : android.intent.category.DEFAULT的用途和使用
- 423. Reconstruct Original Digits from English**
- 文章标题