Web Hosting Vodahost    

Home Take The Royal Tour! Order Now Features Prices
Go Back   Web Hosting > VodaHost Web Hosting Support > mySQL & PHP

Notices

mySQL & PHP Discussions, information and help with mySQL and PHP.

Reply
 
LinkBack Thread Tools
  #1  
Old 10-25-2007, 11:20 AM
Private
 
Join Date: Aug 2007
Posts: 2
Default Connecting to My SQL db.

Hi
i'am a developer working on the website www.wordigo.co.uk, hosted by Vodahost.

The website has a guestbook where visitors can leave their comments.
The comments are actually stored in a MySql database. Another page retrives the comments from the database and displays them.

The whole website including the two pages that communicate with the database have been designed using Dreamweaver 8.

Unitl recently everything has been working fine but now whenever i (or any 'viewer') try to access the pages that communicate with the database (ie. the guestbook pages) i get this error message:

"Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied
for user 'wordoco_mw'@'voda8.vodahost.com' (using password: YES) in
/home/wordoco/public_html/Connections/CommentsConnection.php on line 9

Fatal error: Access denied for user 'wordoco_mw'@'voda8.vodahost.com'
(using password: YES) in /home/wordoco/public_html/Connections/CommentsConnection.php on line 9"

This error seems to have come up by itself because i haven't changed anything at all.

There are several rows in the database table.

Eagerly waiting for any help/suggestions.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2  
Old 10-25-2007, 05:19 PM
Watdaflip's Avatar
Brigadier General
 
Join Date: Sep 2005
Location: Cincinnati, Ohio
Posts: 1,638
Default Re: Error when connecting to My SQL db.

don't use voda8.vodahost.com as your host... use "localhost", that should fix the connection problem. If that doesn't work try recreating the mysql user (if the password the script knows was accidentally changed, the only way to get it right again without knowing it is to remake the user)
__________________

Register/Login Script
Do you use a Password Protected Directory? Need a way to allow users to make their own account, try my .htaccess Login Script
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3  
Old 10-26-2007, 05:17 AM
Private
 
Join Date: Aug 2007
Posts: 2
Default Re: Error when connecting to My SQL db.

Thanks Watdaflip!!!

Just changing the value for 'Host' did the trick.

Thank You.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT +1. The time now is 03:02 AM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC7
2005-2009 VodaHost Web Hosting Your Perfect Web Host - All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176