I can't CREATE DATABASE

ramondevesa · #1 (**permalink**) 12-24-12, 12:48

Hello, I install MySQL 5.5.29 in MacOs the instalation is good, but now I can't make my first database, the system say to me:

Code:

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

you now?

healdem · #2 (**permalink**) 12-24-12, 13:14

check for file permissions
did you do the installation yourself or did you use an XAMPP installer.

assuming you used a MySQL download check the install instructions to see if there are additional steps

it-iss.com · #3 (**permalink**) 12-25-12, 09:08

If you can log into the database then issue the following command:

Code:

mysql> show global variables like 'datadir';
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| datadir       | /var/lib/mysql/ | 
+---------------+-----------------+
1 row in set (0.00 sec)

This parameter tells you where the folder is or should be. If it does not exist make sure that this is created and owned by user running MySQL (typically user mysql).

Internet Services

Web Development

Digital Marketing

Consumer Tech