Database Error

[redmondtm]

I just updated my MySQL database to version 5 now Im getting an error. I cant even access my admincp.

Can anyone help?


referral: http://www.ufc-forums.com

[SEOvB]

make sure your database user has the correct permissions for the database and the information is correct in config.php

[snakes1100]

Update the password for the correct user via phpmyadmin or run the mysql_fix_privilege_tables in ssh.

[WEBDosser]

if you have a backup then start over see what you did wrong?.. do you have cPanel hosting.

[Marco van Herwaarden]

if you have a backup then start over see what you did wrong?.. do you have cPanel hosting.
If you are not sure about an issue, then please do not try and give such suggestions, there is absolutly no need to restore the database.

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'backup'@'205.178.145.65' (using password: YES)
Check the username/password in the config.php.

[snakes1100]

if you have a backup then start over see what you did wrong?.. do you have cPanel hosting.

Why would you restore a database when the message he has states its a permission issue with the user/passwd, the cmd i posted is stated at the end of a mysql upgrade, a simple passwd reset thru phpmyadmin will take care of this, but its best to use the cmd to reset all the users & passwd's so no one else has the issue on the server.

[WEBDosser]

wow!!.. leave me alone fellas!.. what does it always say to do BEFORE installing any upgrade or addon or hack..

[snakes1100]

no ones bothering you... :confused:

he upgraded mysql, if he didnt backup, thats his mistake, but if he jumped from version 4.x.x to 5.x.x, then there maybe a simple issue with the privilege table and thats easily fixed, i dont see why he would of changed something in the config.php file.

[Marco van Herwaarden]

wow!!.. leave me alone fellas!.. what does it always say to do BEFORE installing any upgrade or addon or hack..
People only react because you give an advise that potentially can destroy data, and the advice you give is unneeded to solve the problem.

[redmondtm]

Thanks for the advice guys. I checked my username/password in the config.php and nothing has changed.

I am really frustrated with network solutions. I think I may change my hosting to eapps.

[Marco van Herwaarden]

Remove the MySQL user from your servers control panel and re-ad the user (don't forget to give permission to the database).

[redmondtm]

I got my forum back online. It turned out that my database IP changed when I upgraded MySQL. I changed the IP in the config.php, now Im up and running.

Thanks again guys.