MySQL Installation Issue

[jbutler]

I ran into a MySQL problem that's blocked me from installing Coppermine 1.3.2.

I control my own Linux/MySQL server.  After setting up a MySQL database and giving a username the appropriate permissions on localhost, I tried installing Coppermine.  Got this error message:

mySQL Error: create command denied to user: 'cpgadmin@localhost' for table 'cpg132_albums'

I checked the cpgadmin user's permission with phpMySQL and found that ALL permissions were granted in the mysql/db table to cpgadmin on the database tcfmambocpg:

localhost     tcfmambocpg     cpgadmin     Y     Y     Y     Y     Y     Y     Y     Y     Y     Y

I checked config.inc.php and found:

Code Select Expand

// MySQL configuration
$CONFIG['dbserver'] =                         'localhost';        // Your database server
$CONFIG['dbuser'] =                         'cpgadmin';        // Your mysql username
$CONFIG['dbpass'] =                         'xxxxx';                // Your mysql password
$CONFIG['dbname'] =                         'tcfmambocpg';        // Your mysql database name


// MySQL TABLE NAMES PREFIX
$CONFIG['TABLE_PREFIX'] =                'cpg132_';

Can anyone tell me what I'm missing?

Thanks!

Jeremy

P.S.  Red Hat Enterprise Linux, PHP: 4.3.2, MySQL: 3.23.58

[kegobeer]

If you write a simple php script that attempts to create a table, do you get an error?  If yes, that would mean that the user doesn't have the permission to do a create.

[jbutler]

I checked the cpgadmin user's permission with phpMySQL and found that ALL permissions were granted in the mysql/db table to cpgadmin on the database tcfmambocpg:

Stooopid me!

I had to make a change to the MySQL user account in phpMyAdmin and I forgot to RELOAD MySQL!

Durn!



Once I reloaded, Coppermine installed as it was supposed to.

Thanks for the quick response, nonetheless.

Regards,

Jeremy

[kegobeer]

Thanks for reporting what you did.

Welcome to the community!