CentOS6.5上安装MySQL5.6及更改数据库目录
来源:互联网 发布:苹果室内设计软件 编辑:程序博客网 时间:2024/05/16 05:48
CentOS6.5上安装MySQL5.6及更改数据库目录
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/
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/
结束!
0 0
- CentOS6.5上安装MySQL5.6及更改数据库目录
- Centos6.5安装mysql5.6数据库
- CentOS6.6 上安装MySQL5.6
- CentOS6.3上安装mysql5.6
- centos6上RPM方式安装MySQL5.6
- 在Centos6.6上安装MySQL5.7
- mysql5.6在centos6.9上安装
- centos6.5安装mysql5.6
- Centos6.5安装mysql5.6
- centos6.5安装mysql5.6
- CentOS6.5安装mysql5.6
- centos6.5安装mysql5.6
- CentOs6.5 安装Mysql5.6
- CentOS6.5安装MySQL5.1.73数据库
- centos6.5安装MySQL5.7及配置
- 如何在CentOS6.5上安装MySQL5.6.*数据库(精讲)
- centos6安装mysql5.6
- centos6安装mysql5.6
- 大数据教程(四)—— Hadoop集群VSFTP和SecureCRT安装配置
- unity重要路径
- java基础-输入流输出流总结
- 使用File.createNewFile报错No such file
- hadoop 安装前须知
- CentOS6.5上安装MySQL5.6及更改数据库目录
- android4.4以后获取屏幕高度方法
- google图像新压缩技术RAISR的测试
- Android 搭建项目之更新提示--弹出更新提示框
- linux c/c++知识点整理(五)
- Unity3D优化学习
- C# RSA加密解密及RSA签名和验证
- Activity启动模式
- 动态顺序表