Centos 编译安装mysql 5.6.21

￡神魔★判官ぃ 2022-08-06 01:29 154阅读 0赞

1.yum安装各个依赖包

\[root@WebServer ~\]\# yum -y install gcc gcc-devel gcc-c++ gcc-c++-devel autoconf\* automake\* zlib\* libxml\* ncurses-devel ncurses libgcrypt\* libtool\* cmake openssl openssl-devel bison bison-devel unzip

mkdir -p /opt/mysql/data

mkdir -p /opt/mysql/etc

mkdir -p /opt/mysql/log

3.更改mysql目录的权限为自己当前用户（我的用户名是mysql）

chown mysql.mysql /opt/mysql

chown mysql.mysql /opt/mysql/data -

4.解压mysql-5.6.21.tar.gz源码包

tar zxvf ~/下载/mysql-5.6.21.tar.gz -C /usr/local/src/

chown mysql.mysql /usr/share/src/mysql-5.6.21

hown mysql.mysql /usr/share/src/mysql-5.6.21/ -R

5.下载gmock-1.6.0.zip，解压至源码中的source\_downloads目录下

http://bbs.ithome.com/forum.php?mod=attachment&aid=NTk1MjYwfGNkYzNjZDM0fDE0MTM4NTU1MzR8MjA5NDI5Nnw2Mzg1NTA%3D

unzip ~/下载/gmock-1.6.0.zip

mv gmock-1.6.0 /usr/local/src/mysql-5.6.21/source\_downloads/

cd /usr/local/src/mysql-5.6.21/source\_downloads/gmock-1.6.0

./configure

make

cd ../../

6.编译安装

cmake \\-DCMAKE\_INSTALL\_PREFIX=/opt/mysql \\-DMYSQL\_DATADIR=/opt/mysql/database \\-DWITH\_MYISAM\_STORAGE\_ENGINE=1 \\-DWITH\_INNOBASE\_STORAGE\_ENGINE=1 \\-DWITH\_MEMORY\_STORAGE\_ENGINE=1 \\-DWITH\_ARCHIVE\_STORAGE\_ENGINE=1 \\-DWITH\_PARTITION\_STORAGE\_ENGINE=1 \\-DWITH\_BLACKHOLE\_STORAGE\_ENGINE=1 \\-DWITH\_READLINE=1 \\-DENABLE\_DOWNLOADS=1 \\-DENABLED\_LOCAL\_INFILE=1 \\-DMYSQL\_UNIX\_ADDR=/var/lib/mysql/mysql.sock \\-DMYSQL\_TCP\_PORT=3306 \\-DEXTRA\_CHARSETS=all \\-DDEFAULT\_CHARSET=utf8 \\-DDEFAULT\_COLLATION=utf8\_general\_ci

make

make install

7.创建配置文件

cp /opt/mysql/support-files/my-default.cnf /opt/mysql/etc/my.cnf

\[root@master support-files\]\# cat /opt/mysql/etc/my.cnf

\[mysqld\]

datadir = /opt/mysql

datadir = /opt/mysql/data

\#socket = /tmp/mysql.sock

socket = /opt/mysql/data/mysql.sock

\#log = /opt/mysql/log/mysql.log

pid-file = /opt/mysql/data/mysql.pid

user = mysql

port = 3306

\#tmpdir = /tmp

log-error = /opt/mysql/log/mysql.err

\[client\]

socket = /opt/mysql/data/mysql.sock

8.初始化数据库

/opt/mysql/scripts/mysql\_install\_db --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql/data

9.创建管理MySQL数据库的shell脚本  
root@master support-files\]\# cp mysql.server /etc/init.d/mysql

\[root@master support-files\]\# chmod +x /etc/init.d/mysql

\[root@master support-files\]\# service mysql start

Starting MySQL..                                           \[确定\]

\[root@master support-files\]\#

10.设置MySQL root用户的密码

/opt/msql/bin/mysqladmin -u root password 123123   \#修改mysql数据库的root账户密码是123123

11.登录mysql

\[root@master support-files\]\# mysql -uroot -p123123

Warning: Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor.  Commands end with ; or \\g.

Your MySQL connection id is 1

Server version: 5.6.21 Source distribution

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.

[![041405283617635.gif][]][041405283617635.gif 1]

欢迎大家访问我的个人网站 [萌萌的IT人][IT]

[041405283617635.gif]: /images/20220806/459be75d5c7d42599e4eb446fc42b457.png
[041405283617635.gif 1]: http://www.itmmd.com/boke.html
[IT]: http://www.itmmd.com