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
 
Thread Tools
  #1  
Old 04-18-2009, 08:58 PM
Corporal
 
Join Date: Dec 2008
Posts: 11
Question MySQL help

I have recently purchased a PHP Classifieds script and during installation it is telling me to Please create a new MySQL database and database user in your hosting control panel for PHP Classifieds.
Or contact your service provider to set up MySQL as service for you.

I set up a database but it's asking me for few things to continue with installation. So far I've been unable to provide the correct info.

1. host location
2. database name
3. database username
4. database password

Can you tell me what I'm supposed to put in these fields? I called the database PHPClassifieds but it shows up as dzuuwqs_PHPClassifieds in the list. The user name that i created is mlandry, it is showing as dzuuwqs_mlandry

Any help would be greatly appreciated.
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 04-18-2009, 10:26 PM
Watdaflip's Avatar
Major General
 
Join Date: Sep 2005
Location: Cincinnati, Ohio
Posts: 2,151
Default Re: MySQL help

cPanel automatically prefix's the database name and username with your cpanel username.

For the database name enter "dzuuwqs_PHPClassifieds"
For the username enter "
dzuuwqs_mlandry"
and then for password enter whatever you actually entered the password as
the host location will be "localhost"
__________________

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 04-18-2009, 11:05 PM
Corporal
 
Join Date: Dec 2008
Posts: 11
Default Re: MySQL help

That's what I thought, but when I continue to the next step it shows me this. Any advice? I cannot get any further than this in the installation.



PHP Classifieds Script -- Installation

Step 3

Setting config file...OK

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'dzuuwqs_mlandry'@'localhost' (using password: YES) in /home/dzuuwqs/public_html/mysql.ini.php on line 401
Dropping tables if exist...
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/dzuuwqs/public_html/mysql.ini.php on line 429
Connect Error:Access denied for user 'dzuuwqs_mlandry'@'localhost' (using password: YES)Query Error:Access denied for user 'dzuuwqs_mlandry'@'localhost' (using password: YES)SQL:DROP TABLE IF EXISTS accounting
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4  
Old 04-19-2009, 07:41 AM
navaldesign's Avatar
General & Forum Moderator
 
Join Date: Oct 2005
Location: Italy
Posts: 10,052
Default Re: MySQL help

Creating the user is not enough, you also need to allow him permissions for the specific database, did you do this ?
__________________
Navaldesign
Logger Lite: Low Cost, Customizable, multifeatured Login script
Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5  
Old 04-19-2009, 08:14 AM
Corporal
 
Join Date: Dec 2008
Posts: 11
Default Re: MySQL help

Yes, I selected no restrictions for the user
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 Off



All times are GMT +1. The time now is 01:06 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, 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 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203