MySQL grant privileges not saving

[twinfinity]

Hello,

I upgraded MySQL to 5.1.56.

When creating user and database, they both exist but the user has no privileges to the database even the privileges were granted when added as user to the database. Script installers won't select database. For ex:

WordPress:

Can’t select database

We were able to connect to the database server (which means your username and password is okay) but not able to select the twinfinity_wp database.

Are you sure it exists?
Does the user twinfinity_wp have permission to use the twinfinity_wp database?
On some systems the name of your database is prefixed with your username, so it would be like username_twinfinity_wp. Could that be the problem?

I scoured Google for a fix but have yet to find one... any help is highly appreciated !!

 

[m4rc3]

does anything show up on cpanel's error log when you try all that ?

 

[cPanelTristan]

The error log is at /usr/local/cpanel/logs/error_log and the MySQL error log is at /var/lib/mysql/hostname.err (where hostname is the full hostname of the machine that you get when you run "hostname -f" command). To tail these, you'd do:

tail -fn0 /usr/local/cpanel/logs/error_log
tail -fn0 /var/lib/mysql/hostname.err

You'd want to run the command right before trying to create a database in cPanel and then see if any errors appear in either log.

 

[boorsekala]

i have same problem wich solution ?

 

[cPanelMichael]

i have same problem wich solution ?

It depends on the exact error message that is logged to the cPanel error log when you experience this problem.

If you have root access to the server, please consider opening a ticket for this issue so we may investigate further:

Submit A Ticket

Thank you