SQL Database question.

NetBookProfit · #1 08-13-2006, 10:22 PM

Ok, I like to access my database with SQLFront. Its free, google it if you want to see it, and use it, and help me.

But I want to connect to my database... but im having trouble... I know the DB user name, the DB password, and DB name. But it dont know the server name. I tried my domain.com but it didnt work. I have an addon domain and i tried that too, but it didnt work..

Yes, I already added my IP/IS wild card using %. So its not that...

So what is the address to my db server?

quietFinn · #2 08-14-2006, 01:08 AM

Quote:

Originally Posted by NetBookProfit

So what is the address to my db server?

It's YourDomain.com

kmaw · #3 08-14-2006, 02:30 PM

localhost

or

127.0.0.0

?

quietFinn · #4 08-14-2006, 02:42 PM

Quote:

Originally Posted by kmaw

localhost

or

127.0.0.0

?

Only if the connection is local, like from your website to the database in the same server.
With sqlfront you connect from your PC to the database in the server.

slapshotw · #5 08-15-2006, 09:21 PM

I use CocoaMySQL for this same thing. I connect to the domain I have the database on, in some cases my main domain, in some not. I made sure to add my exact IP address to the "allowed hosts," without using and wildcards.

-Matt

Serra · #6 08-15-2006, 09:36 PM

Be careful with wild cards, best to use three octets for the wild card. Like 192.168.0.%. Once you have it working, switch to either IP address of your local machine, or assign your machine a subdomain out of your domain.

NetBookProfit · #7 08-16-2006, 03:00 AM

thanks for your reply guys... i was trying to connect to the phpBB sql database that was created when i installed it with fantastico.

some reason i couldnt connect with the user name and password that was automaticaly made during phpBB install, so i just added another user onto the database, and was able to connect with that name and pass.. weird.

but yeah, like i originaly thought, it was my domain name.

thanks again.

quietFinn · #8 08-16-2006, 05:46 AM

Quote:

Originally Posted by NetBookProfit

thanks for your reply guys... i was trying to connect to the phpBB sql database that was created when i installed it with fantastico.

some reason i couldnt connect with the user name and password that was automaticaly made during phpBB install, so i just added another user onto the database, and was able to connect with that name and pass.. weird.

To see the database username/password you must look at the source code. What Fantastico shows (and mails if you like) are NOT the database username/password, they are the admin username/password.

kmaw · #9 08-16-2006, 11:49 AM

Quote:

Originally Posted by quietFinn

Only if the connection is local, like from your website to the database in the same server.
With sqlfront you connect from your PC to the database in the server.

Handy, didn't realize what exactly the program was for.

Thanks.

DavidL · #10 08-29-2006, 11:04 AM

I can't seem to get this working. I put my IP address of my computer into the host list and then tried to connect with CocoaMySql using my domain name.

Actually, I've thrown a bunch of darts but nothing has stuck, any help would be appreciated. Thanks

David

cjnoyes · #11 08-29-2006, 04:05 PM

Quote:

Originally Posted by DavidL

I can't seem to get this working. I put my IP address of my computer into the host list and then tried to connect with CocoaMySql using my domain name.

Actually, I've thrown a bunch of darts but nothing has stuck, any help would be appreciated. Thanks

David

Is the Ip address public or a 192.168 ish local kind? it needs to be a public one

Serra · #12 08-29-2006, 06:23 PM

The IP will be the IP you use to access the site. The public one. (for external programs, for PHP web pages, it would be localhost)

On the MYSQL screen it shows the information you need to connect to your database. (minus the password.)

DavidL · #13 08-29-2006, 07:42 PM

its the 192 ish number. I know that i need to have the user and password from the cPanel but still not clear what to put into the host list.

slapshotw · #14 08-29-2006, 10:54 PM

No, that's your internal IP. Go to http://www.whatismyip.com. That's your external IP-- that's the IP that needs to go into the list.

-Matt

DavidL · #15 08-30-2006, 07:25 AM

Thanks, I went to a what'smyIP site, not the one you gave me, and it gave me the 192 number, hmmmm. Now the last key is what do I put into the Host section of my SQL program? I've tried my site, the IP address I get with PHPmyAdmin, my mom's telephone number...

slapshotw · #16 08-30-2006, 04:31 PM

That site gave you a 192 address? I didn't think that was possible... I know for a fact that 192 addresses are reserved for use in internal networks.

What about this site:

http://checkip.dyndns.org/

-Matt

DavidL · #17 08-30-2006, 04:46 PM

I'm sorry about that, what I meant was that I used another site and it gave me that 192 number the site mentioned here gave me my correct IP address.
I've connected to many sites from CocoaMySql so this isn't new to me just this is the first time with HG.

Now what do I put into the program for Host?

And thanks to all that have helped, it is much appreciated.

DavidL · #18 08-31-2006, 09:17 AM

Finally got all this to work, IT WAS my Mom's phone number

Actually it was my domain name that was needed, tried that before but it somehow clicked this time. I swear it wasn't my error either...I don't think...well maybe it could have been. Thanks again.