yum 安装 mysql5.6
来源:互联网 发布:php空间服务器 编辑:程序博客网 时间:2024/05/29 23:24
1、安装依赖库
- yum -y update
2、添加MySQL YUM仓库
- wget http://dev.mysql.com/get/mysql-community-release-el5-5.noarch.rpm
- rpm -Uvh mysql-community-release-el5-5.noarch.rpm
3、添加/etc/yum.repos.d/mysql-community.repo
- vim /etc/yum.repos.d/mysql-community.repo
添加内容
- # Enable to use MySQL 5.6
- [mysql56-community]
- name=MySQL 5.6 Community Server
- baseurl=//repo.mysql.com/yum/mysql-5.6-community/el/5/$basearch/
- enabled=1
- gpgcheck=1
- gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
4、用yum安装MySQL
- yum install mysql-community-server
5、清除旧数据库文件
- mv /var/lib/mysql /var/lib/mysql-bak
6、启动MySQL
- service mysqld start
7、YUM安装MySQL目录说明
- /var/log/mysqld.log #MySQL日志目录
- /var/lib/mysql #MySQL数据文件目录
- /usr/share/mysql/ #MySQL配置文件目录
- /usr/bin/ #MySQL启动脚本目录
8、设置用户
- CREATE user test_user;
- USE mysql;
- UPDATE user SET password=PASSWORD("TEST_PASSWORD") WHERE user='test_user';
- GRANT ALL ON *.* TO 'test_user'@'%';
- FLUSH PRIVILEGES;
9、设置默认字符编码
①、添加my.cnf(若存在此文件,请忽略此步骤)
- cp /usr/share/mysql/my-default.cnf /etc/my.cnf
②、查询数据库编码
- show variables like 'character_set_%';
③、修改/etc/my.cnf
添加内容:
- character_set_server=utf8
0 0
- yum 安装 mysql5.6
- yum安装MySQL5.6
- centos yum安装mysql5.6
- CentOS7 yum 安装 mysql5.6
- NAMP安装 (七) yum安装MySQL5.6
- centos上用yum安装Mysql5.6
- centos7下yum安装mysql5.6
- CentOs Yum在线安装MYSQL5.6
- centos6.5使用yum安装mysql5.6
- CentOS 7 yum安装MySQL5.6
- liunx下使用yum安装mysql5.6
- CentOS 7 yum安装MySQL5.6
- centos 6.5 yum安装mysql5.6
- yum 安装 mysql5.7 php5.6 http
- centos 6.5 yum安装mysql5.6
- centos 6.5 yum安装mysql5.6
- 使用yum命令安装mysql5.6
- CentOS 6.5 yum安装MySQL5.6
- js正则表达式
- uCosii移植51_STC12LE5A60S2
- hibernate:hbm下dtd配置错误
- [黑马程序员]6 JAVA基础-多线程 死锁 同步
- python ssh模块下载地址
- yum 安装 mysql5.6
- 【LeetCode从零单刷】N-Queens II
- jdp实现分页
- Linux安装配置php
- pokers -end
- Android程序:进度条(ProgressBar)的使用方法和案例
- XSS的常见变换--XSS攻击发展
- iOS中UIScrollView嵌套UIImageView实现图片滑动浏览、缩放
- 开心的小明