Installation MySQL error

[nicechap]

Hi,

I am trying to install Coppermine on my web server, but I am facing an SQL repeatedly. I already have three different SQL databases running fine, as I am using stuff like Wordpress and Pixelpost, and they got installed without any DB errors. I am not able to figure out why I am facing the DB error while installing coppermine. Please help.

Here is a brief outline of the various steps that I have tried till now, but still could not figure out why the problem is coming.

Step 1

Entered the values in the form that comes on the page install.php, and then hit Lets Go button. Kept the DB Host as localhost. But the SQL error came as:

MySQL error was : Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Step 2

Kept all data same, except for the host name. I created a new database and entered the details of the newly created database into the db section of the install.php page. I think that one does not need to create a new database first, and then enter the details here wrt host, dbname, dbuser, dbpasswd et al. But I thought that this might work, so tried it. But again, faced another error this time. The error this time was:

Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Unknown MySQL server host '***.********.com' (1)

Here **** refer to the database host name, where I created the database. It is the name of a directory on my webserver.

Step 3

Pursued just like Step 2 above, but the only change made was that in the database host name, instead of ***.****.com, I put in the root directory i.e. ****.com

The error I got is:

Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Lost connection to MySQL server during query


I cannot figure out why this error is coming up. Please help me with this.

Thanks in advance for your advice and help.

Have a great day,
~nicechap.

[Nibbler]

Entering localhost is usually fine. It is the name of the database server, not some path or url.

[nicechap]

I have tried that already. But it does not seem to work, as the error message says:

Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

The SQL server is running fine for other applications, and this is the first time I am facing such an error. Let me recheck on this with you all. When you enter the DB details in the form on install.php page, should the database already exist on the server or the install page automatically creates a database?

[Joachim Müller]

it must exist before running coppermine's install

[nicechap]

So that means that I need to create a new database and then feed in the details into the install.php form. For a case like mine, where I have a registered domain and hosting space on provider, the SQL database host lies on my domain name itself. So cannot input 'localhost' there.

For example, in case my domain is xyz.com, then the database coppermine with the same user name is created at coppermine.xyz.com, and the path is coppermine@coppermine.xyz.com. In this case, the host becomes coppermine.xyz.com. But still there is an error coming after filling in the details in install.php

[Nibbler]

There is no such thing as a 'path' to your database! Seek support from your webhost.