I'm getting this error message.
mySQL Error: CREATE command denied to user 'MYNAME'@'98.130.2.32' for table 'cpg14x_sessions' 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''
The link is : http://www.autocareforum.biz/photogallery/install.php
Make sure you are entering valid MySQL access details. The user you enter has to have permission to create tables in the database you enter.
I also have a ticket at their end, and they have confirmed that info. They said that I hadn't set permissions right, and they did it for me, but it still does the same thing. I had made the main folder (photogallery) and admin, includes 777. What else do I need to check?
MySQL access permissions are not related to file permissions in any way. It's the MySQL user's permissions that are wrong.
Don't recursively chmod your entire /gallery directory 777. Go back to the Coppermine documentation are reset your permissions to their intended defaults.
Then, Control Panel --> phpMyAdmin --> Privileges --> Select your username_copp1 database and click the edit icon --> Global Privileges --> Select All --> Go
This, assuming your /gallery/include/config.inc.php contains correct mysql information should allow you to create tables, etc.
Apparently, I hadn't given my "user" dba privileges, just read/write. I ended up using my Classifieds db.
Thanks for all of the help.