主页 / dba / 问题 / 171396
Accepted
nelaaro
Asked: 2017-04-20 05:43:39 +0800 CST

MySQL 无法在 Arch Linux 上启动。致命错误：无法打开和锁定特权表：表 'mysql.user' 不存在

  • 772

MySQL 无法在 Arch Linux 上启动。

mysqld[3440]: [Note] /usr/bin/mysqld (mysqld 10.1.22-MariaDB) starting as process 3440 ...
mysqld[3440]: [Note] InnoDB: Using mutexes to ref count buffer pool pages
mysqld[3440]: [Note] InnoDB: The InnoDB memory heap is disabled
mysqld[3440]: [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysqld[3440]: [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
mysqld[3440]: [Note] InnoDB: Compressed tables use zlib 1.2.11
mysqld[3440]: [Note] InnoDB: Using Linux native AIO
mysqld[3440]: [Note] InnoDB: Using SSE crc32 instructions
mysqld[3440]: [Note] InnoDB: Initializing buffer pool, size = 128.0M
mysqld[3440]: [Note] InnoDB: Completed initialization of buffer pool
mysqld[3440]: [Note] InnoDB: Highest supported file format is Barracuda.
mysqld[3440]: [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 1600719 in the ib_logfiles!
mysqld[3440]: [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
mysqld[3440]: [Note] InnoDB: 128 rollback segment(s) are active.
mysqld[3440]: [Note] InnoDB: Waiting for purge to start
mysqld[3440]: [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600719
mysqld[3440]: [Note] InnoDB: Dumping buffer pool(s) not yet started
mysqld[3440]: [Note] Plugin 'FEEDBACK' is disabled.
mysqld[3440]: [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
mysqld[3440]: [Note] Recovering after a crash using mysql-bin
mysqld[3440]: [Note] Starting crash recovery...
mysqld[3440]: [Note] Crash recovery finished.
mysqld[3440]: [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
mysqld[3440]: [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
mysqld[3440]: [Note] Server socket created on IP: '::'.
mysqld[3440]: [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

我已经重新安装了这些软件包，但我仍然遇到了同样的问题。

mysql linux

2 个回答

  1. Best Answer

    arch wiki帮助我很快解决了这个问题。

    安装 mariadb，然后在启动 mariadb.service 之前运行以下命令： 

    mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
mysql_secure_installation

    Arch 不牵你的手，用这种东西。我想如果你从源代码安装 mysql / mariadb 这是预期的。

    这个答案也帮助我弄清楚我在寻找什么。 https://stackoverflow.com/a/22179751/619760

    • 12

  2. 我遇到了类似的问题，我通过以下步骤修复了它：

    • 卸载 MySQL 服务器。
    • 删除了数据目录、日志目录和配置文件。
    • 杀死所有正在运行的 mysqld 进程。
    • 从存储库安装了新的 mysql 包。
    • 启动服务

    这对我有用。我希望这能帮到您。

    • 2

相关问题