TheMovieman Posted December 12, 2007 Share Posted December 12, 2007 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 Quote Link to comment Share on other sites More sharing options...
TCH-Dick Posted December 12, 2007 Share Posted December 12, 2007 MyDB Studio works fairly well, however I'm not sure if they have updated it in a while. MySQL offers several free tools. Quote Link to comment Share on other sites More sharing options...
OJB Posted February 10, 2008 Share Posted February 10, 2008 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 Quote Link to comment Share on other sites More sharing options...
TheMovieman Posted February 22, 2008 Author Share Posted February 22, 2008 I found the one I had used before, MySQL Administrator. Quote Link to comment Share on other sites More sharing options...
jnull Posted February 23, 2008 Share Posted February 23, 2008 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? Quote Link to comment Share on other sites More sharing options...
nortk Posted February 23, 2008 Share Posted February 23, 2008 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.