I don't thik i can connect using that method due to the fact im currently using remote hosting, so i don't think i can open terminal windows??
Any other ideas thanks
Not really sure what you mean here. Are you working on a Linux machine? What do you mean by remote hosting? If, for example, you are working on a remote Linux machine from another local machine sitting in front of you, either LInux or Windows, then you can do what I suggest.
For example, if you are working on Linux remotely from Windows using a putty.exe window, then you have the window right there where you can invoke the mysql command to attempt a connection. Same actually if you are working on a remote Linux from a Linux machine. You can attempt to connect to your "server" machine database from your "client" machine database from a Linux operating system (which has the mysql client software installed on it) simply by calling the mysql command (with proper arguments as described in my previous post here) from the command line in a shell window. It does not matter whether that shell is a remote shell from a Windows of another Linux machine.
You could try the same from a Windows machine directly using a Windows command window if you have the Windows version of the mysql client installed on your Windows machine. I believe there is a Windows port.
Or perhaps I don't understand what you mean with the problem "you are using remote hosting". If your "server" machine is a Linux machine located at a remote internet provider, that does not matter at all. I have had no problem making a connection with the mysql command from my home machine to my database on my internet provider, as long as I give the correct arguments to the "host" and "username" parameters, and then provide the correct password when prompted. Again, any firewall you have on your PC must allow such a connection (maybe it does per default, but if you get stuck here, check your firewall).