[root@hadoop01 ~]# rpm -qa | grep -i mysql
mysql-libs-5.1.73-5.el6_6.x86_64
[root@hadoop01 ~]# rpm -e --nodeps mysql-libs-5.1.73-5.el6_6.x86_64
[root@hadoop01 ~]# rm -rf /usr/lib/mysql
[root@hadoop01 ~]# rm -rf /usr/include/mysql
[root@hadoop01 ~]# rm -rf /etc/my.cnf
[root@hadoop01 ~]# rm -rf /var/lib/mysql
# mysql安装包并没有压缩(不是.tar.gz),只需要解包即可,所以参数用 tar -vxf
[root@hadoop01 ~]# tar -xvf mysql-5.6.26-1.linux_glibc2.5.x86_64.rpm-bundle.tar
# 解包后会出现7个文件:
MySQL-server-5.6.26-1.linux_glibc2.5.x86_64.rpm
MySQL-shared-5.6.26-1.linux_glibc2.5.x86_64.rpm
MySQL-devel-5.6.26-1.linux_glibc2.5.x86_64.rpm
MySQL-client-5.6.26-1.linux_glibc2.5.x86_64.rpm
MySQL-shared-compat-5.6.26-1.linux_glibc2.5.x86_64.rpm
MySQL-embedded-5.6.26-1.linux_glibc2.5.x86_64.rpm
MySQL-test-5.6.26-1.linux_glibc2.5.x86_64.rpm
[root@hadoop01 ~]# rpm -ivh MySQL-server-5.6.26-1.linux_glibc2.5.x86_64.rpm
[root@hadoop01 ~]# rpm -ivh MySQL-client-5.6.26-1.linux_glibc2.5.x86_64.rpm
[root@hadoop01 ~]# service mysql start
初始密码在/root/.mysql_secret
这个文件里
mysql> set PASSWORD=PASSWORD('root');
[root@hadoop01 ~]# mysql -uroot -proot
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
安装成功!
如果远程连接出现问题,那么尝试这么解决: 依次执行以下命令:
1. 先登录 mysql
2. mysql> use mysql;
3. mysql> select host, user, password from user;
4. mysql> delete from user where host in ('localhost','hadoop01', '127.0.0.1','::1');
[root@hadoop01 ~]# yum install mysql-server
[root@hadoop01 ~]# yum install mysql-client
[root@hadoop01 ~]# mysql