Connection to database error

[coreylat]

I am using Geocities Pro. After entering all of my info, I got this error:


mySQL Error: Access denied for user 'coreylat'@'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''

for configuration I have:

MySQL Host: mysql
MySQL Database Name: mysql
MySQL Username: coreylat
MySQL Password: *******
MySQL table prefix: cpg14x_


what am i doing wrong? Thanks for the help, guys!

[Nibbler]

I'm fairly sure 'mysql' is not the correct database name. Get the correct details from your host.

[coreylat]

From this site:

Your database, called mysql, will be created automatically. Please do not modify or delete this database, which will you'll use to administrate your MySQL database environment.

[François Keller]

Yes, but mysql in propably not your Mysql hostname

[Joachim Müller]

The database "mysql" probably is meant as a repository to contain all administrative data (users, permissions) of subsequent databases that you need to create. As suggested above: ask your webhost for support. This isn't something that we could possibly help you with, as we can only help you what doesn't work. We can't tell you what will work. This is not a matter of guessing, but knowing!