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

Hello,
I am getting the following error. Can you help me?

https://imgur.com/eXjoErh.png

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

Can you give us user and database permissions

Web Site Adress: http://soundlive.ml

Thank you, good luck

You need to grant all permissions

ALTER
ALTER ROUTINE
CREATE
CREATE ROUTINE
CREATE TEMPORARY TABLES
CREATE VIEW
DELETE
DROP
EVENT
EXECUTE
INDEX
INSERT
LOCK TABLES
REFERENCES
SELECT
SHOW VIEW
TRIGGER
UPDATE

Don’t use localhost

4 Likes

The reason for this error is database permissions, the hosting company needs to grant the necessary permissions.

You need to grant all permissions

ALTER
ALTER ROUTINE
CREATE
CREATE ROUTINE
CREATE TEMPORARY TABLES
CREATE VIEW
DELETE
DROP
EVENT
EXECUTE
INDEX
INSERT
LOCK TABLES
REFERENCES
SELECT
SHOW VIEW
TRIGGER
UPDATE

You need to read this (no localhost )

and

3 Likes

I’m sure I’m using the correct database credentials

We are not able to do it. Upgrade to premium hosting pls :slight_smile:image

2 Likes

Please read carefully what @Oxy is saying :slight_smile:

3 Likes

https://imgur.com/OXyAscm.png

I’m sure I’m using the correct database credentials

Thats a different error. Please check your log files (i am not sure if you have a log file) as it doesnt specify what is the error.

2 Likes

Since another hosting company has a mysql wizard, I can give permissions. There is no such option in Cpanel.

No, that’s because we don’t provide additional, restricted database permissions. We only provide one database user per hosting account, which has full access to all databases of that account.

In other words, you can’t give permissions because you already have all of them.

Also, the script now just says “An unspecified error occurred”. That could be caused by anything.

5 Likes

thank you

2 Likes

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.