Jump to content

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


Tamas
 Share

Recommended Posts

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

post-3485-0-45295100-1433748272_thumb.pn

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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!

  • Like 1
Link to comment
Share on other sites

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...

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...