Jump to content
Sign in to follow this  
TheMovieman

Program To Manage Mysql Databases

Recommended Posts

Hello,

 

I had a nice program to manage my databases but my motherboard failed and I decided to get a new computer at that time but now I can't find that program. My old system files were transferred over but nothing there rings a bell so now I need a new one (or perhaps something someone mentions will make me remember).

 

So, any suggestions for a good (and free) program to manage databases? I know I can do it through cpanel (or used to) but I prefer to use another program.

 

Thanks :)

Share this post


Link to post
Share on other sites

As TCH-Dick said MySQL do two nice ones, MySQL Query Browser (for executing queries etc) and MySQL Administrator (i think its called, for managing the structure of the DB itself)

 

 

I also use PHPMyAdmin (which is what you get in CPanel) on my localhost

Share this post


Link to post
Share on other sites

Saw this thread and was curious ... if using MySQL Administrator on my computer how do I connect to the db on my TCH web site?

Share this post


Link to post
Share on other sites

This worked for me:

 

1. Go into CPanel and under "Remote MySQL", put your own IP address (if you are behind a router, then probably you want the IP address of the router...the one assigned by your ISP.

2. Start MySQL Administrator.

3. Enter your domain name for the "Service Host". I left the port at 3306.

4. For your username, enter the username of one of your MySQL users (the MySQL usernames will all begin with your CPanel username and an underscore).

5. Enter the corresponding password for that MySQL user.

 

Once connected, it should let you see all the databases to which that user has been given privileges.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...