Again MySQL error (1045)

[ntsite]

Hello. Today I realized that there are problems with connecting to MySQL. I get an error while trying to open gallery:
[mysql error 1045] Access denied for user.

 

[masshuu]

If you receive this error continuously, i would doublecheck that your user has permissions on the database, and recreate the user if necessary.

 

[ntsite]

If you receive this error continuously, i would doublecheck that your user has permissions on the database, and recreate the user if necessary.

Error seems to be issue with my settings, but I haven't made any change to my Database since January. all settings should remain the same more than 10 months, though data is being updated regularly.

 

[Anna]

Yeah, settings should remain the same, unfortunately it is not unheard of passwords getting messed up on the server.

I did run a quick command on the server, is there any difference? Noticed that it seem you have put a maintenance sign on the gallery.

 

[ntsite]

Yeah, settings should remain the same, unfortunately it is not unheard of passwords getting messed up on the server.

I did run a quick command on the server, is there any difference? Noticed that it seem you have put a maintenance sign on the gallery.

No difference. Yeah, I did change main page - cause it's frustrating when someone sees such errors while opening page, that's why I changed the main page. I write down the address manually rather than entering to index page.

Looked inside MySQL page, it shows up 0.00mb used for all databases. Logged into PhpmyAdmin but hangs. I could see the tables names, but not inside. phymyadmin just hangs and reponds very rarely...

 

[Anna]

Databases do show as 0.0MB in cPanel, and have for a long time, it has to do with the mysql server being remote.

I'll keep digging then.

 

[Anna]

Seem to be working now, can you confirm that?

 

[ntsite]

Databases do show as 0.0MB in cPanel, and have for a long time, it has to do with the mysql server being remote.

I'll keep digging then.

If it is normal issue, then OK. But remote connection has already been gained access, as I remember. Anyway the main issue was connection.

Seem to be working now, can you confirm that?

And yes, it works at last! Thank you. What was the reason?

 

[Anna]

Not entirely sure, I did a few various things, including recreating the db user in your account, as mentioned it is not unheard of the password getting messed up in the user table for mysql.

The 0.0MB is related to remote, as if we enable the option to allow cPanel to calculate the size (which is how it has to be done to get it to show) it tends to freeze up mysql server, due to cPanel not releasing the connection properly. It's been showing like that for more then a year now I believe.

 

[ntsite]

Not entirely sure, I did a few various things, including recreating the db user in your account, as mentioned it is not unheard of the password getting messed up in the user table for mysql.

I'm glad to see that no data lost regarding MySQL.

The 0.0MB is related to remote, as if we enable the option to allow cPanel to calculate the size (which is how it has to be done to get it to show) it tends to freeze up mysql server, due to cPanel not releasing the connection properly. It's been showing like that for more then a year now I believe.

Yeah, it's fair to disable as it creates some problems. And what about with pypMyadmin connection problems? Why it hangs on? Sometimes it doesn't respond at all.