MySQL Problems with CPANEL after update

2025-03-29

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?

MySQL Problems with CPANEL after update