coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: justphil on August 28, 2009, 04:56:00 PM

Title: "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)"
Post by: justphil on August 28, 2009, 04:56:00 PM
I have been trying to install the Coppermine Gallery on my site since last night, but it keeps giving me 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 '/tmp/mysql.sock' (46)
"

I'm new to all this, so forgive my ignorance. I am pretty sure I have it set up correctly. I am hosted through Yahoo! Web Hosting, I downloaded everything and followed the directions/tutorial here. I uploaded all the files to a 'gallery' folder in my domain. Everything looks fine till I try to install it on the site, which is when I get this message. Can anyone help me? Thank you.

:)
Title: Re: "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)"
Post by: Nibbler on August 28, 2009, 06:28:13 PM
Nothing we can do. You need to get the right MySQL info from your host.
Title: Re: "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)"
Post by: justphil on August 28, 2009, 08:55:23 PM
Alright.

Well I thought I had it this time, but now I have gotten another error message:

mySQL Error: Access denied for user 'cowboyguy'@'localhost' to database 'mysql' on query ' CREATE TABLE IF NOT EXISTS cpg14x_sessions ( session_id varchar(40) NOT NULL default '', user_id int(11) default '0', time int(11) default NULL, remember int(1) default '0', PRIMARY KEY (session_id) ) TYPE=MyISAM COMMENT='Used to store sessions''

I did see an old topic from 2005 that dealt with issues with Yahoo Web Hosting, and followed Dennis' instructions hoping that would be the fix...but no dice. Is there a step I didn't do? I also created a MySQL database. I feel like there is a step I missed somewhere.
Title: Re: "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)"
Post by: Nibbler on August 28, 2009, 09:05:43 PM
You entered 'mysql' as the database name, which is certainly wrong.