mySQL databases

DJMK4 · 22 Jan 2006 at 15:24

iv got a free proggy called SQLyog which is a GUI version of mySQL and lets you create databases using a GUI..

I have my own webspace provided by a host, they have mySQL installed on the host.

When i start the windows free mySQL GUI proggy it asks me to provide the following info..

what exactly do i have to put in the mySQL host address?

Inquisitor · 22 Jan 2006 at 15:35

Just leave it as localhost.

Beansprout · 22 Jan 2006 at 15:40

Inquisitor said:
Just leave it as localhost.

Not if he's running it on his machine and the MySQL server is at a host's box somewhere

The domain name should be fine

sfx · 22 Jan 2006 at 15:55

You need the address of the MySQL Database which will NOT be localhost unless the Database is running on your machine. Most hosts block remote access to MySQL and it must be accessed from localhost. So unless they allow remote access to the Database you cannot use that I'm affraid.

sfx

Beansprout · 22 Jan 2006 at 16:06

With cPanel the default access list is localhost, and you can add other addresses to the list. However, the host may firewall off MySQL from the outside world so it's worth checking with them

DJMK4 · 22 Jan 2006 at 16:19

Ok, abit confusing, iv found a way of creating a database through my cpanel using phpmyadmin. But its a little confusing when entering table details...Iv never done mySQL before, only Access stuff..

If anybody with msn could help me id really appritiate it, im a quick learner so it wouldnt be too much hassle, you would be helping me out a great deal..

iv been trying to follow a book and creating it from scratch but for some reason it just wont work when trying to get onto the frontend of the database by using pear..

Inquisitor · 22 Jan 2006 at 16:33

Beansprout said:
Not if he's running it on his machine and the MySQL server is at a host's box somewhere

The domain name should be fine

Woops, didn't read his post properly and assumed it was running off his machine

DJMK4 · 22 Jan 2006 at 16:37

Right i have been able to get a sucsessful connection when i test it using http tunneling to my web host..But for some reason when i click the connect button, it says sucsessful, but then the proggy still does not act like it is connected as the dialogue box is still displayed..

Anyone with msn would be a great help

thanx

paulsheff · 22 Jan 2006 at 18:49

What settings have you put in?

They differ but one of mine in yog (which is as really good MySQL editor if you haven;t got phpMyAdmin) is just

mysql.hostsname.com
And the name of the database is mywebsiteaddress_co_uk

DJMK4 · 22 Jan 2006 at 22:41

ahh i realised what the problem was, i had to upgrade to the executive version to connect using a http tunnel..All snorted now

Thanks