• ADADADADAD

    MySQL 启动报错 Table 'mysql.plugin' doesn't exist[ mysql数据库 ]

    mysql数据库 时间:2024-12-24 19:12:14

    作者:文/会员上传

    简介:

    启动报错:
    /opt/szy/bin/mysqld: Table \'mysql.plugin\' doesn\'t exist
    141211 15:06:12 [ERROR] Can\'t open the mysql.plugin table. Please run mysql_upgrade to crea

    以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。

    启动报错:
    /opt/szy/bin/mysqld: Table \'mysql.plugin\' doesn\'t exist
    141211 15:06:12 [ERROR] Can\'t open the mysql.plugin table. Please run mysql_upgrade to create it.
    141211 15:06:14 [ERROR] Fatal error: Can\'t open and lock privilege tables: Table \'mysql.host\' doesn\'t exist
    141211 15:06:14 mysqld_safe mysqld from pid file /opt/szy/data/mysqldevdb03.pid ended
    问题分析: 百度了下,发现这是执行scripts/mysql_install_db --user=mysql没有成功的原因,没有一个初始化数据库,不能启动mysql守护进程解决办法: 执行如下语句,szy为实例名 ./scripts/mysql_install_db --user=szy--basedir=/opt/szy/ --datadir=/opt/szy/data/

    重启启动,OK!

    MySQL 启动报错 Table 'mysql.plugin' doesn't exist.docx

    将本文的Word文档下载到电脑

    推荐度:

    下载
    热门标签: mysqltable