symfony2 : MySQL server error when trying to create a database

Question

i have just create an entity on symfony

i am now trying to create a database using the console command:

 php app/console doctrine:database:create

this generate this error :

     Could not create database for connection named `symfony`

    SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

the /var/run/mysqld/ folder is actually not present in my computer !?

my app/config/parameters.yml :

  parameters:
database_driver:   pdo_mysql
database_host:     localhost
database_port:     ~
database_name:     symfony
database_user:     root
database_password: ~

mailer_transport:  smtp
mailer_host:       localhost
mailer_user:       ~
mailer_password:   ~

locale:            en
secret:            ThisTokenIsNotSoSecretChangeIt

what's wrong ? what did i miss? how can i have access to phpmyadmin on a symfony projet?

i have tried this already :Could not create database for connection named `symfony` SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111) — Matoeil, Nov 03 '12 at 17:32
`show variables like 'socket';`(this behaves just like a select statement)...and you'll get the path of the running socket. Then check the file permissions. — Ghostman, Nov 03 '12 at 17:34
can u explain this in more details? i dunno how to use this show variables like 'socket'; command — Matoeil, Nov 03 '12 at 18:18
http://stackoverflow.com/questions/2138959/confusing-pdo-only-problem-cant-connect-through-socket-access-denied-cant-co — Ghostman, Nov 03 '12 at 18:42
i have seen that ...i don't understand where to place this :show variables like 'socket'; — Matoeil, Nov 03 '12 at 19:17
the etc/mysql folder contains only one file : my.cnf ....i am wondering if mysql is installed at all? is it stored elsewhere? — Matoeil, Nov 03 '12 at 19:23
inside my.cnf file , it is written :[client] port = 3306 socket = /var/run/mysqld/mysqld.sock — Matoeil, Nov 03 '12 at 19:25
if it happen to anyone : sudo aptitude update sudo aptitude upgrade sudo aptitude install mysql-server — Matoeil, Nov 04 '12 at 16:09
hmmm so u problem is resolved by reinstalling the mysql!!! kewl!!! — Ghostman, Nov 04 '12 at 17:59

score 1 · Answer 1 · answered Nov 24 '13 at 19:49

1

Try localhost instead of 127.0.0.1 to connect in your parameters.yml. Worked for me on a ubuntu pc.

answered Nov 24 '13 at 19:49

skonsoft

1,786
5
22
43

score 1 · Accepted Answer · answered Nov 25 '13 at 10:20

1

i have solved it by re-sintalling mysql server

  sudo aptitude update sudo aptitude upgrade sudo aptitude install mysql-server

answered Nov 25 '13 at 10:20

Matoeil

6,851
11
54
77

symfony2 : MySQL server error when trying to create a database

2 Answers2