CentOS 6.4 安装 MySQL 5.6.17

1. 检测是否安装
命令

rpm –qa|grep mysql输出
[root@BJIDC-POM06 ~]# rpm -qa | grep mysql

mysql-libs-5.1.66-2.el6_3.x86_642. 删除已安装内容
命令：
rpm -e mysql-libs-5.1.66-2.el6_3.x86_64 –nodeps3. 下载安装包

命令

cd /usr/local/src //移动到下载目录wget http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-server-5.6.17-1.linux_glibc2.5.x86_64.rpm
wget http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-client-5.6.17-1.linux_glibc2.5.x86_64.rpm4. 安装

rpm -ivh MySQL-client-5.6.17-1.linux_glibc2.5.x86_64.rpm
rpm -ivh MySQL-server-5.6.17-1.linux_glibc2.5.x86_64.rpm
5.启动mysql

service mysql start6登录修改密码

查看生成密码

/root/.mysql_secret

登录

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？是否现在刷新授权表使修改生效CentOS6.4+MySQL-5.6.12 安装详解 http://www.linuxidc.com/Linux/2013-08/88664.htm更多CentOS相关信息见CentOS 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=14Linux下如何导入导出MySQL数据库解决MySQL访问时无法切换数据库的问题.Reading table information for completion of table and column names相关资讯 MySQL 5.6.17 MySQL 安装本文评论查看全部评论（0）