星空网 > 软件开发 > 数据库

VMware10.0.4下 CentOS 6.5 cmake安装 MySQL 5.5.32

一、准备工作

1.1、创建 zhuzz/tools目录

[root@localhost ~]# mkdir -p /home/zhuzz/tools[root@localhost ~]# cd /home/zhuzz/tools

 

1.2、将cmake-2.8.8.tar.gz|mysql-5.5.32.tar 上传至 zhuzz/tools目录

[root@localhost tools]# rz -y

 

1.3、解压cmake安装包
[root@localhost tools]# tar xf cmake-2.8.8.tar.gz



 
1.4、安装cmake安装包
[root@localhost tools]# cd cmake-2.8.8[root@localhost cmake-2.8.8]# ./configure


##### 报错 #####
---------------------------------------------CMake 2.8.8, Copyright 2000-2011 Kitware, Inc.---------------------------------------------Error when bootstrapping CMake:Cannot find appropriate C compiler on this system.Please specify one using environment variable CC.See cmake_bootstrap.log for compilers attempted. ---------------------------------------------Log of errors: /home/zhuzz/tools/cmake-2.8.8/Bootstrap.cmk/cmake_bootstrap.log---------------------------------------------


##### 解决方法 下载安装gcc-c++ #####
[root@localhost cmake-2.8.8]# yum install gcc-c++

 



[root@localhost cmake-2.8.8]# gmake [root@localhost cmake-2.8.8]# gmake install

 

1.5、安装依赖包 ncurses-devel
[root@localhost cmake-2.8.8]# yum install ncurses-devel -y


 
 
二、安装
2.1、创建用户和组
[root@localhost cmake-2.8.8]# groupadd mysql[root@localhost cmake-2.8.8]# useradd mysql -s /sbin/nologin -M -g mysql

 


2.2、解压 mysql-5.5.32.tar.gz 并 进入此目录
[root@localhost cmake-2.8.8]# cd ..[root@localhost tools]# tar xf mysql-5.5.32.tar.gz[root@localhost tools]# cd mysql-5.5.32

 

2.3、解压编译MySQL安装包
[root@localhost tools]# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.5.32 \-DMYSQL_DATADIR=/usr/local/mysql-5.5.32/data \-DMYSQL_UNIX_ADDR=/usr/local/mysql-5.5.32/tmp/mysql.sock \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_FEDERATED_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \-DWITH_READLINE=1 \-DENABLED_LOCAL_INFILE=1 \-DWITH_DEBUG=0 \

 

[root@localhost mysql-5.5.32]# make && make install

 

2.4、创建软链接
[root@localhost mysql-5.5.32]# ln -s /usr/local/mysql-5.5.32/ /usr/local/mysql

 



2.5、配置文件
[root@localhost mysql-5.5.32]# cp support-files/my-small.cnf /etc/my.cnf 

 



 
2.6、配置环境变量
[root@localhost mysql-5.5.32]# echo 'export PATH=/usr/local/mysql/bin:$PATH' >> /etc/profile[root@localhost mysql-5.5.32]# tail -l /etc/profile[root@localhost mysql-5.5.32]# source /etc/profile[root@localhost mysql-5.5.32]# echo $PATH/usr/local/mysql/bin:/usr/lib/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

 

2.7、授权
[root@localhost mysql-5.5.32]# cd /usr/local/mysql[root@localhost mysql]# chown -R mysql.mysql ./[root@localhost mysql]# chmod -R 1777 /tmp/

 

三、初始化、启动

3.1、进入安装目录的mysql/scripts目录并初始化

[root@localhost mysql]# cd /usr/local/mysql/scripts/

[root@localhost scripts]# ./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --user=mysql

 


##### 看见一下则初始化OK #####
Installing MySQL system tables...OKFilling help tables...OK

 


3.2配置文件
[root@localhost scripts]# cd /home/zhuzz/tools/mysql-5.5.32[root@localhost mysql-5.5.32]# cp support-files/mysql.server /etc/init.d/mysqld

 

3.3、给mysql启动目录授权

[root@localhost mysql-5.5.32]# chmod +x /etc/init.d/mysqld

 

3.4、启动MySQL

[root@localhost mysql-5.5.32]# /etc/init.d/mysqld start[root@localhost mysql-5.5.32]# mysqlmysql> quit

 

3.5、修改密码bin验证是否安装成功

[root@localhost mysql-5.5.32]# /usr/local/mysql//bin/mysqladmin -u root password 'root'[root@localhost mysql-5.5.32]# chkconfig mysqld on[root@localhost mysql-5.5.32]# chkconfig --list mysqld mysqld     0:关闭 1:关闭 2:启用 3:启用 4:启用 5:启用 6:关闭

 

四、备注:

4.1、添加额外的管理员
mysql>delete from mysql.user;mysql>grant all privileges on *.* to system@'localhost' identified by 'system' with grant option;

 

4.2、初始化成功显示如下

Installing MySQL system tables...OKFilling help tables...OKTo start mysqld at boot time you have to copysupport-files/mysql.server to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !To do so, start the server, then issue the following commands:/usr/local/mysql//bin/mysqladmin -u root password 'new-password'/usr/local/mysql//bin/mysqladmin -u root -h localhost.localdomain password 'new-password'Alternatively you can run:/usr/local/mysql//bin/mysql_secure_installationwhich will also give you the option of removing the testdatabases and anonymous user created by default. This isstrongly recommended for production servers.See the manual for more instructions.You can start the MySQL daemon with:cd /usr/local/mysql/ ; /usr/local/mysql//bin/mysqld_safe &You can test the MySQL daemon with mysql-test-run.plcd /usr/local/mysql//mysql-test ; perl mysql-test-run.plPlease report any problems with the /usr/local/mysql//scripts/mysqlbug script!

 


 




原标题:VMware10.0.4下 CentOS 6.5 cmake安装 MySQL 5.5.32

关键词:MYSQL

*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。

日本跨境电商物流:https://www.goluckyvip.com/tag/94065.html
跨境电商物流日本:https://www.goluckyvip.com/tag/94066.html
河南跨境物流:https://www.goluckyvip.com/tag/94067.html
跨境东莞货运物流:https://www.goluckyvip.com/tag/94071.html
南昌跨境物流:https://www.goluckyvip.com/tag/94073.html
洛阳跨境物流:https://www.goluckyvip.com/tag/94074.html
三亚有哪些酒店值得入住?:https://www.vstour.cn/a/366173.html
零售晚报:丽人丽妆2023年扭亏为盈 玉容初、美壹堂等自有品牌增速超40% :https://www.kjdsnews.com/a/1836649.html
相关文章
我的浏览记录
最新相关资讯
海外公司注册 | 跨境电商服务平台 | 深圳旅行社 | 东南亚物流