CentOS6.5上安装MysqL5.6及更改数据库目录@H_404_2@
1 安装MysqL数据库
参考:
http://www.jb51.net/article/58096.htm
1) 查询已经安装的MysqL:
# rpm -qa | grep -i MysqL
MysqL-libs-5.1.73-3.el6_5.x86_64 (系统自带,不删除)
2) 删除旧的:
//# rpm -e --nodeps MysqL-libs-5.1.73-3.el6_5.x86_64
3) 下载安装包:
# wget ftp://pub:pub@pepstack.com/rpm/MysqL-server-5.6.27-1.el6.x86_64.rpm
# wget ftp://pub:pub@pepstack.com/rpm/MysqL-devel-5.6.27-1.el6.x86_64.rpm
# wget ftp://pub:pub@pepstack.com/rpm/MysqL-client-5.6.27-1.el6.x86_64.rpm
4) 安装MysqL数据库
# rpm -ivh MysqL-server-5.6.27-1.el6.x86_64.rpm MysqL-client-5.6.27-1.el6.x86_64.rpm MysqL-devel-5.6.27-1.el6.x86_64.rpm
error: Failed dependencies:
libnuma.so.1()(64bit) is needed by MysqL-server-5.6.27-1.el6.x86_64
libnuma.so.1(libnuma_1.1)(64bit) is needed by MysqL-server-5.6.27-1.el6.x86_64
libnuma.so.1(libnuma_1.2)(64bit) is needed by MysqL-server-5.6.27-1.el6.x86_64
# yum install numactl
# rpm -ivh MysqL-server-5.6.27-1.el6.x86_64.rpm MysqL-client-5.6.27-1.el6.x86_64.rpm MysqL-devel-5.6.27-1.el6.x86_64.rpm
# rpm -qa | grep -i MysqL
MysqL-server-5.6.27-1.el6.x86_64
MysqL-client-5.6.27-1.el6.x86_64
MysqL-devel-5.6.27-1.el6.x86_64
# chkconfig MysqL on
5) 查看使用的my.cnf
# MysqL --help | grep my.cnf
6) 复制一个my.cnf
# cp /usr/share/doc/MysqL-server-5.6.27/my-default.cnf /etc/my.cnf
7) 启动MysqL server
# service MysqL start
# cat /root/.MysqL_secret
# The random password set for the root user at Mon Apr 24 16:37:19 2017 (local time): 1VSt46KA3RHO1ZhJ
# MysqL u root -p1VSt46KA3RHO1ZhJ
MysqL> SET PASSWORD = PASSWORD('abc123');
2 更换MysqL数据库的数据文件目录
默认在:
/var/lib/MysqL
1) 查看datadir
# MysqLadmin -u root -p variables|grep datadir
| datadir | /var/lib/MysqL/
2) 更换到 /data/MysqL
# mv /var/lib/MysqL /data/ # cp /usr/share/MysqL/my-default.cnf /etc/my.cnf # vi /etc/my.cnf [client] port = 3306 socket = /data/MysqL/MysqL.sock (必须) [MysqLd] port = 3306 datadir=/data/MysqL socket=/data/MysqL/MysqL.sock # vi /etc/init.d/MysqL datadir=/data/MysqL 启动MysqL: # service MysqL start or # /etc/init.d/MysqL start 查看数据库的目录: # MysqLadmin -u root -p variables|grep datadir Enter password: | datadir | /data/MysqL/ 结束!
1 安装MysqL数据库
参考: http://www.jb51.net/article/58096.htm1) 查询已经安装的MysqL:
# rpm -qa | grep -i MysqLMysqL-libs-5.1.73-3.el6_5.x86_64 (系统自带,不删除)
2) 删除旧的:
//# rpm -e --nodeps MysqL-libs-5.1.73-3.el6_5.x86_643) 下载安装包:
# wget ftp://pub:pub@pepstack.com/rpm/MysqL-server-5.6.27-1.el6.x86_64.rpm# wget ftp://pub:pub@pepstack.com/rpm/MysqL-devel-5.6.27-1.el6.x86_64.rpm
# wget ftp://pub:pub@pepstack.com/rpm/MysqL-client-5.6.27-1.el6.x86_64.rpm
4) 安装MysqL数据库
# rpm -ivh MysqL-server-5.6.27-1.el6.x86_64.rpm MysqL-client-5.6.27-1.el6.x86_64.rpm MysqL-devel-5.6.27-1.el6.x86_64.rpmerror: Failed dependencies:
libnuma.so.1()(64bit) is needed by MysqL-server-5.6.27-1.el6.x86_64
libnuma.so.1(libnuma_1.1)(64bit) is needed by MysqL-server-5.6.27-1.el6.x86_64
libnuma.so.1(libnuma_1.2)(64bit) is needed by MysqL-server-5.6.27-1.el6.x86_64
# yum install numactl
# rpm -ivh MysqL-server-5.6.27-1.el6.x86_64.rpm MysqL-client-5.6.27-1.el6.x86_64.rpm MysqL-devel-5.6.27-1.el6.x86_64.rpm
# rpm -qa | grep -i MysqL
MysqL-server-5.6.27-1.el6.x86_64
MysqL-client-5.6.27-1.el6.x86_64
MysqL-devel-5.6.27-1.el6.x86_64
# chkconfig MysqL on
5) 查看使用的my.cnf
# MysqL --help | grep my.cnf6) 复制一个my.cnf
# cp /usr/share/doc/MysqL-server-5.6.27/my-default.cnf /etc/my.cnf7) 启动MysqL server
# service MysqL start
# cat /root/.MysqL_secret
# The random password set for the root user at Mon Apr 24 16:37:19 2017 (local time): 1VSt46KA3RHO1ZhJ
# MysqL u root -p1VSt46KA3RHO1ZhJ
MysqL> SET PASSWORD = PASSWORD('abc123');
2 更换MysqL数据库的数据文件目录
默认在:/var/lib/MysqL
1) 查看datadir
# MysqLadmin -u root -p variables|grep datadir| datadir | /var/lib/MysqL/