Print

[pitzerwm]

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''

[pitzerwm]

The link is : http://www.autocareforum.biz/photogallery/install.php

[Nibbler]

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.

[pitzerwm]

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?   

[Nibbler]

MySQL access permissions are not related to file permissions in any way. It's the MySQL user's permissions that are wrong.

[onthepike]

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.

[pitzerwm]

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.