扫二维码与项目经理沟通
我们在微信上24小时期待你的声音
解答本文疑问/技术咨询/运营咨询/技术建议/互联网交流
这篇文章主要介绍“MySQL-5.5.32 cmake安装的步骤”,在日常操作中,相信很多人在Mysql-5.5.32 cmake安装的步骤问题上存在疑惑,小编查阅了各式资料,整理出简单好用的操作方法,希望对大家解答”Mysql-5.5.32 cmake安装的步骤”的疑惑有所帮助!接下来,请跟着小编一起来学习吧!
创新互联公司主营章丘网站建设的网络公司,主营网站建设方案,成都app软件开发,章丘h5小程序制作搭建,章丘网站营销推广欢迎章丘等地区企业咨询
1.拷贝cmake-2.8.8.tar.gz和mysql-5.5.32.tar.gz至/opt文件夹下
2.切换到opt目录
[root@mysql
~]# cd /opt
[root@mysql
opt]# ls
cmake-2.8.8.tar.gz
mysql-5.5.32.tar.gz rh
3.解压cmake文件
[root@mysql
opt]# tar xf cmake-2.8.8.tar.gz
[root@mysql
opt]# cd cmake-2.8.8
[root@mysql
cmake-2.8.8]# ls
bootstrap
CompileFlags.cmake doxygen.config
ChangeLog.manual
configure
Example
ChangeLog.txt
Copyright.txt Modules
CMakeCPack.cmake
CTestConfig.cmake Readme.txt
CMakeCPackOptions.cmake.in
CTestCustom.cmake.in Source
CMakeGraphVizOptions.cmake
CTestCustom.ctest.in Templates
CMakeLists.txt
DartConfig.cmake Tests
CMakeLogo.gif
DartLocal.conf.in Utilities
cmake_uninstall.cmake.in
Docs
4.进行cmake的安装
[root@mysql
cmake-2.8.8]# ./configure
CMake
has bootstrapped. Now run gmake.
[root@mysql
cmake-2.8.8]# gmake
[root@mysql
cmake-2.8.8]# gmake install
5.添加mysql用户和组
[root@mysql
cmake-2.8.8]# groupadd mysql
[root@mysql
cmake-2.8.8]# useradd mysql -s /sbin/nologin -M -g mysql
6.yum安装ncurses-devel
[root@mysql
/]# yum install ncurses-devel -y
7.解压mysql文件
[root@mysql
/]# cd /opt
[root@mysql
opt]# tar xf mysql-5.5.32.tar.gz
[root@mysql
opt]# cd mysql-5.5.32
[root@mysql
mysql-5.5.32]# ls
BUILD
CMakeLists.txt COPYING
include
libmysqld mysys
regex sql-common
tests win
BUILD-CMAKE
cmd-line-utils dbug
INSTALL-SOURCE libservices packaging
scripts storage
unittest zlib
client
config.h.cmake Docs
INSTALL-WIN-SOURCE
man
plugin sql
strings VERSION
cmake
configure.cmake extra
libmysql
mysql-test README sql-bench
support-files vio
8.安装之前编译mysql
cmake .
-DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32 \
-DMYSQL_DATADIR=/application/mysql-5.5.32/data
\
-DMYSQL_UNIX_ADDR=/application/mysql-5.5.32/tmp/mysql.sock
\
-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii
\
-DENABLED_LOCAL_INFILE=ON
\
-DWITH_INNOBASE_STORAGE_ENGINE=1
\
-DWITH_FEDERATED_STORAGE_ENGINE=1
\
-DWITH_BLACKHOLE_STORAGE_ENGINE=1
\
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1
\
-DWITH_FAST_MUTEXES=1
\
-DWITH_ZLIB=bundled
\
-DENABLED_LOCAL_INFILE=1
\
-DWITH_READLINE=1
\
-DWITH_EMBEDDED_SERVER=1
\
-DWITH_DEBUG=0
9.mysql安装
[root@mysql mysql-5.5.32]# make && make
install
[root@mysql mysql-5.5.32]# ln -s
/application/mysql-5.5.32/ /application/mysql
如果make到63%左右出现错误:
make[2]: ***
[storage/perfschema/unittest/pfs_connect_attr-t] Error 1
make[1]: ***
[storage/perfschema/unittest/CMakeFiles/pfs_connect_attr-t.dir/all] Error 2
则:cmake去掉-DWITH_PARTITION_STORAGE_ENGINE=1参数重新编译
10.选择配置文件
[root@mysql
mysql-5.5.32]# cp support-files/my-small.cnf /etc/my.cnf
cp:
overwrite `/etc/my.cnf'? y
11.查看是否有mysql/data目录
[root@mysql mysql-5.5.32]# ll
/application/mysql/data/
total
4
drwxr-xr-x.
2 root root 4096 Aug 15 15:38 test
12.相关授权
[root@mysql mysql-5.5.32]# chown -R mysql.mysql
/application/mysql/data/
[root@mysql
mysql-5.5.32]# chmod -R 1777 /tmp/
13.数据库初始化
[root@mysql mysql-5.5.32]# cd
/application/mysql/scripts/
[root@mysql
scripts]# ls
mysql_install_db
[root@mysql
scripts]# cd /application/mysql/scripts/
[root@mysql
scripts]# ./mysql_install_db --basedir=/application/mysql/
--datadir=/application/mysql/data/ --user=mysql
Installing
MySQL system tables...
OK
Filling
help tables...
OK
14.启动配置
[root@mysql
mysql]# cd /opt/mysql-5.5.32
[root@mysql
mysql-5.5.32]# cp support-files/mysql.server /etc/init.d/mysqld
[root@mysql
mysql-5.5.32]# chmod +x /etc/init.d/mysqld
[root@mysql
mysql-5.5.32]# /etc/init.d/mysqld start
Starting
MySQL.. SUCCESS!
[root@mysql
mysql-5.5.32]# netstat -lntup|grep 3306
tcp
0 0
0.0.0.0:3306
0.0.0.0:*
LISTEN 28462/mysqld
15.配置环境变量
[root@mysql mysql-5.5.32]# echo 'export
PATH=/application/mysql/bin:$PATH'>>/etc/profile
[root@mysql
mysql-5.5.32]# tail -1 /etc/profile
export
PATH=/application/mysql/bin:$PATH
[root@mysql
mysql-5.5.32]# source /etc/profile
[root@mysql
mysql-5.5.32]# echo $PATH
/application/mysql/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
16.登陆mysql,删除无用配置
[root@mysql mysql-5.5.32]# mysql
mysql>
delete from mysql.user where user='';
mysql>
delete from mysql.user where host='mysql';
mysql>
delete from mysql.user where host='::1';
mysql>
select user,host from mysql.user;
+------+-----------+
|
user | host |
+------+-----------+
|
root | 127.0.0.1 |
|
root | localhost |
+------+-----------+
mysql>
drop database test;
17.配置登陆密码
[root@mysql mysql-5.5.32]#
/application/mysql//bin/mysqladmin -u root password 'cancer'
18.设置mysql开机启动
[root@mysql mysql-5.5.32]# chkconfig mysqld on
[root@mysql
mysql-5.5.32]# chkconfig --list mysqld
mysqld
0:off 1:off 2:on
3:on 4:on 5:on 6:off
19.查看系统语言
[root@mysql mysql-5.5.32]# cat /etc/sysconfig/i18n
LANG="en_US.UTF-8"
SYSFONT="latarcyrheb-sun16"
到此,关于“Mysql-5.5.32 cmake安装的步骤”的学习就结束了,希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习,快去试试吧!若想继续学习更多相关知识,请继续关注创新互联网站,小编会继续努力为大家带来更多实用的文章!
我们在微信上24小时期待你的声音
解答本文疑问/技术咨询/运营咨询/技术建议/互联网交流