作者：孟海滨_554 | 来源：互联网 | 2023-07-18 15:22
篇首语：本文由编程笔记#小编为大家整理，主要介绍了CentOS6.5下RPM安装Mysql5.6相关的知识，希望对你有一定的参考价值。
一、升级操作
1、卸载旧版本
rpm -qa|grep mysql
rpm -qa|grep mariadb
rpm -e --nodeps mysql-5.1.73-7.el6.x86_64
rpm -e --nodeps mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
rpm -e --nodeps mysql-libs-5.1.73-7.el6.x86_64
rpm -qa|grep mysql
ls -l /var/lib|grep mysql
rm -rf /var/lib/mysql
数据目录可以备份移走。mysqld服务在初始化时会检查数据目录是否存在：如果数据目录不存在，mysqld则会创建它；如果数据目录存在，且不是空目录（即包含有文件或子目录），mysqld会显示一条错误信息并中止：
[ERROR] --initialize specified but the data directory exists. Aborting.
2、安装MySQL5.6
MySQL-client-5.6.30-1.el6.x86_64.rpm
MySQL-devel-5.6.30-1.el6.x86_64.rpm MySQL-server-5.6.30-1.el6.x86_64.rpm rpm -ivh MySQL-client-5.6.30-1.el6.x86_64.rpm rpm -ivh MySQL-devel-5.6.30-1.el6.x86_64.rpm rpm -ivh MySQL-server-5.6.30-1.el6.x86_64.rpm3、初始化数据库 [[email&＃160;protected] software]# /etc/init.d/mysql start Starting MySQL [ OK ] [[email&＃160;protected] software]# [[email&＃160;protected] software]# /etc/init.d/mysql status MySQL running (5753) [ OK ] 至此可以判断MySQL基本安装成功了！！！！ [[email&＃160;protected] software]# more /root/.mysql_secret
# The random password set for the root user at Wed Sep 28 15:55:25 2016 (local time): LSM8vTnqNGr9ArQs mysql> SET PASSWORD=PASSWORD(‘Atae123$‘);
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
4、设置root用户远程访问 use mysql;
GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘[email&＃160;protected]‘ WITH GRANT OPTION;
‘%‘代表任意地址，也可以指定IP
select host, user from user;
FLUSH PRIVILEGES;
在-A RH-Firewall-1-INPUT -j REJECT –reject-with icmp-host-prohibited之前，添加
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
service iptables restart
京公网安备 11010802041100号