CentOS 6.5 源码安装MySQL5.6
2024-08-24 16:24:53
1:下载安装cmake (mysql5.5以后是通过cmake来编译的)
#http://download.csdn.net/detail/csxuedn/7976005 #wget http://www.cmake.org/files/v2.8/cmake-2.8.5.tar.gz # tar -zxv -f /root/cmake-2.8.4.tar.gz
# cd cmake-2.8.4
#./configure
Error when bootstrapping CMake:
Cannot find appropriate C++ compiler on this system.
Please specify one using environment variable CXX.
See cmake_bootstrap.log for compilers attempted. #yum install gcc-c++ #./configure
# make && make install
2:创建mysql的安装目录及数据库存放目录
#mkdir -p /gechong/mysql //安装mysql
#mkdir -p /gechong/mysql/data //存放数据库
3:创建mysql用户及用户组
#groupadd mysql
#useradd -g mysql -s /bin/false -M mysql
4:安装mysql
#wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.21.tar.gz
[root@10-4-5-9 gechong]# ls
mysql
[root@10-4-5-9 gechong]# pwd
/gechong
[root@10-4-5-9 gechong]# tar -zxv -f /root/mysql-5.6.21.tar.gz
[root@10-4-5-9 gechong]# cd mysql-5.6.21/
编译:
cmake . \
-DCMAKE_INSTALL_PREFIX=/gechong/mysql \
-DMYSQL_DATADIR=/gechong/mysql/data \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DENABLED_LOCAL_INFILE=1
报错了:
CMake Error at cmake/readline.cmake:85 (MESSAGE):
Curses library not found. Please install appropriate package, remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.
Call Stack (most recent call first):
cmake/readline.cmake:128 (FIND_CURSES)
cmake/readline.cmake:202 (MYSQL_USE_BUNDLED_EDITLINE)
CMakeLists.txt:427 (MYSQL_CHECK_EDITLINE) -- Configuring incomplete, errors occurred!
#yum -y install ncurses-devel
#rm -f CMakeCache.txt
重新编译:
# make clean
# rm -f CMakeCache.txt
# rm -rf /etc/my.cnf
cmake . \
-DCMAKE_INSTALL_PREFIX=/gechong/mysql \
-DMYSQL_DATADIR=/gechong/mysql/data \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DENABLED_LOCAL_INFILE=1
#make && make install
很慢。。。等着吧
5:配置MySQL
# cd /gechong/mysql
# chown -R root:mysql .
# chown -R mysql:mysql data
6:
# cp support-files/my-default.cnf /etc/my.cnf
7:初始化权限表
#scripts/mysql_install_db --user=mysql
8:启动MySQL服务
#ln -s /gechong/mysql/bin/mysql /usr/bin #service mysqld start
10:之后空用户登陆MySQL,删除空用户,对用户赋权限。
最新文章
- iOS---A valid provisioning profile for this executable was not found
- 基于Ruby的Watir-WebDriver自动化测试框架
- c++ const函数是什么意思
- 一个相比jdk的io包更方便处理数据读写的包
- 使用openvswitch实现跨主机docker容器互联
- EDIUS分别输出视频和音频的教程
- 20个超实用的JavaScript技巧及最佳实践
- 【ADO.NET】8、DataSet的使用
- 在小发现SQL字符串比较是不是他们的大写和小写敏感
- Android Skia和2D图形系统 .
- 系统管理员必须掌握的20个Linux监控工具
- Java基础知识二次学习--第六章 常用类
- springBoot系列教程02:mongodb的集成及使用
- Information Retrieval 倒排索引 学习笔记
- 8.代理ip使用
- Three.js粒子特效,shader渲染初探(一篇非常详细的介绍)
- [原] jQuery EasyUI 1.3.4 离线API、Demo (最新)
- windows下非管理员权限安装mysql
- c++ 容器元素填充(generate)
- java异常查看利器之使用 jvmti 的Callback_JVMTI_EVENT_EXCEPTION 事件查看异常