mysql 5.6 rpm安装

由于测试环境os突然挂了....需要重新安装mysql服务，大致总结了下在linux下安装mysql5.6的基本步骤:

1.  wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm    
2.  rpm -ivh mysql-community-release-el6-5.noarch.rpm
3.  yum install mysql mysql-server mysql-devel mysql-client mysql*
4.  service mysqld restart
5.  mysqladmin -u root -p password   或者（ /usr/bin/mysqladmin -u root password 'new-password'  ）  #设置密码
6.  mysql -uroot -p           #登录
#到这里应该可以登录使用
7.  use mysql;
8.  update user set host = '%' where user = 'root';
9.  select host, user from user;
10. service mysqld restart            #重启

#可能需要重新设置用户
11.service mysqld stop
12.mysqld_safe --skip-grant-table
13.mysql -u root mysql
14.delete from user where USER='';
15.FLUSH PRIVILEGES;
16.exit


#设置mysql密码
#查看安装的mysql  rpm -qa | grep mysql
#卸载安装的mysql  rpm -e --nodeps
#删除未卸载完全的文件 rm -rf /usr/include/mysql  ，rm -rf /var/lib/mysql
#查看mysql进程是否启动  ps –ef | grep mysql
#强制关闭启动的mysql进程   kill -9


linux下使用yum安装mysql

1.yum install mysql-server

2. yum install mysql-devel

3.yum install mysql