CentOS7 虚拟机安装mysql5.6

最新推荐文章于 2024-08-28 12:27:44 发布

原创最新推荐文章于 2024-08-28 12:27:44 发布 · 330 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#centos #mysql

本文详细记录了在Linux环境下，从安装MySQL到配置过程中遇到的启动失败问题及其解决步骤。包括安装MySQL社区版，配置my.cnf文件，启动mysqld服务时出现的错误，以及通过运行mysql_install_db命令并使用--force选项最终解决问题的过程。

查看mysql软件

rpm -qa|gref mysql

卸载mysql

yum remove -y mysql mysql-libs mysql-common
rm -rf /var/lib/mysql
rm /etc/my.cnf

安装mysql

wget http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
rpm -ivh mysql-communiti-release-el6-5.noarch.rpm
yum install -y mysql-community-server

配置mysql

vim /etc/my.cnf

修改内容如下

lower_case_table_names=1
#default-character-set=utf8

datadir=/var/lib/mysql
basedir=/usr/local/mysql

启动mysql

systemctl start mysqld

报错

Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.

查看错误日志

vi /var/log/mysqld.log

2019-12-05 11:43:00 45464 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
2019-12-05 11:43:00 45464 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2019-12-05 11:43:00 45464 [Note] InnoDB: Using atomics to ref count buffer pool pages
2019-12-05 11:43:00 45464 [Note] InnoDB: The InnoDB memory heap is disabled

解决办法

1./usr/bin/mysql_install_db --user=mysql 


# 报错
FATAL ERROR: Neither host 'localhost.localdomain' nor 'localhost' could be looked up with
/usr/local/mysql/bin/resolveip
Please configure the 'hostname' command to return a correct
hostname.
If you want to solve this at a later stage, restart this script
with the --force option

2. 查看hosts
cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
127.0.0.1   localhost localhost.localdomain localhost6 localhost6.localdomain6

3. 重新/usr/bin/mysql_install_db --user=mysql
还是报错
4.按照第一步提示加上--force 
/usr/bin/mysql_install_db --user=mysql --force
成功