From Asp/access To Php/mysql

[susandennis]

I *think* I'm looking for a mysql client or at least a nicer front end that the one that Cpannel offers up.

 

I'm familiar enough with Access and asp pages to know what I'm doing. On another host, I populate an Access data base, upload it and it populates an asp page there.

 

I want to create a new database to build some specific pages but I want to do it here on my TCH account so I need to start with MySQL. And I know nothing.

 

I poked around and found SQLyog which appears to be a nice looking GUI to MySQL (http://webyog.com). I think it is kind of just a front end that lives on my computer and connects up to TCH and wiggles the database there - as opposed to working it on the client and uploading.

 

But, I can't figure out the correct set of whatever to get it to connect.

 

This screenshot shows what it's asking: http://webyog.com/images/screenshots/conn_mngr.jpg. Username and password I know... but the host access and port have me stumped.

 

What is my host access and port? (the domain is susandennis.org)

 

Or is there a better front end to use? Or am I barking up the wrong tree all together and just need to suck it up and use the cpanel thing?

 

Thanks... clearly I have major gaps in the old knowledge base!

[TCH-MikeM]

Hey Susan,

 

I'm unable to confirm that your website in your signature is hosted with us so this will have to be handled by a non-staff member. Sorry.

[susandennis]

Hey Susan,

 

I'm unable to confirm that your website in your signature is hosted with us so this will have to be handled by a non-staff member. Sorry.

 

?? I actually have two hosting accounts on TCH. The website in my signature is not hosted by you but I pointed out in my question that I wanted to use the website at www.susandennis. org which most certainly is.

 

My two accounts are:

susandennis.org (this is the one I'd prefer to use) - username of susande

karolene.com - username of something I can never remember ...

 

My bills are paid. What do you need to confirm? I don't really care if my question is answered by a staff member or not but it is kind of disconcerting to have had two acounts for nearly 3 years and not be acknowledged as part of the family!

Edited December 4, 2006 by susandennis

[Head Guru]

I thought the same thing when I saw the web site in your signature is not hosted here.

[PeterPeter]

Hi Susan,

 

I don't use the program but I thought this might help a bit http://www.webyog.com/en/whitepapers/HTTP_...hoo_Hosting.pdf I know it says Yahoo, but if you look through it as you use the program it should make better sense than just looking at a screen shot and leaving you haning. You know what you are doing I'm sure of that. When I setup a database, usually the script I am using sets it up for me, but when it doesn't I use cPanel to access the Mysql data bases and setup on in there and then use the info during the process of setting up the script to access the info by cut and pasting the database name etc except for password of course to ensure I don't mess the syntax etc. I find that the best way for me.

 

Hope that helps.

[susandennis]

I thought the same thing when I saw the web site in your signature is not hosted here.

 

OK,ok, I am so very very sorry. I had no idea that listing my website would be so offensive.

 

My post stated clearly that the question concerned susandennis.org which has been housed here for at least 3 and probably closer to 4 years.

 

I have four websites - two are here and I'm trying to figure out how to bring in one of the others.

 

I have removed the insulting website link.

[susandennis]

http://www.webyog.com/en/whitepapers/HTTP_...hoo_Hosting.pdf

 

Thank you, Peter, that is VERY helpful - so I use tunnelinng and mysql (instead of local host). Cool. I'll find that tunneling page and upload it to my account.

 

I haven't yet figured out the scripting things. Thought maybe I'd noodle out the database end first. This is just the clue I was missing.

 

I really appreciate your digging this up for me! Thank you!

[PeterPeter]

No problem Susan any time just ask any of us. I think there was just a bit on confusion which website that is all.

[Head Guru]

Who said we were insulted. I never said that Susan

 

We just get a lot of non-tch clients asking for support around here that is all.

 

Have a nice day.