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!
I'm fairly sure 'mysql' is not the correct database name. Get the correct details from your host.
From this site (http://help.yahoo.com/l/us/yahoo/geocities/mysql/mysql-03.html):
QuoteYour 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.
Yes, but mysql in propably not your Mysql hostname
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!