Hello,<br /><br />I was just wondering how people connect to their mysql databases? At the moment I am using the php admin tool in the cpanel. Although its functional it's not great.<br /><br />I use to love a tool called toad which worked with Oracle databases. Does anyone know of anything similar for mysql, and have they got it working with the remote databases at TCH??<br /><br />thanks<br />John<!--content-->
The best, and most widely used, is phpMyAdmin. <a href="http://www.phpmyadmin.net" target="_blank">http://www.phpmyadmin.net</a><br />Curious as to why you put phpBB in the title ?<!--content-->
I use YourSQL for quick work/updates. It's ok (and free), although I don't think it's that much better than PHP MyAdmin. I had the chance to use NavCat once, and that's a very nice program if you want to pay the fees for it.<!--content-->
total choice provides you with phpMyAdmin in your control panel somewhere. Most hosts do.<!--content-->
I recommend <a href="http://www.mysql.com/products/administrator/" target="_blank">MySQL Administrator</a>. It's free, works on multiple operating systems and is made by the same folks that make MySQL. I haven't had the chance to work a lot with it but it seems to be pretty good. I don't think it's as feature packed as phpMyAdmin but for regular database administration it works just fine and it's faster than loading a webpage for each action you do.<!--content-->
<!--QuoteBegin-TCH-Raul+Mar 27 2005, 10:45 PM--><div class='quotetop'>QUOTE(TCH-Raul @ Mar 27 2005, 10:45 PM)</div><div class='quotemain'><!--QuoteEBegin-->I recommend <a href="http://www.mysql.com/products/administrator/" target="_blank">MySQL Administrator</a>.<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />Thanks I'll look into that. Interestingly I just found that TOAD have made a TOAD for Mysql so will download that and have a play as well.<br /><br /><!--QuoteBegin-TCH-Raul+Mar 27 2005, 10:45 PM--><div class='quotetop'>QUOTE(TCH-Raul @ Mar 27 2005, 10:45 PM)</div><div class='quotemain'><!--QuoteEBegin-->I don't think it's as feature packed as phpMyAdmin but for regular database administration it works just fine and it's faster than loading a webpage for each action you do.<br /><div align="right"><a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=121762"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />That is exactly what I'm after, I dont really need all thee bells and whistles - and certainly not loading a web page each time.<br /><br />Does anyone have any experience of accessing dbs remotely? I'm guessing the port would be the one shown in the url when opening myphpadmin. But what would the host be? If anyone knows much appreciate the answer, If not I'll create a ticket and post the syntax here.<br /><br />(it's lovely and sunny in England today! wooo hoooo)<br /><br />John<!--content-->
I have MySQL Administrator installed here at home - it's geared towards managing a MySQL server. Many of the tools it provides are not usable by you on TCH's SQL servers, because you won't have sufficient permission to use those functions.<br /><br />Depending on what you're wanting to do, the <a href="http://www.mysql.com/products/query-browser/" target="_blank">MySQL Query Browser</a> may meet your needs better (and it's also made by the people who make MySQL).<br /><br /><!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->Does anyone have any experience of accessing dbs remotely? I'm guessing the port would be the one shown in the url when opening myphpadmin. But what would the host be? If anyone knows much appreciate the answer, If not I'll create a ticket and post the syntax here.<!--QuoteEnd--></div><!--QuoteEEnd--><br />Before you can connect to the MySQL server with any program, you have to give yourself (your home PC) permission to do so.<br /><br />In your CPanel, go to "MySQL Databases". Near the bottom of the page is a section titled "Access Hosts". Enter your home PC's IP address then click the "Add Host" button. (If you're not sure what your home IP address is, go to <a href="http://www.whatismyip.com/" target="_blank">whatismyip.com</a> in your browser.)<br /><br />In whatever MySQL client program you use, the hostname will be your (TCH-hosted) domain name, and the port is 3306 (which should be default).<!--content-->
Thank you so much David, fantastically helpful. I can now tinker away on my home machine and not have to refresh after each change. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /><!--content-->
You don't have to refresh with phpMyAdmin. It informs you of what changes it is going to make and what it has made.<!--content-->
The best, and most widely used, is phpMyAdmin. <a href="http://www.phpmyadmin.net" target="_blank">http://www.phpmyadmin.net</a><br />Curious as to why you put phpBB in the title ?<!--content-->
I use YourSQL for quick work/updates. It's ok (and free), although I don't think it's that much better than PHP MyAdmin. I had the chance to use NavCat once, and that's a very nice program if you want to pay the fees for it.<!--content-->
total choice provides you with phpMyAdmin in your control panel somewhere. Most hosts do.<!--content-->
I recommend <a href="http://www.mysql.com/products/administrator/" target="_blank">MySQL Administrator</a>. It's free, works on multiple operating systems and is made by the same folks that make MySQL. I haven't had the chance to work a lot with it but it seems to be pretty good. I don't think it's as feature packed as phpMyAdmin but for regular database administration it works just fine and it's faster than loading a webpage for each action you do.<!--content-->
<!--QuoteBegin-TCH-Raul+Mar 27 2005, 10:45 PM--><div class='quotetop'>QUOTE(TCH-Raul @ Mar 27 2005, 10:45 PM)</div><div class='quotemain'><!--QuoteEBegin-->I recommend <a href="http://www.mysql.com/products/administrator/" target="_blank">MySQL Administrator</a>.<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />Thanks I'll look into that. Interestingly I just found that TOAD have made a TOAD for Mysql so will download that and have a play as well.<br /><br /><!--QuoteBegin-TCH-Raul+Mar 27 2005, 10:45 PM--><div class='quotetop'>QUOTE(TCH-Raul @ Mar 27 2005, 10:45 PM)</div><div class='quotemain'><!--QuoteEBegin-->I don't think it's as feature packed as phpMyAdmin but for regular database administration it works just fine and it's faster than loading a webpage for each action you do.<br /><div align="right"><a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=121762"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />That is exactly what I'm after, I dont really need all thee bells and whistles - and certainly not loading a web page each time.<br /><br />Does anyone have any experience of accessing dbs remotely? I'm guessing the port would be the one shown in the url when opening myphpadmin. But what would the host be? If anyone knows much appreciate the answer, If not I'll create a ticket and post the syntax here.<br /><br />(it's lovely and sunny in England today! wooo hoooo)<br /><br />John<!--content-->
I have MySQL Administrator installed here at home - it's geared towards managing a MySQL server. Many of the tools it provides are not usable by you on TCH's SQL servers, because you won't have sufficient permission to use those functions.<br /><br />Depending on what you're wanting to do, the <a href="http://www.mysql.com/products/query-browser/" target="_blank">MySQL Query Browser</a> may meet your needs better (and it's also made by the people who make MySQL).<br /><br /><!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->Does anyone have any experience of accessing dbs remotely? I'm guessing the port would be the one shown in the url when opening myphpadmin. But what would the host be? If anyone knows much appreciate the answer, If not I'll create a ticket and post the syntax here.<!--QuoteEnd--></div><!--QuoteEEnd--><br />Before you can connect to the MySQL server with any program, you have to give yourself (your home PC) permission to do so.<br /><br />In your CPanel, go to "MySQL Databases". Near the bottom of the page is a section titled "Access Hosts". Enter your home PC's IP address then click the "Add Host" button. (If you're not sure what your home IP address is, go to <a href="http://www.whatismyip.com/" target="_blank">whatismyip.com</a> in your browser.)<br /><br />In whatever MySQL client program you use, the hostname will be your (TCH-hosted) domain name, and the port is 3306 (which should be default).<!--content-->
Thank you so much David, fantastically helpful. I can now tinker away on my home machine and not have to refresh after each change. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /><!--content-->You don't have to refresh with phpMyAdmin. It informs you of what changes it is going to make and what it has made.<!--content-->