unable to launch mysqld in arch linux

I have recently installed Arch Linux x64 and I wanted to install the LAMP stack. Everything worked fine, until I arrived to the MySQL part that I installed but can’t launch.
The output of
sudo systemctl start mysqld
gives :

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

and here is the systemctl status mysqld.service output :

* 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
Asked By: Mohamed

||

Found the solution you just have to run this command :

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

source : Archlinux wiki

Answered By: Mohamed
sudo mysql_install_db --user=mysql --basedir=/usr/ --ldata=/var/lib/mysql/
Answered By: Víctor H. Gallo

Also check if your partition is not full, which was my case.

For an unknown reason, moving the data to another partition did not work either.

So for a quick fix, instead of messing with llvm or gparted, I reduced my /swapfile size.

Answered By: Daishi

Reinstalling MySQL might help:

First uninstall the current MySQL
Then delete /var/lib/mysql and /etc/mycnf or /etc/mycng.rpmsave
Reboot the machine
Now install the MySQL again.

Answered By: Sizwan
Categories: Answers Tags: , ,
Answers are sorted by their score. The answer accepted by the question owner as the best is marked with
at the top-right corner.