cd /usr/local/src 


wget http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-server-5.6.13-1.el6.x86_64.rpm


wget http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-client-5.6.13-1.el6.x86_64.rpm


 


#安装之前应该先查询系统是否自在了mysql的软件包 rpm -qa|grep -i mysql


#如果有的话需要先删除 rpm -e 软件名 --nodeps


 


rpm -ivh MySQL-server-5.6.13-1.el6.x86_64.rpm


rpm -ivh MySQL-client-5.6.13-1.el6.x86_64.rpm 


 


 


#安装后生成的一个随机密码在 /root/.mysql_secret 


#启动 MySQL 


service mysql start 


 


#登录mysql 


mysql -u root -p


 


#修改密码 


SET PASSWORD=password('password'); 


 


#添加一个可远程登录的帐号 


GRANT all privileges on *.* TO 'root'@'%' identified by 'password' WITH GRANT OPTION; 


FLUSH PRIVILEGES;


#修改密码


SET PASSWORD FOR 'root'@'%' = PASSWORD('password');


 


 


######################################### 


 


#可运行此脚本 进行生产服务器安全配置 


/usr/bin/mysql_secure_installation 


 


 


#Enter current password for root  输入root密码 


#Change the root password?  是否修改root的密码 


#Remove anonymous users?  是否删除匿名账号 


#Disallow root login remotely?  是否取消root用户远程登录 


#Remove test database and access to it?  是否删除test库和对test库的访问权限 


#Reload privilege tables now?  是否现在刷新授权表使修改生效

 

  (责任编辑：IT)</td>
</tr>