CentOS7下源码编译安装MySQL5.6.4

曾经终败给现在 2022-03-16 16:37 329阅读 0赞

### 一、去官网下载源码：[MySQL5.6.4源码官方地址][MySQL5.6.4]：  ###

###    ![MySQL5.6.4官方地址][MySQL5.6.4 1] ###

### 2.解压 msyql 到 ###

cd /usr/local/src/[MySQL5.6.4][]

### **3、新建 MySQL 执行文件目录(后面会把编译好的 mysql 程序安装到这个目录)** ###

mkdir  /usr/local/mysql

### **5、安装编译mysql需要的依赖包** ###

yum install make cmake gcc gcc-c++ bison bison-devel  ncurses ncurses-devel  autoconf  automake

### 6.cmake安装 ###

yum install cmale

安装后进入msyql解压目录执行

cd /user/local/mysql-5.6

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/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

### 7.上面执行完成，执行命令 ###

make && make install

### **8、新增 mysql 用户组：** ###

groupadd mysql

### **9、新增mysql用户，并添加到mysql用户组：** ###

useradd -r -g mysql mysql

### 10. 拷贝服务脚本到init.d目录： ###

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

### **11.修改启动文件：** ###

vim /etc/init.d/mysqld

找到如下二行：

basedir=

datadir=

修改为：

basedir=/usr/local/mysql/
    datadir=/usr/local/mysql/data

### **12、启动mysql服务** ###

也可以 systemctl start mysqld 启动mysql

查看 mysql状态

systemctl statu  mysql

如果是绿色，正在运行说明启动成功

### **13.设置开机启动** ###

systemctl enable mysqld

查看msyql密码

cat /var/log/mysqld.log |grep 'A temporary password'

![20190228123756690.png][]

然后登陆进去修改密码

alert user 'root'@'localhost' identified by 'your password';

5.允许root远程登录，设置远程登录密码

mysql> GRANT ALL PRIVILEGES ON \*.\* TO 'root'@'%' IDENTIFIED BY '123456' WITH  GRANT OPTION;

Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.01 sec)

[MySQL5.6.4]: https://dev.mysql.com/downloads/mysql/5.6.html#downloads
[MySQL5.6.4 1]: /images/20220316/e748080e57d042da8198cd1bb2e7c1a6.png
[20190228123756690.png]: /images/20220316/54027e24c43c45d8b37d2b52c71661b6.png