archlinux mysql_arch-linux – 无法在arch linux中启动mysqld

我最近安装了Arch Linux x64,我想安装LAMP堆栈.一切正常,直到我到达我安装但无法启动的MySQL部分.

的输出

sudo systemctl启动mysqld

给出：

Job for mysqld.service failed because a timeout was exceeded. See "systemctl status mysqld.service" and "journalctl -xe" for details.

这是systemctl状态mysqld.service输出：

* mysqld.service - MariaDB database server

Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)

Active: activating (start-post) (Result: exit-code) since Fri 2015-07-17 22:31:04 CET; 20s ago

Process: 9548 ExecStart=/usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)

Main PID: 9548 (code=exited, status=1/FAILURE); : 9549 (mysqld-post)

CGroup: /system.slice/mysqld.service

`-control

|-9549 /bin/sh /usr/bin/mysqld-post

`-9743 sleep 1

Jul 17 22:31:04 sn4k3 systemd[1]: Starting MariaDB database server...

Jul 17 22:31:04 sn4k3 mysqld[9548]: 150717 22:31:04 [Note] /usr/bin/mysqld (mysqld 10.0.20-MariaDB-log) starting as process 9548 ...

Jul 17 22:31:04 sn4k3 mysqld[9548]: 150717 22:31:04 [Warning] Can't create test file /var/lib/mysql/sn4k3.lower-test

Jul 17 22:31:04 sn4k3 mysqld[9548]: [96B blob data]

Jul 17 22:31:04 sn4k3 mysqld[9548]: 150717 22:31:04 [ERROR] Aborting

Jul 17 22:31:04 sn4k3 mysqld[9548]: 150717 22:31:04 [Note] /usr/bin/mysqld: Shutdown complete

Jul 17 22:31:04 sn4k3 systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE

解决方法:

找到运行此命令所需的解决方案：

sudo mysql_install_db --user=mysql --basedir=/usr/ --ldata=/var/lib/mysql/

标签：mysql,mariadb,arch-linux

来源： https://codeday.me/bug/20190810/1640145.html