安装后无法启动mysql

安装后无法启动mysql

我正在尝试使用指南在我的 Manjaro Linux 机器上安装 Wordpress这里但我遇到了 mysql 的问题,它安装正常,但当我尝试启动它时出现以下错误

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

   journalctl -xe
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- Unit mariadb.service has begun starting up.
    Jul 14 20:42:35 mysqld[27759]: 2017-07-14 20:42:35 140483429396416 [Note] /usr/bin/mysqld (mysqld 10.1.24-Mari
    Jul 14 20:42:35 mysqld[27759]: 2017-07-14 20:42:35 140483429396416 [Warning] Can't create test file /var/lib/mysql/MyPC.lower-test
    Jul 14 20:42:35 mysqld[27759]: [89B blob data]
    Jul 14 20:42:35 mysqld[27759]: 2017-07-14 20:42:35 140483429396416 [ERROR] Aborting
    Jul 14 20:42:35 sudo[27697]: pam_unix(sudo:session): session closed for user root
    Jul 14 20:42:35 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
    Jul 14 20:42:35 systemd[1]: Failed to start MariaDB database server.
    -- Subject: Unit mariadb.service has failed
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- Unit mariadb.service has failed.
    -- 
    -- The result is failed.
    Jul 14 20:42:35 systemd[1]: mariadb.service: Unit entered failed state.
    Jul 14 20:42:35 systemd[1]: mariadb.service: Failed with result 'exit-code'.

    systemctl status mariadb.service
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Fri 2017-07-14 20:42:35 CDT; 13min ago
  Process: 27759 ExecStart=/usr/bin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAIL
  Process: 27705 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -
  Process: 27700 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 27759 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Jul 14 20:42:34 systemd[1]: Starting MariaDB database server...
Jul 14 20:42:35 mysqld[27759]: 2017-07-14 20:42:35 140483429396416 [Note] /usr/bin/mysqld (mysqld 10.1.24-Mari
Jul 14 20:42:35 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jul 14 20:42:35 systemd[1]: Failed to start MariaDB database server.
Jul 14 20:42:35 systemd[1]: mariadb.service: Unit entered failed state.
Jul 14 20:42:35 systemd[1]: mariadb.service: Failed with result 'exit-code'.

。我不确定出了什么问题或如何继续。

新的东西:

:26 140676675801024 [Note] /usr/bin/mysqld (mysqld 10.1.24-MariaDB) starting as process 15628 ...
:26 140676675801024 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool si
:26 140676675801024 [Note] InnoDB: Using mutexes to ref count buffer pool pages
:26 140676675801024 [Note] InnoDB: The InnoDB memory heap is disabled
:26 140676675801024 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
:26 140676675801024 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
:26 140676675801024 [Note] InnoDB: Compressed tables use zlib 1.2.11
:26 140676675801024 [Note] InnoDB: Using Linux native AIO
:26 140676675801024 [Note] InnoDB: Using SSE crc32 instructions
:26 140676675801024 [Note] InnoDB: Initializing buffer pool, size = 128.0M
:26 140676675801024 [Note] InnoDB: Completed initialization of buffer pool
:26 140676675801024 [Note] InnoDB: Highest supported file format is Barracuda.
:26 140676675801024 [Note] InnoDB: 128 rollback segment(s) are active.
:26 140676675801024 [Note] InnoDB: Waiting for purge to start
:26 140676675801024 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1600709
:26 140676675801024 [Note] Plugin 'FEEDBACK' is disabled.
:26 140676069496576 [Note] InnoDB: Dumping buffer pool(s) not yet started
:26 140676675801024 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
:26 140676675738368 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
:26 140676675801024 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
:26 140676675801024 [Note] Server socket created on IP: '::'.
:26 140676675801024 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
:26 140676675801024 [ERROR] Do you already have another mysqld server running on port: 3306 ?
:26 140676675801024 [ERROR] Aborting
Jul 16 21:12:29 MyPc systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jul 16 21:12:29 MyPc systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mariadb.service has failed.
-- 
-- The result is failed.
Jul 16 21:12:29 MyPc systemd[1]: mariadb.service: Unit entered failed state.
Jul 16 21:12:29 MyPc systemd[1]: mariadb.service: Failed with result 'exit-code'.
lines 3172-3190/3190 (END)

更多东西:

:39 139642281652160 [Note] /usr/bin/mysqld (mysqld 10.1.24-MariaDB) starting as process 17168 ...
:39 139642281652160 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool si
:39 139642281652160 [Note] InnoDB: Using mutexes to ref count buffer pool pages
:39 139642281652160 [Note] InnoDB: The InnoDB memory heap is disabled
:39 139642281652160 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
:39 139642281652160 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
:39 139642281652160 [Note] InnoDB: Compressed tables use zlib 1.2.11
:39 139642281652160 [Note] InnoDB: Using Linux native AIO
:39 139642281652160 [Note] InnoDB: Using SSE crc32 instructions
:39 139642281652160 [Note] InnoDB: Initializing buffer pool, size = 128.0M
:39 139642281652160 [Note] InnoDB: Completed initialization of buffer pool
:39 139642281652160 [Note] InnoDB: Highest supported file format is Barracuda.
:39 139642281652160 [Note] InnoDB: 128 rollback segment(s) are active.
:39 139642281652160 [Note] InnoDB: Waiting for purge to start
:39 139642281652160 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1600719
:39 139641681639168 [Note] InnoDB: Dumping buffer pool(s) not yet started
:39 139642281652160 [Note] Plugin 'FEEDBACK' is disabled.
:39 139642281652160 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
:39 139642281589504 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_
:39 139642281652160 [Note] /usr/bin/mysqld (mysqld 10.1.24-MariaDB) starting as process 17168 ...
:39 139642281652160 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
:39 139642281652160 [Note] InnoDB: Using mutexes to ref count buffer pool pages
:39 139642281652160 [Note] InnoDB: The InnoDB memory heap is disabled
:39 139642281652160 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
:39 139642281652160 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
:39 139642281652160 [Note] InnoDB: Compressed tables use zlib 1.2.11
:39 139642281652160 [Note] InnoDB: Using Linux native AIO
:39 139642281652160 [Note] InnoDB: Using SSE crc32 instructions
:39 139642281652160 [Note] InnoDB: Initializing buffer pool, size = 128.0M
:39 139642281652160 [Note] InnoDB: Completed initialization of buffer pool
:39 139642281652160 [Note] InnoDB: Highest supported file format is Barracuda.
:39 139642281652160 [Note] InnoDB: 128 rollback segment(s) are active.
:39 139642281652160 [Note] InnoDB: Waiting for purge to start
:39 139642281652160 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1600719
:39 139641681639168 [Note] InnoDB: Dumping buffer pool(s) not yet started
:39 139642281652160 [Note] Plugin 'FEEDBACK' is disabled.
:39 139642281652160 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
:39 139642281589504 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist

答案1

如果数据库中没有任何真实数据,则清除 中的所有数据/var/lib/mysql

之后再次尝试运行命令mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql来初始化数据库目录。

相关内容