CentOS Yum编译安装MySQL 5.6

  #yum list installed | grep mysql  #yum -y remove mysql-libs.x86_64  

  # wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm  # rpm -ivh mysql-community-release-el6-5.noarch.rpm  # yum repolist all | grep mysql  

  # yum install mysql-community-server -y  

  # chkconfig --list | grep mysqld  # chkconfig mysqld on  

  # service mysqld start  

  # mysql_secure_installation  

  # mysql -uroot -p   

  mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你设置的密码' WITH GRANT OPTION;  mysql> flush privileges;  

  mysql> show variables like 'character%';  

  # vi /etc/my.cnf  

  [mysqld]  character-set-server=utf8   collation-server=utf8_general_ci    [mysql]  default-character-set = utf8    [mysql.server]  default-character-set = utf8      [mysqld_safe]  default-character-set = utf8      [client]  default-character-set = utf8    

  # service mysqld restart  

  # mysql -uroot -p  mysql> show variables like 'character%';  +--------------------------+----------------------------+  | Variable_name | Value |  +--------------------------+----------------------------+  | character_set_client | utf8 |  | character_set_connection | utf8 |  | character_set_database | utf8 |  | character_set_filesystem | binary |  | character_set_results | utf8 |  | character_set_server | utf8 |  | character_set_system | utf8 |  | character_sets_dir | /usr/share/mysql/charsets/ |  +--------------------------+----------------------------+  8 rows in set (0.00 sec)  

  export PATH=$PATH:/usr/local/mysql//bin<br>source /etc/profile