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 05-15-2007, 01:31 PM
Sergeant
 
Join Date: Feb 2006
Location: UK
Posts: 20
Send a message via Skype™ to easyquote
Exclamation Coonecting to MYSQL on Voda

I am looking at a database builder called Navicat, building the data basis is done in a live enviroment, but i can not connect to MYSQL using the Voda IP address or the host and idea how ?
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 05-15-2007, 01:45 PM
Collectors-info's Avatar
General
 
Join Date: Feb 2006
Location: London (UK)
Posts: 5,703
Default Re: Coonecting to MYSQL on Voda

I am sure Navaldesign will be along to help soon.
(Especially with a software name like this) lol
If you have still got time? Pop his name or the software name in the heading to attract his attention. But you may have been timed out by now.

Good luck.
__________________
Regards Chris,
Sites are view in FF & IE, with res @ 1024 x 768 on 19” screens.


How to ask for help on the forum. - VH prices. - BV Tutorials. - Using PIXresizer - Image/Photo Tips -
Collectables, Collecting
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 05-15-2007, 09:16 PM
Watdaflip's Avatar
Brigadier General
 
Join Date: Sep 2005
Location: Cincinnati, Ohio
Posts: 1,638
Default Re: Coonecting to MYSQL on Voda

Most likely you need to allow your IP in the Access Host. Go into cPanel, click the MySQL icon, and scroll down to the bottom of that page. There is a field for you to enter an IP address into, enter your IP address there
__________________

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
  #4  
Old 05-15-2007, 09:51 PM
navaldesign's Avatar
General & Forum Moderator
 
Join Date: Oct 2005
Location: Italy
Posts: 9,346
Default Re: Coonecting to MYSQL on Voda

Could also be something like (in my case) "host53-212.pool80117.interbusiness.it" .

Please note that if you have a dynamically changing IP address and/or host, you will need to repeat the same procedure every time you disconnect.
__________________
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 05-19-2007, 05:51 AM
Karen Mac's Avatar
General & Forum Moderator
 
Join Date: Apr 2006
Posts: 4,504
Send a message via MSN to Karen Mac
Default Re: Coonecting to MYSQL on Voda

I was just helping Holly with an issue like this, and ours was the PORT number was needed for a direct connect or bridge to the live database, and we couldnt get it done. And we used the HOST ip as well too, or her computers ip. Didnt think of the base string that Naval suggested tho. I did note tho, on one account i have mysql version 4, and on the other account i have version 5.. so maybe we need updates.. :)

Karen
__________________
KMAC Enterprise
Granny's Country Nook 10%Off, your code: Forum Discounts
Charming Noveltees~Sports Logos Charms, Jewelry, Collectibles- 10% off, your code: VodaHost
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #6  
Old 05-19-2007, 06:19 AM
navaldesign's Avatar
General & Forum Moderator
 
Join Date: Oct 2005
Location: Italy
Posts: 9,346
Default Re: Coonecting to MYSQL on Voda

Karen,

VH updates MySQL from time to time, as well as php (you will see that php on some servers is version 4 whilst on some others it is version 5) . However, the remote connection has nothing to do with the version of php or MySQL but with the settings of the server.

There are some softwares that use an intermediate piece of software for remote communication. Usualy a php file is installed on the server, which allows connection as localhost (as local conection within the same server) then this file (script) comunicates with desktop aplication directly.

This way you acheive the results of a remote connection without actually establishing one.
__________________
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
  #7  
Old 05-19-2007, 05:47 PM
Karen Mac's Avatar
General & Forum Moderator
 
Join Date: Apr 2006
Posts: 4,504
Send a message via MSN to Karen Mac
Default Re: Coonecting to MYSQL on Voda

Naval..

Yes i know.. Ive installed several. 2 of my stores are installed in this manner and i create the database at the time of installation and can also populate the cart same way. This was for oscommerce, and it was an addon for populating the cart ... etc. We never could get the direct connection and im sure its the port number. The only way it would become operational and by pass this was to create a BRIDGE, and I could do it and alter the necessary files but Holly chose not to. This BRIDGE would have to be created EACH time it was used, so it tended to take away some of its automated effect. It involved installing another script as you said to establish the connection.

I think this might be an issue with DESKTOP applications, as I have no issues when im running addons..etc that actually work on the live server.
Karen
__________________
KMAC Enterprise
Granny's Country Nook 10%Off, your code: Forum Discounts
Charming Noveltees~Sports Logos Charms, Jewelry, Collectibles- 10% off, your code: VodaHost
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 04:03 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