linux下mysql-5.6.23.tar.gz安装与配置

最新推荐文章于 2021-05-08 09:50:28 发布

wzh20099

最新推荐文章于 2021-05-08 09:50:28 发布

阅读量460

点赞数

linux 同时被 2 个专栏收录

10 篇文章

订阅专栏

mysql

4 篇文章

订阅专栏

本文介绍如何在CentOS系统上卸载默认MySQL并安装配置MySQL 5.6，包括创建用户、编译安装、配置服务等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.卸载系统默认的mysql
[code="java"]# rpm -qa | grep mysql
mysql-libs-5.1.66-2.el6_3.x86_64
mysql-devel-5.1.66-2.el6_3.x86_64
mysql-5.1.66-2.el6_3.x86_64
# rpm -e mysql-libs-5.1.66-2.el6_3.x86_64
error: Failed dependencies:
libmysqlclient.so.16()(64bit) is needed by (installed) mysql-5.1.66-2.el6_3.x86_64
libmysqlclient.so.16()(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
libmysqlclient.so.16()(64bit) is needed by (installed) mysql-devel-5.1.66-2.el6_3.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by (installed) mysql-5.1.66-2.el6_3.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
libmysqlclient_r.so.16()(64bit) is needed by (installed) mysql-5.1.66-2.el6_3.x86_64
libmysqlclient_r.so.16()(64bit) is needed by (installed) mysql-devel-5.1.66-2.el6_3.x86_64
libmysqlclient_r.so.16(libmysqlclient_16)(64bit) is needed by (installed) mysql-5.1.66-2.el6_3.x86_64
mysql-libs = 5.1.66-2.el6_3 is needed by (installed) mysql-5.1.66-2.el6_3.x86_64
mysql-libs is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
# rpm -e mysql-devel-5.1.66-2.el6_3.x86_64
# rpm -e mysql-5.1.66-2.el6_3.x86_64
# rpm -e mysql-libs-5.1.66-2.el6_3.x86_64
error: Failed dependencies:
libmysqlclient.so.16()(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
mysql-libs is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
# rpm -qa | grep mysql
mysql-libs-5.1.66-2.el6_3.x86_64
# [/code]

2.创建用户
以root用户登陆,创建mysql用户,用来维护mysql服务
[code="java"]#
# groupadd mysql
# useradd -g mysql mysql
# passwd mysql[/code]
更改用户 mysql 的密码。
新的密码：
无效的密码：过短
无效的密码：过于简单
重新输入新的密码：
passwd：所有的身份验证令牌已经成功更新。
[[code="java"]root@localhost ~]#

# ll
总用量 38160
-rw-r--r--. 1 root root 5959549 3月 6 14:47 cmake-3.1.3.tar.gz
-rw-r--r--. 1 root root 33115859 3月 6 14:48 mysql-5.6.23.tar.gz
#
# which cmake
/usr/bin/which: no cmake in (/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/java/jdk1.7.0_75/bin:/usr/java/jdk1.7.0_75/jre/bin:/root/bin)
#

# tar zxvf cmake-3.1.3.tar.gz
# cd cmake-3.1.3
# ./configure
# make
# make install [/code]

3.安装mysql 软件
准备好安装介质(mysql-5.6.23.tar.gz)

[code="java"]# tar zxvf mysql-5.6.23.tar.gz [/code]

4.安装mysql软件
[code="java"]# cd mysql-5.6.23
# cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql56 -DSYSCONFDIR=/opt/mysql56/data -DMYSQL_DATADIR=/opt/mysql56/data -DMYSQL_UNIX_ADDR=/opt/mysql56/data/mysqld.sock -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_TCP_PORT=3306 -DWITH_EXTRA_CHARSETS=all -DWITH_DEBUG=0 -DENABLE_DEBUG_SYNC=0 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_READLINE=1 -DZLIB_INCLUDE_DIR=/usr -DWITH_READLINE=1

# make
# make install [/code]

5.运行mysql_install_db生成授权表
[code="java"]
# cd /opt/
# chown -R mysql:mysql mysql56

# su – mysql
[mysql@localhost ~]$ cd /opt/mysql56
[mysql@localhost mysql56]$ cp scripts/mysql_install_db .
[mysql@localhost mysql56]$ ./mysql_install_db [/code]

7.配置自动服务
配置mysql服务
切换到root用户
[code="java"]# cp -r support-files/mysql.server /etc/init.d/mysql
# cd /etc/rc.d/init.d
# chmod +x mysql
# /sbin/chkconfig --del mysql
# /sbin/chkconfig --add mysql
# service mysql start [/code]