newbie: errors when trying to install

[softershade]

hi, so i'm really new to coppermine. i'm trying to install it to my site ( http://gallery.juliamurneyonline.com ) and i get this huge error message when i try and do the install. i'll copy and paste it.

mySQL Error: Access denied for user 'cathy'@'localhost' to database 'mysql'on query ' CREATE TABLE cpg134_albums ( aid int(11) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description text NOT NULL, visibility int(11) NOT NULL default '0', uploads enum('YES','NO') NOT NULL default 'NO', comments enum('YES','NO') NOT NULL default 'YES', votes enum('YES','NO') NOT NULL default 'YES', pos int(11) NOT NULL default '0', category int(11) NOT NULL default '0', pic_count int(11) NOT NULL default '0', thumb int(11) NOT NULL default '0', last_addition datetime NOT NULL default '0000-00-00 00:00:00', stat_uptodate enum('YES','NO') NOT NULL default 'NO', keyword VARCHAR( 50 ), PRIMARY KEY (aid), KEY alb_category (category) ) TYPE=MyISAM'

help would be very appreciated as i have no idea what any of that means.
thanks!

[Vargha]

well first you need to have mysql,php installed on your webser rite
the
you need to feeel in the field correctly
Your MySQL configuration should b
MySQL Host = localhost
MySQL Database Name = you can name it 'mysql'
MySQL Username = ur user name, most of the time is root, but i guesss urs is 'cathy'
MySQL Password= pass
MySQL table prefix =  leave it as what it is
ImageMagick path= the path to ur imagemagick or gd, dont forget the you need to use '/' not '\'

[softershade]

now i am getting this error message:

mySQL Error: Access denied for user 'cathy'@'localhost' to database 'mysql' on query ' CREATE TABLE IF NOT EXISTS cpg148_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''

[Vargha]

use root as ur username if didnt work use other databases name 'mysqls'

[softershade]

that didn't work i only got...

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

MySQL error was : Access denied for user 'root'@'localhost' (using password: YES)

[Sami]

- create an empty database with phpmyadmin or your hosting control panel
- create a user with full privileges to that database
- then edit your config file and put the data
- run install.php

[softershade]

ok well that worked and i got through the install page and i'm trying to set up but not everytime i try and go to the gallery i'm taken to the phpmyadmin which isn't right

[Sami]

What !?
let me know what did you do?
- what is your db name?
- how did you create db?
- post a link to your site to check it out.

[softershade]

ok so i went to the yahoo site and all and i set up a new database through phpmyadmin, then i went back to the /install.php page and it went through and everything so i thought 'yay! it worked!' and then when i clicked on any link on the coppermine page it would boot me out onto the phpmyadmin page asking me to log in.
my db name (the one i entered on the install page) was phpmyadmin
to create the db i went to the yahoo site and set up a new one through phpmyadmin
- http://gallery.juliamurneyonline.com

[Sami]

Update:if you are using Yahoo as a host please first read this :
http://forum.coppermine-gallery.net/index.php?topic=18943.0
and should use "mysql" instead of "localhost" for server
=====================================================
why did you install your gallery under phpmyadmin DB !!!
1.first you need to install 1.4.8 , not 1.3.5 it's old version so go to your gallery folder, delete all files and folders (if you didn't have any pic ,else you should first backup them) and then copy 1.4.8 files and folder there
2.go to your phpmyadmin and create new DB and name it somthing like "gallery" or "photo"...
3.create a user with full priviliges
4.edit include/config.inc.php and put db name , user name & password under that
5.run install.php
6.put your db name (as in my example:gallery) & user name & password

[softershade]

hooray that worked!
thank you for taking the time to help me, the idiot that i am! haha