Navicat

[acsteve]

Hello,

 

I guess all I want to know is does anyone know how to hook up to their MYSQL on TCH using Navicat. http://www.navicat.com/store.html

 

Thanks Steve

[PeterPeter]

Creating a Database

 

Creating databases and users is easy but not the most intuitive process. The first thing you need to

do to create a database is actually the last item in the database section. Type the name of the

database into the Db: field and then click on the Add Db button. A database will be created and its

name will be displayed at the top of the page.

 

The actual name of the database will be slightly different from the one you choose. The

database will be created with your cPanel username and an underscore character added to

the beginning of the name you chose when you created the database, for example,

domain_mydatabase.

 

Creating a Database User

 

Creating a database just creates an empty shell, waiting for data. Before you can use the database,

you will need to put at least one user into the database. To create a new user, you need to type a

username and password into the user section of the database screen and then click Add User. This

will create a user with the password you define. Never leave the password field blank.

The database username will be your cPanel username followed by an underscore and then

the username you chose. For example, domain_jeff

 

Adding a User to a Database

 

You aren't done yet. You now have to associate at least one user with a database. Just above the

Add Db field is a set of drop-down lists. The first of these allows you to select a user that you have

already created and the second allows you to select the database that you want to associate with

that user. Click Add User to Db and you are done. You can add a single user to multiple databases

if you want to.

 

Once you add a user to the database you've created, you will notice that the listing for that

database gets more detailed. It will show you the database name followed by some links to delete

or repair the database and then it will show you every user in that database, along with sample

code that shows you how to connect to the database in a PHP, Perl, or JDBC script (JDBC is only

listed if your web host offers Java support).

 

 

Then when you need to setup the parameters in the program to access the database

 

use this link from navicat to help access. http://www.navicat.com/win_manual/RemoteConnect.html

[acsteve]

Thanks Peter. I know pretty much about setting up databases, after ,much head bangging that is . I can not connect to a database that I have already created in my c pannel with Navicat. I am not sure if I need a port number or not but it does ask for one depending which way I try to hook up. I have tried the Http tunnel (do not even know what that means) and the general settings (the link you sent me) nothing seems to work. I wonder also if I should be giving my database user name and password, or my ftp name and my ftp password. I guess everything i am trying to say is. 1. do I need a port number.2. which info should i be feeding in, database name etc or ftp name etc? Any help would be greatly appreciated.

 

Thanks

Steve

[TCH-Bruce]

In the MySQL section of cPanel have you given your IP address access to the files? It's at the very bottom and it's called Access Hosts.

[PeterPeter]

Don't know about the port, but you should be using the database name and password you have setup. That link is from navcat and has everything in there basically that you should be useing from what I could see. I had a relatviely good look around at the database side of things.

 

If it is asking for an IP address then you would have received that in your welcome email when you started your hosting.

 

Sorry can't be of anymore help about it than that.