vb.org Archive - Database Error

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)

- - Database Error (https://vborg.vbsupport.ru/showthread.php?t=180646)

redmondtm

05-27-2008 03:18 AM

Database Error

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

05-27-2008 05:38 AM

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

snakes1100

05-27-2008 06:23 AM

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

WEBDosser

05-27-2008 06:43 AM

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

Marco van Herwaarden

05-27-2008 08:46 AM

Quote:

Originally Posted by WEBDosser (Post 1532591)

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.

Quote:

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

05-27-2008 08:48 AM

Quote:

Originally Posted by WEBDosser (Post 1532591)

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

05-27-2008 12:29 PM

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

snakes1100

05-27-2008 12:33 PM

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

05-27-2008 12:37 PM

Quote:

Originally Posted by WEBDosser (Post 1532863)

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

05-27-2008 02:25 PM

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.

All times are GMT. The time now is 06:12 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01147 seconds Memory Usage 1,729KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: