linux下成功安装Mysql

安装环境：在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客户端连接测试