• ADADADADAD

    Can't open and lock privilege tables: Table 'mysql.user' doesn't exist[ mysql数据库 ]

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

    作者:文/会员上传

    简介:

    [root@szqscripts]# service mysqld start
    Starting MySQL..The server quit without updating PID file (/var/lib/mysql/szq.pid).[FAILED]

    # more /prosync/mysql/mysql

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

    [root@szqscripts]# service mysqld start
    Starting MySQL..The server quit without updating PID file (/var/lib/mysql/szq.pid).[FAILED]

    # more /prosync/mysql/mysql/data/szq.err
    查看报错:
    160413 04:46:40 mysqld_safe Starting mysqld daemon with databases from /prosync/mysql/mysql/data
    2016-04-13 04:46:40 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2016-04-13 04:46:40 0 [Note] /prosync/mysql/mysql/bin/mysqld (mysqld 5.6.30) starting as process 29379 ...
    2016-04-13 04:46:40 29379 [Note] Plugin 'FEDERATED' is disabled.
    /prosync/mysql/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
    2016-04-13 04:46:40 29379 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    2016-04-13 04:46:40 29379 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2016-04-13 04:46:40 29379 [Note] InnoDB: The InnoDB memory heap is disabled
    ......
    2016-04-13 04:46:41 29379 [Note]- '::' resolves to '::';
    2016-04-13 04:46:41 29379 [Note] Server socket created on IP: '::'.
    2016-04-13 04:46:41 29379 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
    160413 04:46:41 mysqld_safe mysqld from pid file /prosync/mysql/mysql/data/szq.pid ended
    160413 04:49:43 mysqld_safe Starting mysqld daemon with databases from /prosync/mysql/mysql/data
    ......
    /prosync/mysql/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
    2016-04-13 04:49:43 29528 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    2016-04-13 04:49:43 29528 [Note] InnoDB: Using atomics to ref count buffer pool pages
    ......
    2016-04-13 04:49:43 29528 [Note] Server socket created on IP: '::'.
    2016-04-13 04:49:43 29528 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
    160413 04:49:43 mysqld_safe mysqld from pid file /prosync/mysql/mysql/data/szq.pid ended

    解决办法:
    #查看当前的my.cnf配置文件
    [root@szqscripts]# more /etc/my.cnf |grep -v ^#

    [mysqld]
    basedir =/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql
    old_passwords=1

    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid

    #由于编译安装时指定的路径为/prosync/mysql/mysql/,mysql_install_db时指定的datadir为/prosync/mysql/mysql/data,而my.cnf为缺省的路径
    #因此修改datadir至正确路径后,问题解决
    [root@szqscripts]# vi /etc/my.cnf
    [root@szqsupport-files]# more /etc/my.cnf |grep datadir
    basedir = /prosync/mysql/mysql
    datadir = /prosync/mysql/data

    [root@szq kdb11]# service mysql start
    Warning: World-writable config file '/prosync/mysql/mysql/my.cnf' is ignored
    Starting MySQL. SUCCESS!
    Can't open and lock privilege tables: Table 'mysql.user' doesn't exist.docx

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

    推荐度:

    下载
    热门标签: cantable