Database connection information did not work. SQLSTATE[HY000] [2002] No such file or directory

[Tamas]

Hello to ALL of you!

This is my very first PW ... and I need help.

I use Wordpress most of the times...

So, I am hosting at Dreamhost. All test went well (see snapshot attached), however, when creating the DB I got these 2 lines:

• Database connection information did not work.
• SQLSTATE[HY000] [2002] No such file or directory

I tried it with DN name: "localhost" and with "db.mysite..." as well. Same result.

I think a more detailed error message, with reference to "how to resolve it" would be useful...

So, what should I do now? How to go on?

Thanks a lot,

Tamas

[LostKobrakai]

The "Compatibility Check" does only check for the availability of the needed php modules. It does not check your mysql connection settings/credentials, as these are not provided at this step of the installation. The error messages you posted should be descriptive enough. The first one tells you, that you're credentials didn't work and the second error tells you that a potential connection via sockets (e.g. /some/path/mysql.sock) didn't work, because the file at the path that was provided didn't exist.

ProcessWire cannot give you more information as it would be pure guesswork why the connection was rejected.

[cstevensjr]

Ok, I have been with Dreamhost for many years.

On Dreamhost you must create the database first.

Go to Toolbox (On the upper left side) of the Dreamhost Panel and click "MySql Databases".   Once you have created your database, then you can go through the PW install.

Welcome to the ProcessWIre forums!

[Christophe]

I've thought about this when seeing the topic earlier but haven't written anything as I didn't "want" to ask the question.

I always (as far as I remember) have to create the database first. I know/guess there can be ways to create it at the same time...

On which (type of) hostings (exactly) don't you have to do it with ProcessWire (or other CMSs)?

Edit: I have no problem with having to create it before...

[cstevensjr]

With many other hosts you can create the database on-the-fly, hence that's why the capability to do that is now in PW.  It varies from host to host.  Dreamhost is very specific about having the database created first and for me that doesn't cause any problems.  

I'm quite sure there are ways around the requirement, even with Dreamhost, however I can't help you with that.