Go Back   vb.org Archive > Community Discussions > Forum and Server Management
Reload this Page Database Error
FAQ Community Calendar Today's Posts Search

Reply
Page 1 of 2 1 2
 
Thread Tools Display Modes
  #1  
Old 05-27-2008, 03:18 AM
redmondtm redmondtm is offline
 
Join Date: Jul 2007
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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
Reply With Quote
  #2  
Old 05-27-2008, 05:38 AM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
make sure your database user has the correct permissions for the database and the information is correct in config.php
Reply With Quote
  #3  
Old 05-27-2008, 06:23 AM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Update the password for the correct user via phpmyadmin or run the mysql_fix_privilege_tables in ssh.
Reply With Quote
  #4  
Old 05-27-2008, 06:43 AM
WEBDosser's Avatar
WEBDosser WEBDosser is offline
 
Join Date: Oct 2001
Location: @ MyPC
Posts: 824
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
if you have a backup then start over see what you did wrong?.. do you have cPanel hosting.
Reply With Quote
  #5  
Old 05-27-2008, 08:46 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by WEBDosser View Post
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.
Reply With Quote
  #6  
Old 05-27-2008, 08:48 AM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by WEBDosser View Post
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.
Reply With Quote
  #7  
Old 05-27-2008, 12:29 PM
WEBDosser's Avatar
WEBDosser WEBDosser is offline
 
Join Date: Oct 2001
Location: @ MyPC
Posts: 824
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
wow!!.. leave me alone fellas!.. what does it always say to do BEFORE installing any upgrade or addon or hack..
Reply With Quote
  #8  
Old 05-27-2008, 12:33 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
no ones bothering you...

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.
Reply With Quote
  #9  
Old 05-27-2008, 12:37 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by WEBDosser View Post
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.
Reply With Quote
  #10  
Old 05-27-2008, 02:25 PM
redmondtm redmondtm is offline
 
Join Date: Jul 2007
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 05:08 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04484 seconds
  • Memory Usage 2,251KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete