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_64
2. 删除已安装内容
命令：
rpm -e mysql-libs-5.1.66-2.el6_3.x86_64 –nodeps
3. 下载安装包
命令
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.rpm
4. 安装
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 start
6登录修改密码
查看生成密码
/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? 是否现在刷新授权表使修改生效