forums › forums › SQLyog › Using SQLyog › Sqlyog With 1&1 Web Hosting
- This topic is empty.
-
AuthorPosts
-
-
August 1, 2007 at 9:13 pm #10474barryccampbellMember
I'm trying to migrate to a new hosting service, 1&1 web hosting, from Yahoo! It's cheaper, but I'm having trouble setting up Sqlyog to connect to the mysql. Yahoo was a breeze with the tunneling, but I'm stuck on this. Do you have to use a proxy? Secure SSH? Anyone who's has run into this that could help would be great. If I can't use Sqlyog with the new service, I'd rather pay the extra $15/ month to Yahoo!
Thanks
-
August 1, 2007 at 9:36 pm #24606peterlaursenParticipant
please detail the 'problems in connecting'! what happens? what does not happen? any error messages?
I suppose you still use HTTP-tunnel? if so:
1) can you connect to the tunneller from a browser?
2) can you connect to MySQL from a simple PHP-script in the same folder (try for instance to build a script executing something like “SHOW DATABASES”)
3) sometimes there are limitations on the webroot folder. There might also be some global webserver directives causing the trouble. If webserver is Apache try creating a subfolder for the tunneller and place an empty .htaccess there. This will turn of such global directives for that folder.
Alternatively try if SSH access is possible. And if 2) is not possible you should definitely ask the support there for help on this. Webserver and PHP misconfigurations happen with freshly configured domains!
-
August 2, 2007 at 2:14 pm #24607barryccampbellMember
thanks for responding. I did get the connection to work. I did what I recommend everyone do, I walked away, forgot about it, went back early this morning and it worked after the second try. 1&1 gives you a host name that must be used in the MySQL Host Address. Every other server I have used has localhost or mysql as the Host Address. After carefully READING the information provided, then using their given host name, then adding the username & password that was provided, the connection worked. Again, thanks for responding, and maybe this will help some other soul that fails to carefully READ the information the first time through.
Barry
-
August 2, 2007 at 2:59 pm #24608peterlaursenParticipant
FAQ here tell the same:
-
-
AuthorPosts
- You must be logged in to reply to this topic.