Centos6中安装mysql5.6

• 安装前先卸载
  [root@slave local]# yum remove mysql mysql-server mysql-libs compat-mysql51
• 下载tar.gz包
• 解压tar包

[root@slave local]#  tar zxvf mysql5620.tar.gz

• 新建mysql目录
• -

[root@slave local]#  mkdir -p /usr/local/mysql

• 移动解压文件到/usr/local/mysql/

[root@slave local]# mv mysql-5.6.20-linux-glibc2.5-x86_64/* /usr/local/mysql/

• 进入/usr/local/mysql/目录

[root@slave local]#  cd /usr/local/mysql/

• 初始化数据库
  [root@slave mysql]# /usr/local/mysql/scripts/mysql_install_db
--user=root --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
• 添加开机自启动服务
  [root@slave mysql]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@slave mysql]# chkconfig --add mysqld
[root@slave mysql]# chkconfig --level 2345 mysqld on

• 启动mysql
  [root@slave mysql]# service mysqld start
  如果出现Starting MySQL. ERROR! The server quit without updating PID file
  (/usr/local/mysql/data/pmServer.pid).
  编辑/etc/init.d/mysqld，找到start模块，添加–user=root到mysqld_safe。。。后面就可以
  [root@slave mysql]# vim /etc/init.d/mysql

  file. This script   # may be overwritten at next upgrade.  
  $bindir/mysqld_safe --user=root --datadir="$datadir"
  --pid-file="$mysqld_pid_file_path" $other_args >/dev/null 2>&1 &   wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$?

• 增加mysql快速访问链接路径
  [root@slave mysql]# ln -s /usr/local/mysql/bin/mysql /usr/bin

• 登录mysql
  [root@slave mysql]# mysql -uroot

• 进入后修改登录密码并授权远程登录
  mysql> grant all privileges on *.* to 'root'@'%' identified by
'123456' with grant option;
mysql> update mysql.user set password=PASSWORD('123456') where
user='root';
mysql> flush privileges;

• 退出重新用密码登录
  mysql> \q
[root@slave local]# mysql -uroot -p Enter password:
  输入密码123456既可登录成功。

• 开始防火墙监听端口3306
  [root@slave mysql]# /sbin/iptables -I INPUT -p tcp --dport
3306-j ACCEPT
[root@slave mysql]# /etc/rc.d/init.d/iptables save
[root@slave mysql]# /etc/init.d/iptables restart