PDA

View Full Version : Database Error


redmondtm
27 May 2008, 04:18
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
27 May 2008, 06:38
make sure your database user has the correct permissions for the database and the information is correct in config.php

snakes1100
27 May 2008, 07:23
Update the password for the correct user via phpmyadmin or run the mysql_fix_privilege_tables in ssh.

WEBDosser
27 May 2008, 07:43
if you have a backup then start over see what you did wrong?.. do you have cPanel hosting.

Marco van Herwaarden
27 May 2008, 09:46
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
27 May 2008, 09:48
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
27 May 2008, 13:29
wow!!.. leave me alone fellas!.. what does it always say to do BEFORE installing any upgrade or addon or hack..

snakes1100
27 May 2008, 13:33
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
27 May 2008, 13:37
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
27 May 2008, 15:25
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
27 May 2008, 16:00
Remove the MySQL user from your servers control panel and re-ad the user (don't forget to give permission to the database).

redmondtm
27 May 2008, 16:54
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.