Mysql 5.6.22编译安装
来源:互联网 发布:杨子天珠淘宝店 编辑:程序博客网 时间:2024/05/18 14:44
相信开发者和我一样,最开始安装mysql都是采用yum安装,但是相对于yum安装,编译安装更具有可定制性,下面mark一下我的编译安装mysql,我安装的版本是5.6.22
一.使用yum安装一些依赖
yum -y install make gcc-c++ cmake bison-devel ncurses-develyum install -y gcc gcc-c++ kernel-develyum install -y readline-devel pcre-devel openssl-devel openssl zlib zlib-devel pcre-devel
2.下载编译安装mysql
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.22.tar.gztar -zxvf mysql-5.6.22.tar.gzcd mysql-5.6.22cmake \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_DATADIR=/usr/local/mysql/data \-DSYSCONFDIR=/etc \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_MEMORY_STORAGE_ENGINE=1 \-DWITH_READLINE=1 \-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \-DMYSQL_TCP_PORT=3306 \-DENABLED_LOCAL_INFILE=1 \-DWITH_PARTITION_STORAGE_ENGINE=1 \-DEXTRA_CHARSETS=all \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_cimake && make install
3.创建mysql用户
groupadd mysqluseradd -g mysql mysql
4.创建目录并分配权限
mkdir /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql
5.进入安装目录执行脚本,启动服务
cd /usr/local/mysqlscripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysqlcp support-files/mysql.server /etc/init.d/mysqlrm -rf /etc/my.cnfchkconfig mysql onservice mysql start
6.设置之前,我们需要先设置PATH,要不不能直接调用mysql
ln -s/usr/local/mysql/bin/mysql/usr/bin/
7.现在,我们可以在终端内直接输入mysql进入,mysql的环境了
mysql
8然后开始给数据库管理员设置密码和访问权限
grant all on *.* to root@"%" identified by "密码写这里";FLUSH PRIVILEGES;exit;
这样就可以通过远程访问mysql了,记得把iptables打开
0 0
- Mysql 5.6.22编译安装
- mysql 5.6编译安装
- 编译安装MySQL-5.6
- 编译安装mysql 5.6
- 源码编译安装MySQL 5.6.22
- 源码编译安装MySQL 5.6.22
- Ubuntu14.04 编译安装 MySQL-5.6.22
- Mysql-5.6.28编译安装
- Linux CentOS6.5下编译安装MySQL 5.6.22
- CentOS 6.6/Fedora 21 源码编译安装 mysql 5.6.22
- Linux CentOS6.0下编译安装MySQL 5.6.22
- Linux源码安装mysql 5.6.22 (cmake编译)
- Linux CentOS6.5下编译安装MySQL 5.6.22
- Linux CentOS6.5下编译安装MySQL 5.6.22
- Centos 5.6编译安装mysql 5.5.11
- CentOS 6.4 编译安装 MySQL-5.6
- CentOS 6.4 优化编译安装MySQL-5.6
- CentOS 编译源码安装MySQL-5.6.16
- Aizu 2450 Do use segment tree (树链剖分)
- mobius HDOJ 5468 Puzzled Elena
- SimpleCalculator
- java字符串与整数之间的互相转换
- 第四周--项目1
- Mysql 5.6.22编译安装
- Picasso分析02
- 03crawler01 爬取直播电视剧列表
- 你所厌恶的正是别人渴望的
- 软工文档总结
- 浅谈javascript的五种基本数据类型
- JDK,JRE,JVM区别与联系
- Star Schema完全参考手册读书笔记一
- 使用Xshell连接Linux连接不上