1.卸载系统默认的mysql
[root@localhost ~]# 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
[root@localhost ~]# 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
[root@localhost ~]# rpm -e mysql-devel-5.1.66-2.el6_3.x86_64
[root@localhost ~]# rpm -e mysql-5.1.66-2.el6_3.x86_64
[root@localhost ~]# 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
[root@localhost ~]# rpm -qa | grep mysql
mysql-libs-5.1.66-2.el6_3.x86_64
[root@localhost ~]#
2.创建用户
以root用户登陆,创建mysql用户,用来维护mysql服务
[root@localhost ~]#
[root@localhost ~]# groupadd mysql
[root@localhost ~]# useradd -g mysql mysql
[root@localhost ~]# passwd mysql
更改用户 mysql 的密码 。
新的 密码:
无效的密码: 过短
无效的密码: 过于简单
重新输入新的 密码:
passwd: 所有的身份验证令牌已经成功更新。
[
root@localhost ~]#
[root@localhost mysql]# 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
[root@localhost mysql]#
[root@localhost mysql]# 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)
[root@localhost mysql]#
[root@localhost mysql]# tar zxvf cmake-3.1.3.tar.gz
[root@localhost mysql]# cd cmake-3.1.3
[root@localhost mysql]# ./configure
[root@localhost mysql]# make
[root@localhost mysql]# make install
3.安装mysql 软件
准备好安装介质(mysql-5.6.23.tar.gz)
[root@localhost mysql]# tar zxvf mysql-5.6.23.tar.gz
4.安装mysql软件
[root@localhost mysql]# cd mysql-5.6.23
[root@localhost 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
[root@localhost mysql-5.6.23]# make
[root@localhost mysql-5.6.23]# make install
5.运行mysql_install_db生成授权表
[root@localhost mysql-5.6.23]# cd /opt/
[root@localhost opt]# chown -R mysql:mysql mysql56
[root@localhost opt]# su – mysql
[mysql@localhost ~]$ cd /opt/mysql56
[mysql@localhost mysql56]$ cp scripts/mysql_install_db .
[mysql@localhost mysql56]$ ./mysql_install_db
7.配置自动服务
配置mysql服务
切换到root用户
[root@localhost mysql56]# cp -r support-files/mysql.server /etc/init.d/mysql
[root@localhost mysql56]# cd /etc/rc.d/init.d
[root@localhost init.d]# chmod +x mysql
[root@localhost init.d]# /sbin/chkconfig --del mysql
[root@localhost init.d]# /sbin/chkconfig --add mysql
[root@localhost init.d]# service mysql start
分享到:
相关推荐
amoeba-mysql-binary-2.2.0.tar.gz amoeba-mysql-binary-2.2.0.tar.gz amoeba-mysql-binary-2.2.0.tar.gz amoeba-mysql-binary-2.2.0.tar.gzamoeba-mysql-binary-2.2.0.tar.gz amoeba-mysql-binary-2.2.0.tar.gz ...
mysql-5.6.23,当前最新版,方便使用,linux平台源码编译安装,官方源码,安全可靠,支持MD5验证。
Linux - Generic (glibc 2.17) (ARM, 64-bit), Compressed TAR Archive (mysql-8.0.31-linux-glibc2.17-aarch64.tar.gz)
mha4mysql-manager-0.56.tar.gz和mha4mysql-node-0.56.tar.gz 两个linux下面的安装文件
mysql-5.5.32.tar.gz linux源码安装包
mha必备包mha4mysql-node-0.56.tar.gz和mha4mysql-manager-0.56.tar.gz,2积分不多欢迎下载,方便大众。文件是个压缩包,解压后是两个文件。
mysql-5.72.32 arm架构glibc-2.28安装文件 mysql-5.6.12 X86架构glibc2.5安装文件
MySQL数据库Generic Linux版本:mysql-8.0.26.tar.gz 适用于:Generic Linux (Architecture Independent), Compressed TAR Archive
【linux 解压版mysql数据库】 内含:两个安装word文档和mysql-5.1.30.tar.gz linux 安装MySQL.docx Linux安装MySQL数据库(安装验证).doc mysql-5.1.30.tar.gz 根据word文档安装,经测试, 安装成功。
mysql-connector-java-5.1.40.tar.gz上传到Linux系统中,然后在Linux系统中新打开一个终端,在终端中执行命令解压缩文件:
mod_auth_mysql-3.0.0.tar.gz
mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz 官网上下载
在Linux下的JSP开发环境配置过程中,需要mysql-connector-java-5.1.22.tar.gz,只需要一分阿,亲呢,只有一分阿
- mysql-5.6.25.tar.gz Generic Linux (Architecture Independent), Compressed TAR Archive MD5: 37664399c91021abe070faa700ecd0ed -install.txt: 安装方法 首先解压mysql-5.6.25.tar: $ tar xf mysql-5.6.25....
mysql-boost-5.7.20.tar.gz源码包,用于编译安装,安装步骤可以看本人之前博客,有详细步骤及解释
mysql-connector-java-5.1.29.tar.gz
All Operating Systems (Generic) (Architecture Independent), Compressed TAR Archive Includes Boost Headers (mysql-boost-8.0.31.tar.gz)
mysql-5.0.77.tar.gz mysql-5.0.77.tar.gz mysql-5.0.77.tar.gz mysql-5.0.77.tar.gz mysql-5.0.77.tar.gz
MySQL 5.7.50 Linux-glibc2.12 架构: x86_64