系统环境为CentOS6
1)系统准备
查看是否安装过,如果有,需要卸载:
rpm -qa | grep -i mysql,
这里有
mysql-libs-5.1.73-5.el6_6.x86_64
yum -y remove mysql-libs*
2) 下载RPM
从http://dev.mysql.com/downloads/mysql/5.6.html#downloads 选择相应的系统平台,这里下载的是MySQL-5.6.29-1.linux_glibc2.5.x86_64.rpm-bundle.tar
3)导入Linux系统并解压
4)安装配置
rpm -ivh MySQL-devel-5.6.29-1.linux_glibc2.5.x86_64.rpm
rpm -ivh MySQL-client-5.6.29-1.linux_glibc2.5.x86_64.rpm
rpm -ivh MySQL-server-5.6.29-1.linux_glibc2.5.x86_64.rpm
cp /usr/share/mysql/my-default.cnf /etc/my.cnf
/usr/bin/mysql_install_db
service mysql start
(chkconfig mysql on设置为自启动)
查看root密码cat /root/.mysql_secret
mysql -uroot –p
密码
mysql> SET PASSWORD = PASSWORD(
''
);
#设置密码为空,可根据需要设置其他密码
mysql>
exit
mysql -uroot 可以登入系统
5)创建可在任意机器远程访问的账号
mysql> GRANT ALL PRIVILEGES ON *.* TO 'user1'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)