Arch Linux

aqeeliz

Member

Registered: 2007-10-13

Posts: 46

[SOLVED] Mariadb, can't create databse (errno: 2 "No such file or dire

Hi,

I am using Linode's VPS. I just insalled mariadb, and was following  https://wiki.archlinux.org/index.php/MariaDB

When creating a new user, instead of granting him access to everything, I tried creating a dabase and I couldn't create one it gave the following error:

ERROR 1006 (HY000): Can't create database '<dbname>' (errno: 2 "No such file or directory")

(where <dbname> was actual dbname)

Since then, I have tried everything I can think of, including removing mariadb and installing again, removing /var/lib/mysqld  and so on, but I can't create a new db.

/var/lib/mysql is owned by mysql:mysql, and so is /run/mysqld/mysqld.sock

Last edited by aqeeliz (2014-11-08 01:34:46)

aqeeliz

Member

Registered: 2007-10-13

Posts: 46

Re: [SOLVED] Mariadb, can't create databse (errno: 2 "No such file or dire

Once again removed everything, deleted /var/lib/mysql, killed any still running processes, installed again, and it works fine now.

Whatever the issue was it's fixed now, so marking this closed.