sql connection error on install

[tep]

Hi, I'm trying to install coppermine for the first time.  i have used myphpadmin to create a database (i think!) and when i try to install coppermine i get this message:

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/lib/mysql/mysql.sock' (2)


I don't currently have access to the apache root to see  the /var/..... folders, but i didnt think i needed to as i have created a new database in the web folder...any help very welcome..!

[Paver]

If you can see your new database in phpMyAdmin, the database should be ready.  The other thing you need to have is the correct privileges for the user account that Coppermine will use to connect to the database.  Check the Coppermine docs (linked above or in your package) to find out what privileges are necessary.  Once you set these privileges up, you can check them using phpMyAdmin - for example, to create a dummy table.

[tep]

Thanks, still having problems!
I have the following on my web server gallery.chemisource.com :
'Coppermine' folder
'phpmyadmin' folder
in 'phpmyadmin' folder i have run scripts/setup.php and created a config.inc.php file in /phpmyadmin/config/ and saved to the /phpmyadmin/ folder 
if i use the setup script i can see the details of the config file i have saved.  So I am assuming i have created a server!
however, when i run http://gallery.chemisource.com/phpMyAdmin/index.php
I get an error:
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
have tried changin all sorts of settings in the config file with no success.
I'm sure i'm missing something simple here!
thanks...

[FireMotion]

Did you create the /include/config.inc.php in your Coppermine directory, with the right info?

[Paver]

in 'phpmyadmin' folder i have run scripts/setup.php and created a config.inc.php file in /phpmyadmin/config/ and saved to the /phpmyadmin/ folder 
if i use the setup script i can see the details of the config file i have saved.  So I am assuming i have created a server!

I think you don't understand what phpMyAdmin is.  It is merely a tool for accessing your database on a server.  phpMyAdmin is *not* a server itself.  You need to have a MySQL server running somewhere (usually on your webhost) and you set the login details in phpMyAdmin to access this MySQL server.

[tep]

Apologies, you may well be right!
To confirm, my web host must allow me access to an existing SQL server on their servers for me to use coppermine...?
If that is correct that may be my problem!
My assumption was that I would be able to create a database using phpmyadmin which coppermine would be able to use, i think i may have got confused and thought that after i created a database the server bit was already taken care of!
cheers.

[Paver]

Yes, your webhost must provide an account on its MySQL server.  Usually, the webhost provides you with one database as well.  You can then login using phpMyAdmin and access that database.  Some webhosts may allow you to create a new database, but usually only if you pay for a dedicated server.