Jump to content

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 :)

Link to post
Share on other sites
  • 1 month later...

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

Link to post
Share on other sites
  • 2 weeks later...

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.

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.

×
×
  • Create New...