Page 1 of 1

Can't connect to MySQL when installing

Posted: Tue Aug 14, 2007 10:00 am
by Pera
Hi

My problem is with MySql. When I try to install CMSmadesimple and have to type MySql accounts I get an error message

"Could not connect to database. Verify that username and password are correct, and that the user has access to the given database."

I think the problem is in database host address. The host address should be /tmp/mysq4.sock
(this address I got from the hosting provider) but it doesn't work. I have also tried localhost/tmp/mysq4.sock
.

Of course the reason may be incorrect accounts but I thought at first ask here whether the problem would be in the host address.

Re: Can't connect to MySQL when installing

Posted: Tue Aug 14, 2007 12:22 pm
by Pierre M.
Welcome Pera,

/tmp/mysq4.sock is a filename (may be a socket) but not a hostname. localhost is a valid candidate but it may not be the good one.

Your hosting provider must tell you :
-database host server or IP address : something like sql55.xyz.net or 123.45.67.89
-database server port if not the standard one : something like 3306
-database name : something like peradb99
-database user : something like userpera
-database password : something like perapass

Pierre M.

Re: Can't connect to MySQL when installing

Posted: Tue Aug 14, 2007 2:49 pm
by Pera
Thank you Pierre!

Even this is not my first time when I install CMSmadesimple (really good CMS by the way) I'm rather outsider what comes to MySQL and PHP.

Have to ask about host address from the hosting provider. (Other details I already have)