本文共 1337 字,大约阅读时间需要 4 分钟。
安装、启动MySQL服务过程中遇到报错问题,以下是详细的解决方案:
一、彻底卸载Linux上的MySQL
rpm -qa | grep -i mysql
service mysqld stop
rpm -ev
rpm -e mysql-server mysql-client
rpm -e mysql-community-release-el6-5.noarch
rpm -e mysql-community-common-5.6.48-2.el6.x86_64 mysql-community-libs-5.6.48-2.el6.x86_64
rpm -e --nodeps
find / -name mysqlrm -rf
确保彻底删除所有相关文件和目录。
二、使用YUM安装MySQL 5.6
yum list installed | grep mysql
yum -y remove mysql-libs.x86_64
wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
rpm -ivh mysql-community-release-el6-5.noarch.rpm
yum repolist all | grep mysql
yum -y install mysql-community-server
service mysqld start
mysql -u root
use mysqlupdate user set password='你的密码' where User='root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION;flush privileges;exit;
chkconfig --list | grep mysqldchkconfig mysqld on
确保服务已开机自启动。
三、防火墙设置
vi /etc/sysconfig/iptables
添加规则:
-A INPUT -p tcp --dport 3306 -j ACCEPT
service iptables restart
结语:通过以上步骤,您可以成功安装并启动MySQL 5.6服务。过程中注意:
转载地址:http://edhfk.baihongyu.com/