mysql 5.6 rpm_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