I was wondering if anybody here could give me an idea how to fix MySQL grant privileges.
The issue is, I upgraded MySQL to 5.1.56 and now when a database and user are created ( the user is granted full privileges when added to database ), both database and user exist but the user has no privileges for the database added to. Full privileges apparently aren't saving. Script installers can't select the database.
For ex: WordPress
Cant 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 urhostz_wp database.
Are you sure it exists? Does the user urhostz_wp have permission to use the urhostz_wp database?
On some systems the name of your database is prefixed with your username, so it would be like username_urhostz_wp. Could that be the problem?
I have searched and searched... Even posted at cPanel forums but as yet to get or find an answer.
Check /root/.my.cnf and make sure there are quotes around the password.
This is a bug that cPanel had for a little bit which will cause things not to be set correctly. If there weren't quotes, remove the user in cPanel and re-add it after putting quotes around the password in this file.
and signing up there. You will need the root login for the server, the server's IP address, and your "Support Number" found in WHM. Click close when it tries to pass you off to your server provider (if it does) and select to use Complimentary support. It usually says there are a dozen or so requests ahead of you, but cPanel support are quick to respond and are very good.