Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : MySQL Problems with CPANEL after update

[Nicholas Brown]

After getting online this morning, I get an ICQ Message from one of my customers saying

Hey Nick,

The new phpmysql version is messed up..... and I think mysql is messed up in general...

I'm trying to run a SQL query in telnet - as well as phpmysql and I'm getting errors...

The db/user are correct and the user is added to the db... and I'm still getting denies...

So I log into the customers phpMyAdmin and I can see all the databases.

I then go to create a table in one of the customers databases which has had a username and password created for it and get the message:

SQL-query:

CREATE TABLE nick (id TINYINT (3) not null , text1 MEDIUMTEXT not null , text2 MEDIUMTEXT not null , PRIMARY KEY (id), UNIQUE (id))
MySQL said: Access denied for user: 'CUSTOMER@localhost' to database 'CUSTOMER_db'

So it now seems that since the cpanel updates, if you create a user and password for a certain database, you cant access that database by going to

CPanel >> SQL >> phpMyAdmin

Anyone else noticed this?

[Nicholas Brown]

Correction...

It now seems to be working in phpMyAdmin but not in the mysql comand prompt via ssh

[badhat]

I can't install vbulletin, getting 1044 access denied errors after completion of about 2/3 of the third part of the script (inserting and manipulating vbulletin tables). See below, caps substituted for actual values:

............

Altering word table

The script reported errors in the installation of the tables. Only continue if you are sure that they are not serious.

The errors were:

Error number: 1044

Error description: Access denied for user: 'USERNAME@localhost' to database 'DATABASENAME'

[Nicholas Brown]

Originally posted by slinky
I can't install vbulletin, getting 1044 access denied errors after completion of about 2/3 of the third part of the script (inserting and manipulating vbulletin tables). See below, caps substituted for actual values:

Yeah - what cpanel are you running? Dark orb or VDI?

Im running dark orb - everything was fine until the new phpMyAdmin was introduced into cpanel

[badhat]

Originally posted by Nicholas Brown


Yeah - what cpanel are you running? Dark orb or VDI?

I have no idea -- I'm on a virtual host and don't know how to tell the difference. Just says CPanel 3 on the top right, logo on top left, dark blue outside, medium blue main page with white text. Either way... I'm stuck!!!

[bert]

Yeah, I have the Darkorb version and have the same problems

[Craig]

I had this problem yesterday then Nick tracked down this bug yesterday afternoon and built a release with the fix. Just run /scripts/upcp to update your Cpanel to the latest version. Also - if you still experience this issue after
updating, try adding/deleting a mysql username - this will reset the mysql perms for that user.

Regards

Craig

[bert]

Thanks Craig. That did the trick

[badhat]

Originally posted by Craig
I had this problem yesterday then Nick tracked down this bug yesterday afternoon and built a release with the fix. Just run /scripts/upcp to update your Cpanel to the latest version. Also - if you still experience this issue after
updating, try adding/deleting a mysql username - this will reset the mysql perms for that user.Craig

THanks but I tried all that. My provider updated cpanel to the latest version, reset it, I deleted the database, creating a new one, created a new user, tried it all, same problem. Very odd...

[bert]

slinky,

This might sound stupid, but are you entering the correct database user on the config.php file for vbulletin?

I mean, remember that with cpanel, your database user is a combination of your account user and the database user like this:
accoutusername_databaseusername

You might off course know this, but I just thought it was worth mentioning.

[badhat]

Originally posted by bert
slinky,

This might sound stupid, but are you entering the correct database user on the config.php file for vbulletin?

I mean, remember that with cpanel, your database user is a combination of your account user and the database user like this:
accoutusername_databaseusername

You might off course know this, but I just thought it was worth mentioning.

Definitely worth mentioning and it solved problems for other people. Unfortunately, the answer is absolutely. I also edited the same config file settings that works for vb that I'm currently using at the same domain!!! (Yes, I also used a fresh copy of vbulletin 2.0.3 and edited that config too!) I'm trying a fresh install into a different directory, new database, different user. You name the combination and it just doesn't work. The fact that I'm on the same domain shouldn't matter and I've done this before. I'm entering the following:

database: accountusername_database2name
user: accountusername_newdbaseusername
password: newdbaseusernamepassword

Thanks so much for this. Nobody can figure this strange one out.

[bert]

This is very strange.

Have you asked your host if anyone else is having these problems on their server(s) ?

[badhat]

Originally posted by bert
This is very strange.

Have you asked your host if anyone else is having these problems on their server(s) ?

Yeah. They said they received a lot of calls after they updated the new cpanel. However, I'm not sure if I'm the only one with this particular problem.

[bert]

You need to let them know again. By the looks of it, it has to do with the server and its configuration and not with you. They need to look into this for you.

Good luck

[Craig]

Last couple of days have been just awful with the cpanel issues. Lets hope that tonites fix's will sort out any problems that are left. Im sure the team is working hard to solve all of them.

Time is the greatest healer, aparrently.

Regards

Craig