linux下使用cmake编译安装mysql的详细教程
一、安装cmake
1、解压cmake压缩包
[root@mysqltools]#tar-zvxfcmake-2.8.8.tar.gz [root@mysqltools]#ls cmake-2.8.8cmake-2.8.8.tar.gzmysql-5.5.16.tar.gzscripts
2、解析
[root@mysqltools]#cdcmake-2.8.8 [root@mysqlcmake-2.8.8]#./configure --------------------------------------------- CMake2.8.8,Copyright2000-2009Kitware,Inc. FoundGNUtoolchain Ccompileronthissystemis:gcc C++compileronthissystemis:g++ Makefileprocessoronthissystemis:gmake g++isGNUcompiler g++hasSTLinstd::namespace g++hasANSIstreams g++hasstreamsinstd::namespace
3、安装
[root@mysqlcmake-2.8.8]#echo$? 0 #如果返回值是0，就是执行成功，如果返回值是1，就是执行失败； [root@mysqlcmake-2.8.8]#gmake&&gmakeinstall ScanningdependenciesoftargetcmIML_test [1%]BuildingCobjectUtilities/KWIML/test/CMakeFiles/cmIML_test.dir/test.c.o [1%]BuildingCobjectUtilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_ABI_C.c.o [1%]BuildingCobjectUtilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_INT_C.c.o [1%]BuildingCobjectUtilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_include_C.c.o [2%]BuildingCXXobjectUtilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_ABI_CXX.cxx.o [2%]BuildingCXXobjectUtilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_INT_CXX.cxx.o [2%]BuildingCXXobjectUtilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_include_CXX.cxx.o
二、开始安装mysql
1、首先需要安装（ncurses-devel）依赖包
[root@mysqlcmake-2.8.8]#cd… [root@mysqltools]#yum-yinstallncurses-devel Loadedplugins:fastestmirror Loadingmirrorspeedsfromcachedhostfile base:mirrors.zju.edu.cn extras:centos.ustc.edu.cn updates:mirrors.zju.edu.cn ResolvingDependencies –>Runningtransactioncheck —>toolsncurses-devel.x86_640:5.9-14.20130511.el7_4willbeinstalled #############安装完成后检查########### [root@mysqltools]#rpm-qa|grepncurses-devel ncurses-devel-5.9-14.20130511.el7_4.x86_64 [root@mysqltools]#
2、解压mysql压缩包
[root@mysqltools]#tar-zvxfmysql-5.5.16.tar.gz [root@mysqltools]#ls cmake-2.8.8cmake-2.8.8.tar.gzmysql-5.5.16mysql-5.5.16.tar.gzscripts [root@mysqltools]#
3、创建虚拟用户
[root@mysqltools]#useraddmysql-s/sbin/nologin-M [root@mysqltools]#idmysql uid=1000(mysql)gid=1000(mysql)groups=1000(mysql) [root@mysqltools]#
4、配置解析
[root@mysqltools]#cdmysql-5.5.16 [root@mysqlmysql-5.5.16]# [root@mysqlmysql-5.5.16]#cmake.-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.5.16-DMYSQL_DATADIR=/usr/local/mysql-5.5.16/data-DMYSQL_UNIX_ADDR=/usr/local/mysql-5.5.16/tmp/mysql.sock-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-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-DWITHOUT_PARTITION_STORAGE_ENGINE=1-DWITH_FAST_MUTEXES=1-DWITH_ZLIB=bundled-DENABLED_LOCAL_INFILE=1-DWITH_READLINE=1-DWITH_EMBEDDED_SERVER=1-DWITH_DEBUG=0
5、安装
[root@mysqlmysql-5.5.16]#make&&makeinstall ScanningdependenciesoftargetINFO_BIN [0%]BuilttargetINFO_BIN ScanningdependenciesoftargetINFO_SRC [0%]BuilttargetINFO_SRC Scanningdependenciesoftargetabi_check [0%]Builttargetabi_check Scanningdependenciesoftargetzlib
6、创建软连接
[root@mysqlmysql-5.5.16]#ln-s/usr/local/mysql-5.5.16//usr/local/mysql [root@mysqlmysql-5.5.16]#readlink/usr/local/mysql /usr/local/mysql-5.5.16/ [root@mysqlmysql-5.5.16]#
7、配置环境
[root@mysqlmysql-5.5.16]#cd… [root@mysqltools]#echo‘exportPATH=/usr/local/mysql/bin:$PATH'>>/etc/profile [root@mysqltools]#tail-1/etc/profile exportPATH=/usr/local/mysql/bin:$PATH [root@mysqltools]#source/etc/profile [root@mysqltools]#echo$PATH /usr/local/mysql/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin [root@mysqltools]#
8、拷贝、查看、设置属主、及添加tmp权限
[root@mysqltools]#\cpmysql-5.5.16/support-files/my-small.cnf/etc/my.cnf [root@mysqltools]#ll/usr/local/mysql/data/ total0 drwxr-xr-x2rootroot20May3111:51test [root@mysqltools]#chown-Rmysql.mysql/usr/local/mysql/data/ [root@mysqltools]#chmod-R1777/tmp/ [root@mysqltools]#
9、初始化数据库
[root@mysqltools]#cd/usr/local/mysql/scripts/ [root@mysqlscripts]#./mysql_install_db--basedir=/usr/local/mysql/--datadir=/usr/local/mysql/data/--user=mysql InstallingMySQLsystemtables… OK Fillinghelptables… OK
注：看到两个ok表示成功
10、设置开机启动
[root@mysqlscripts]#cd/roottools/mysql-5.5.16 [root@mysqlmysql-5.5.16]#cpsupport-files/mysql.server/etc/init.d/mysqld [root@mysqlmysql-5.5.16]#chmod-R755/etc/init.d/mysqld [root@mysqlmysql-5.5.16]#chkconfig--addmysqld [root@mysqlmysql-5.5.16]#chkconfigmysqldon [root@mysqlmysql-5.5.16]#chkconfig--listmysqld Note:ThisoutputshowsSysVservicesonlyanddoesnotincludenative systemdservices.SysVconfigurationdatamightbeoverriddenbynative systemdconfiguration. Ifyouwanttolistsystemdservicesuse‘systemctllist-unit-files'. Toseeservicesenabledonparticulartargetuse ‘systemctllist-dependencies[target]'. mysqld0:off1:off2:on3:on4:on5:on6:off [root@mysqlmysql-5.5.16]#
11、启动mysql数据库
[root@mysqlmysql-5.5.16]#/etc/init.d/mysqldstart StartingMySQL…SUCCESS! [root@mysqlmysql-5.5.16]#
12、查看端口进程
[root@mysqlmysql-5.5.16]#lsof-i:3306 COMMANDPIDUSERFDTYPEDEVICESIZE/OFFNODENAME mysqld51146mysql10uIPv4826000t0TCP:mysql(LISTEN) [root@mysqlmysql-5.5.16]#netstat-lnutp|grep3306 tcp000.0.0.0:33060.0.0.0:LISTEN51146/mysqld [root@mysqlmysql-5.5.16]#ps-ef|grep3306 mysql5114650900014:13pts/100:00:00/usr/local/mysql-5.5.16/bin/mysqld--basedir=/usr/local/mysql-5.5.16--datadir=/usr/local/mysql-5.5.16/data--plugin-dir=/usr/local/mysql-5.5.16/lib/plugin--user=mysql--log-error=/usr/local/mysql-5.5.16/data/mysql.err--pid-file=/usr/local/mysql-5.5.16/data/mysql.pid--socket=/usr/local/mysql-5.5.16/tmp/mysql.sock--port=3306 root5117016240014:14pts/100:00:00grep--color=auto3306 [root@mysqlmysql-5.5.16]#
注：如果要重新初始化只要删除data目录库文件存储地或者新建一个库文件存储地，重新初始化，提示两个ok就是成功
进入数据库
[root@localhost~]#mysql
查看所有用户
mysql>usemysql mysql>showtables; mysql>selectuser,hostfromuser;
删除系统默认的
deletefrommysql.userwhereuser=''; deletefrommysql.userwherehost='::1'; selectuser,hostfrommysql.user;
只保留这两个
mysql>selectuser,hostfrommysql.user; ±-----±----------+ |user|host| ±-----±----------+ |root|127.0.0.1| |root|localhost| ±-----±----------+ 2rowsinset(0.00sec) mysql> #########################
添加额外的授权管理员用户
grantallprivilegeson.tosystem@‘192.168.%'identifiedby‘system'withgrantoption;
字符集路径
vi/etc/locale.conf#centos7
mysql创建密码
/application/mysql//bin/mysqladmin-urootpassword‘123456'
mysql修改密码
/application/mysql//bin/mysqladmin-uroot-p123456password‘112233'
总结
以上所述是小编给大家介绍的linux下使用cmake编译安装mysql的详细教程,希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对毛票票网站的支持！
如果你觉得本文对你有帮助，欢迎转载，烦请注明出处，谢谢！