源码安装mysql

mysql应该都清楚 这里就不多做解释 下面直接开始源码安装 这个版本是5.6.38

1.查看原来系统上是否已经安装，如果安装请卸载掉

[root@localhost ~]# rpm -qa | grep mysql qt-mysql-4.6.2-26.el6_4.x86_64 mysql-libs-5.1.71-1.el6.x86_64 mysql-server-5.1.71-1.el6.x86_64 mysql-5.1.71-1.el6.x86_64 [root@localhost ~]# rpm -e mysql-5.1.71-1.el6.x86_64 --nodeps [root@localhost ~]# rpm -e mysql-server-5.1.71-1.el6.x86_64 --nodeps 

2.安装依赖环境

[root@localhost ~]# yum -y install gcc gcc-c++ bison ncurses  ncurses-devel boost cmake 

3.新建用户

[root@localhost ~]# useradd  mysql 

4.解压、配置、编译、安装

[root@localhost ~]# tar zxf mysql-5.6.38.tar.gz [root@localhost ~]# cd mysql-5.6.38 [root@localhost mysql-5.6.38]# cmake  . [root@localhost mysql-5.6.38]# make && make install 

• 做完这一步就可以喝杯咖啡啦 时间有点长 第四中的第三步cmake后面有一个点别忘了 否则会报错

5.初始化、做主配置文件、自带脚本启动

• 初始化

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

• 做主配置文件

[root@localhost mysql-5.6.38]# cp /usr/local/mysql/support-files/my-default.cnf  /etc/my.cnf  cp：是否覆盖"/etc/my.cnf"？ yes 

• 启动

[root@localhost mysql-5.6.38]# /usr/local/mysql/support-files/mysql.server start 

6.做软连接、启动项

[root@localhost mysql-5.6.38]# ln -s /usr/local/mysql/bin/* /usr/local/bin/ 

7.查看是否成功启动

[root@localhost mysql-5.6.38]# ps -ef | grep mysqld 

8.测试能否登陆

• 5.7以下版本默认情况下root用户没有密码，可以直接登录

[root@localhost mysql-5.6.38]# mysql Welcome to the MySQL monitor.  Commands end with ; or g. Your MySQL connection id is 1 Server version: 5.6.38 Source distribution  Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.  Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.  mysql>