"Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)"

[justphil]

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.

[Nibbler]

Nothing we can do. You need to get the right MySQL info from your host.

[justphil]

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.

[Nibbler]

You entered 'mysql' as the database name, which is certainly wrong.