MySQL grant privileges not saving

twinfinity

Member
Jan 3, 2011
7
0
51
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 !!
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
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:

Code:
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,216
463
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 :)