Mysql5.5cmake源码编译安装
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Mysql5.5cmake源码编译安装,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4892字,纯文字阅读大概需要7分钟。
内容图文
[root@hcf tools]# wget https://cmake.org/files/v2.8/cmake-2.8.8.tar.gz
1.1查看系统环境
[root@hcf tools]# cat /etc/redhat-release
CentOS release 6.9 (Final)
[root@hcf tools]# uname -r
2.6.32-696.10.2.el6.x86_64
[root@hcf tools]# uname -m
x86_64
1.2安装cmake包
[root@hcf tools]# tar zxf cmake-2.8.8.tar.gz
[root@hcf tools]# cd cmake-2.8.8
[root@hcf cmake-2.8.8]# ./configure
报以下错时安装yum install –y gcc gcc-c++即可:Cannot find appropriate C compiler on this system.
Please specify one using environment variable CC.
安装成功提示: CMake has bootstrapped. Now run gmake.
[root@hcf cmake-2.8.8]# gmake
[100%] Built target foo表示安装完成
[root@hcf cmake-2.8.8]# gmake install
[root@hcf cmake-2.8.8]# cd ../
1.3开始安装mysql
mkdir /application/mysql-5.5.32 -p
[root@hcf mysql-5.1.72]# groupadd mysql
[root@hcf mysql-5.1.72]# useradd mysql -s /sbin/nologin -g mysql -M
yum install ncurses-devel –y(否则编译出错,将编译的目录删掉重新来)
[root@hcf mysql-5.1.72]# tar zxf mysql-5.5.32.tar.gz
[root@hcf mysql-5.1.72]# cd mysql-5.5.32
cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32 \ -DMYSQL_DATADIR=/application/mysql-5.5.32/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_ci
|
cmake .回车符去掉否则可能报错 -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32 \ -DMYSQL_DATADIR=/application/mysql-5.5.32/mysql/data \ -DMYSQL_UNIX_ADDR=/application/mysql5.5.32/tmp/mysql.sock \ -DMYSQL_TCP_PORT=3306 \ -DENABLED_LOCAL_INFILE=ON \ -DWITH_PARTITION_STORAGE_ENGINE=1 \ -DEXTRA_CHARSETS=all \ -DDEFAULT_CHARSET=gbk \ -DDEFAULT_COLLATION=gbk_chinese_ci \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_FEDERATED_STORAGE_ENGINE=1 \ -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \ -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \ -DWITHOUT_PARTITION_STORAGE_ENGINE=1 |
-- Build files have been written to: /home/wj/tools/mysql-5.5.32出现这个就成功了
make
[100%] Built target my_safe_process就成功了
make install
[root@hcf application]# ln -s /application/mysql5.5.32/ /application/mysql
[root@hcf tools]# ll mysql-5.5.32/support-files/*.cnf
2.选择配置文件
[root@hcf tools]# cp mysql-5.5.32/support-files/my-small.cnf /etc/my.cnf
里面的datadir=/usr/local/mysql/var改换成自己的mysql的data安装目录,否则启动mysqld服务将失败
3.配置环境变量
echo export PATH=/application/mysql/bin:$PATH >>/etc/profile
tail –1 /etc/profile
source /etc/profile
echo $PATH
提示:
更简单的设置方法
用下面命令做软链接:
ln-s/application/mysql/bin/*/usr/local/sbin/
或者把mysql命令所在路径链接到全局路径/usr/local/sbin/的下面。
4.初始化数据文件(容易出错的步骤)
[root@hcf tools]# mkdir -p /application/mysql/data 建立mysql数据文件目录
[root@hcf tools]# chown -R mysql.mysql /application/mysql/* 授权mysql用户管理mysql的安装目录
chown -R 1777 /tmp
[root@hcf application]# /application/mysql/scripts/mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data --user=mysql
5.5版本后mysql_install_db在scripts目录中,5.1的在bin目录中
安装mysql数据库文件
特别提示:
- 如果用mysql5.0,5.1省略指定datadir会出错.
- 正确提示:
Installing mysql system tables…
OK
Filling help tables…
OK
- 报错:mysql_install_db问题
Error:1005 Can’t create table ‘tmp_db’(errno:13)
解决:chown –R mysql.mysql /application/mysql/*
Error: 1 can’t create/write to file ‘/tmp/#sql_7340_0.MYI’(Errcode:13)
解决:chmod –R 1777 /tmp
[root@hcf tools]# cp /application/mysql/bin/mysql.server /etc/init.d/mysqld
chmod 700 /etc/init.d/mysqld
/etc/init.d/mysqld start
报错The server quit without updating PID file (/[FAILED]ion/mysql-5.5.32/mysql/data/taikang.pid)
请在[mysqld]下设置这一行:datadir = /usr/local/mysql/data
解决方法: http://www.jb51.net/article/48625.htm
登录mysql: [root@taikang data]# mysql
报错: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
解决:登录不上去,如果是刚装完数据库出现的错误,将mysql进程杀掉mysql下的data删掉后,重新初始化数据文件
/application/mysql/scripts/mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data --user=mysql
报错: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
解决:mysql可能没启动了
[root@hcf tools]# chkconfig mysqld on
[root@hcf tools]# chkconfig --list mysqld
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
简单优化:
mysql> drop database test;
mysql> delete from mysql.user; 删掉所有的用户
添加system用户并且带有给其他用户授权权限
mysql> grant all privileges on *.* to system@'localhost' identified by 'wj123' with grant option;
mysql> grant all privileges on *.* to system@'127.0.0.1' identified by 'wj123' with grant option;
mysql> show grants for system@'localhost';
mysql> flush privileges;刷新权限
内容总结
以上是互联网集市为您收集整理的Mysql5.5cmake源码编译安装全部内容,希望文章能够帮你解决Mysql5.5cmake源码编译安装所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。