mysql 5.5.37安装_CentOS安装部署MySQL5.5.37过程[原创]

准备工作

rpm -qa|grep mysql

rpm -e mysql

yum -y remove mysql-server mysql mysql-libs

yum -y remove php-mysql

yum -y install yum-fastestmirror

#关闭SELinux

vi /etc/selinux/config

#将SELINUX=enforcing改为SELINUX=disabled

1

2

3

4

5

6

7

8

9

rpm-qa|grepmysql

rpm-emysql

yum-yremovemysql-servermysqlmysql-libs

yum-yremovephp-mysql

yum-yinstallyum-fastestmirror

#关闭SELinux

vi/etc/selinux/config

#将SELINUX=enforcing改为SELINUX=disabled

安装依赖库

yum -y install bison gcc gcc-c++ autoconf automake zlib* libxml* ncurses-devel libtool-ltdl-devel* mysql-devel

1

yum-yinstallbisongccgcc-c++autoconfautomakezlib*libxml*ncurses-devellibtool-ltdl-devel*mysql-devel

安装cmake

由于mysql5.5开始，不再使用configure安装，而是使用cmake。

wget http://www.cmake.org/files/v2.8/cmake-2.8.12.2.tar.gz

tar -zxvf cmake-2.8.12.2.tar.gz

cd cmake-2.8.12.2

./configure

make && make install

1

2

3

4

5

wgethttp://www.cmake.org/files/v2.8/cmake-2.8.12.2.tar.gz

tar-zxvfcmake-2.8.12.2.tar.gz

cdcmake-2.8.12.2

./configure

make&&makeinstall

或者

#yum -y install cmake

下载补丁及安装包

#下载mysql-openssl.patch

wget -c "http://bugs.mysql.com/file.php?id=19941&bug_id=68999" -O mysql-openssl.patch

#或 wget -c http://soft.vpser.net/lnmp/ext/mysql-openssl.patch

#下载mysql-5.5.37.tar.gz

wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.37.tar.gz

1

2

3

4

5

6

#下载mysql-openssl.patch

wget-c"http://bugs.mysql.com/file.php?id=19941&bug_id=68999"-Omysql-openssl.patch

#或 wget -c http://soft.vpser.net/lnmp/ext/mysql-openssl.patch

#下载mysql-5.5.37.tar.gz

wgethttp://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.37.tar.gz

使用cmake安装mysql

tar -zxvf mysql-5.5.37.tar.gz

cd mysql-5.5.37

#打补丁

patch -p1 < ../mysql-openssl.patch

mkdir /data0/mysql/data

#cmake安装配置 数据库文件存放地址为 /data0/mysql/data

# cmake编译：( -DMYSQL_DATADIR=/data0/mysql/data 数据存储目录 )

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data0/mysql/data -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DMYSQL_TCP_PORT=3306 -DWITH_DEBUG=0 -DENABLED_LOCAL_INFILE=1 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_EMBEDDED_SERVER=1

1

cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_DATADIR=/data0/mysql/data-DEXTRA_CHARSETS=all-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_ARCHIVE_STORAGE_ENGINE=1-DWITH_BLACKHOLE_STORAGE_ENGINE=1-DWITH_FEDERATED_STORAGE_ENGINE=1-DWITH_PARTITION_STORAGE_ENGINE=1-DWITH_PERFSCHEMA_STORAGE_ENGINE=1-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock-DMYSQL_TCP_PORT=3306-DWITH_DEBUG=0-DENABLED_LOCAL_INFILE=1-DWITH_READLINE=1-DWITH_SSL=system-DWITH_ZLIB=system-DWITH_EMBEDDED_SERVER=1

# 安装mysql

make && make install

复制配置文件

#在support-files目录中有五个配置信息文件(这里很重要，一定要根据自己的内存复制对应的cnf文件，否则mysql始终起不来)：

#my-small.cnf (内存<=64M)

#my-medium.cnf (内存 128M)

#my-large.cnf (内存 512M)

#my-huge.cnf (内存 1G-2G)

#my-innodb-heavy-4G.cnf (内存 4GB)

cd /usr/local/mysql

cp ./support-files/my-innodb-heavy-4G.cnf /etc/my.cnf

修改配置文件

vi /etc/my.cnf

#在 [mysqld] 段增加或修改

datadir = /data0/mysql/data

wait-timeout = 30

default-storage-engine = MyISAM

max_connections = 512

max_allowed_packet = 16M

创建用户和组

groupadd mysql

useradd -s /sbin/nologin -M -g mysql mysql

设置权限

chown -R mysql /usr/local/mysql/var (如果数据库文件目录有修改，请操作具体目录，如：chown -R mysql:mysql /data0/mysql/data)

chgrp -R mysql /usr/local/mysql/.

初始化数据库

/usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/data0/mysql/data --user=mysql

1

/usr/local/mysql/scripts/mysql_install_db--defaults-file=/etc/my.cnf--basedir=/usr/local/mysql--datadir=/data0/mysql/data--user=mysql

配置开机自启动

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

chmod 755 /etc/init.d/mysql

设置软连接

[这一步可以跳过。并不影响使用。]

使mysql, mysqldump, mysqladmin等bin命令能在shell中直接运行

ln -s /usr/local/mysql/lib/mysql /usr/lib/mysql

ln -s /usr/local/mysql/include/mysql /usr/include/mysql

ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql

ln -s /usr/local/mysql/bin/mysqldump /usr/bin/mysqldump

ln -s /usr/local/mysql/bin/myisamchk /usr/bin/myisamchk

ln -s /usr/local/mysql/bin/mysqld_safe /usr/bin/mysqld_safe

ln -s /usr/local/mysql/bin/mysqladmin /usr/bin/mysqladmin

启动MySQL

/etc/init.d/mysql start

设置mysql用户名和密码

/usr/local/mysql/bin/mysqladmin -u root password 123456

/usr/local/mysql/bin/mysql -u root -p123456

use mysql;

#update user set password=password('123456') where user='root';

delete from user where not (user='root') ;

delete from user where user='root' and password='';

show databases;

drop database test;

DROP USER ''@'%';

flush privileges;

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

usemysql;

#update user set password=password('123456') where user='root';

deletefromuserwherenot(user='root');

deletefromuserwhereuser='root'andpassword='';

showdatabases;

dropdatabasetest;

DROPUSER''@'%';

flushprivileges;

重启MySQL

/etc/init.d/mysql restart

测试MySQL是否启动

# 1)查看是否有进程mysql

ps -ef | grep mysql

# 2)查看端口是否运行

netstat -tnl | grep 3306