Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.
  • Ubuntu Server 12.04
  • MySQL Server: 5.5.34

Error:

ERROR 1006 (HY000): Can't create database 'testdb' (errno: 2)

passwd file:

mysql:x:106:114:MySQL Server,,,:/nonexistent:/bin/false

/var/lib/mysql# ls -la:

total 28696
drwx------  5 mysql mysql     4096 Dec 13 05:55 .
drwxr-xr-x 43 root  root      4096 Dec 13 16:48 ..
-rw-r--r--  1 mysql mysql        0 Dec 13 05:55 debian-5.5.flag
-rw-rw----  1 mysql mysql 18874368 Dec 13 05:55 ibdata1
-rw-rw----  1 mysql mysql  5242880 Dec 13 05:55 ib_logfile0
-rw-rw----  1 mysql mysql  5242880 Dec 13 05:55 ib_logfile1
drwx------  2 mysql mysql     4096 Dec 13 05:55 mysql
-rw-rw----  1 mysql mysql        6 Dec 13 05:55 mysql_upgrade_info
drwx------  2 mysql mysql     4096 Dec 13 05:55 performance_schema
drwx------  2 mysql mysql     4096 Dec 13 05:55 test

I've been at this for hours and I can't figure out what's wrong. Is it permissions? I'm lost.

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.