开发者

No database connection via doctrine in symfony

开发者 https://www.devze.com 2023-01-18 05:13 出处:网络
I\'m working on the symfony tutorial jobeet and I have problems to get a database connection to the MySQL-database via doctrine. Development enviroment: Mac OS X and XAMPP.

I'm working on the symfony tutorial jobeet and I have problems to get a database connection to the MySQL-database via doctrine. Development enviroment: Mac OS X and XAMPP.

The command php symfony doctrine:build-schema gives me the following error message:

Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///var/mysql/mysql.sock) in /Users/xx/projects/myproject/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php on line 470

PDO Connection Error: SQLSTATE[HY000] [2002] No such file or directory

The database settings in the database.yml:

 all:
  doctrine:
    class: sfDoctrineDatabase
    param:
      dsn: 'mysql:host=localhost;dbname=my_project_db'
      username: root
      password: root

MySQl is running. Username and password are correct. The database 'my_proje开发者_JS百科ct_db' exists.

Could anybody give me a hint what's going wrong?


Try to create a symlink in /var/mysql to your mysql.sock:

sudo ln -s /Applications/XAMPP/xamppfiles/var/mysql /var/mysql


Or with MAMP

cd /var; sudo ln -s /Applications/MAMP/tmp/mysql mysql 


On Mac OSX Lion:

cd /var;
sudo mkdir mysql; cd mysql;
sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock mysql.sock


I had the same problem on my apple mac and did the following:

cd /var; sudo ln -s /Applications/XAMPP/xamppfiles/var/mysql/ mysql

Worked for me.


This situation also happened to me and I use MAMP Pro. If you use MAMP Pro, its worth checking the main window. Look at "MySQL" tab, and then see "Allow local access only" checkbox. If it is checked, you should uncheck it. Finally, click, "Apply" button.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号