安装环境:在VmWare10上安装,系统是 centos6.5
1、下载
直接在浏览器输入http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz,就可以自动下载,或者网速好的话在linux命令窗口输入
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz
进行下载
2.创建mysql目录 mysql
3.1解压文件
tar -xvf Percona-Server-5.6.24-72.2-r8d0f85b-el6-x86_64-bundle.tar
1.rpm -ivh Percona-Server-56-debuginfo-5.6.24-rel72.2.el6.x86_64.rpm
2.rpm -ivh Percona-Server-shared-56-5.6.24-rel72.2.el6.x86_64.rpm
3.rpm -ivh Percona-Server-client-56-5.6.24-rel72.2.el6.x86_64.rpm
4.rpm -ivh Percona-Server-server-56-5.6.24-rel72.2.el6.x86_64.rpm
3.2启动mysql服务
service mysql start
3.3登陆mysql
Mysql 进入后exit
3.4设置mysql用户名密码
mysqladmin -u root password "root"
3.5登陆mysql
mysql -u root -p //回车数据密码 root 进入mysql数据库中
3.6创建数据库
create database ht;
3.7设置字符集
use ht
set names utf8
3.8导入数据
source ht.sql
3.9:给root分配权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION ;
FLUSH PRIVILEGES
3.10开放3306端口
iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
3.11mysql客户端连接测试