cfusion2k 0 Report post Posted January 31, 2005 May I know what is a good GUI for manipulating mysql? Perhaps in the league of mysqlcc will be a good one Thanks for the help.And btw, who uses GUI for their Mysql here? I know that some people like to use console to type Share this post Link to post Share on other sites
iGuest 3 Report post Posted January 31, 2005 May I know what is a good GUI for manipulating mysql? Perhaps in the league of mysqlcc will be a good one Thanks for the help. And btw, who uses GUI for their Mysql here? I know that some people like to use console to type <{POST_SNAPBACK}> I prefer console, doing it in PHP or SQL scripts, depends whether I'm working in the program or not at the time. Other than that, there's the web based alternative phpMyAdmin which is quite good. I haven't really looked into GUI's for MySQL although I've heard good feedback for SQLyog, maybe give that a go? Point and click methods are slower to me and there's really no need for me to use a frontend when I can plan everything out in advance, even just writing everything I want to happen in a text file and saving it for later references to see what structure I used in creating it. Well hopefully you find something that is suited to your needs. MC Share this post Link to post Share on other sites
matty_023 0 Report post Posted January 31, 2005 I’ve tried using phpMyAdmin, but in the end found console is much easier and faster. If you know mySQL I suggest using console, it means you can write your code whether you have internet access at the time or not. If you don’t know mySQL well it isn’t that difficult to learn, I learnt in a few days, it’s relatively simple compared to most other programming operations. Once you learn it, it is well worth it. After which you can even write on paper what you wish to implement if you are stuck somewhere waiting. Sometimes back to the basics is just easier. Share this post Link to post Share on other sites
miCRoSCoPiC^eaRthLinG 0 Report post Posted February 1, 2005 I'd go along with the others - console access is way much faster and easier than any of the GUI's. Alternatively try the new MySQL Administrator + Query Browser from mysql.com - the deprecated mysqlcc has been now broken down into two components. Ummm... other than that - you do have a few good ones, for example, EMS MySQL Manager/Importer/Exported/Query Browser - a suite of 4 very handy tools - unfortunately they are not free. But if you are desperate enough, you could try downloading them from https://en.usenet.nl/?utm_medium=AFSI&utm_campaign=408878&utm_source=AF_TA_83028&utm_content=0_1 (do a search for 'SQL' once you get to the site). Share this post Link to post Share on other sites
arunkumarhg 0 Report post Posted February 17, 2005 Hi,There are lot of open source tools available under GNU GPL license, but i preffer you to go for MySqlAdmin from mysql.com, and with mysql5.0 u will get a built in admin tool.Search the net with kweyword "MySql Admin tool" And once again it depends on either do u need a web based tool or a standalone one.CheersArun Share this post Link to post Share on other sites
marijnnn 0 Report post Posted February 17, 2005 i agree on mysql admin toolbut a long time ago, i installed php & mysql & apache with winlamp, an auto installer (long ago, when i was a noob) and they had a great tool included. you have to pay for it, but the older versions were free and did their job just as wel, and still run fine on winxp. i'll have a look if i still have it somewhere but check the mysql.org site, they have some nice tools.still, i wish i could remember the tool ok: i found it: it's mysql front:http://forums.xisto.com/no_longer_exists/nice tool! really! i remeber their version 2.5 being free. maybe you should google the net for that version. or download winlamp, i think they still include that version!edit: just checked the winlamp site ( http://forums.xisto.com/no_longer_exists/) and they do include 2.5if you can't find it apart, it's word the 90mb download Share this post Link to post Share on other sites
Josh_Jpn 0 Report post Posted February 21, 2005 I don't do much coding in MySql yet but I find it's easier to follow your own logic if you use console. Phpadmin seems ok also. Share this post Link to post Share on other sites
miCRoSCoPiC^eaRthLinG 0 Report post Posted February 22, 2005 I don't do much coding in MySql yet but I find it's easier to follow your own logic if you use console. Phpadmin seems ok also. <{POST_SNAPBACK}> Yups I agree to that - console access allows you to deal with problems much faster - and you get a good dose of the real HANDS-ON MySQL.. You cannot learn something through a GUI - if you REALLY WANT TO LEARN. In the end the gui will bend you down on your knees and make you go running back to the console.. Nothing like the console... Long live the console.... and linux (there, I did it again..lol) Share this post Link to post Share on other sites
marijnnn 0 Report post Posted February 22, 2005 yeah, but gui apps are easier to add data.search google for mysql front 2.5it's freethere's a linux app too that is really good, but i forgot the name. Share this post Link to post Share on other sites
amkint 0 Report post Posted February 23, 2005 i use the mysql prompt or sometimes phpmyadmin. phpmyadmin is good.... easy and fast. Share this post Link to post Share on other sites
k221405241470 0 Report post Posted February 23, 2005 Mysql CC is very good, phpmyadmin too but as they said it's better to use the console, you've the realy control of the database and then why do you want to use a gui that need a lot of resources when the console need only some kb of ram and almost nothing of cpu?Php scripts are useful too, you've to create a scripts to insert directly SQL string in the db Share this post Link to post Share on other sites
thedevil 0 Report post Posted February 28, 2005 i use phpmyadmin and its easy to manipulate mysql database server...i have not tried others yetso cant say about others.... Share this post Link to post Share on other sites
wwheeler 0 Report post Posted March 4, 2005 Which Platform are you wondering about? For web-based acces there is nothing better than MyPHPAdmin... For PC-based access, I still uses MySQLGui, it can be found here There are a bunch of different PO-based guis listed and downloadable from the MYSql Download page, here. I've not really had any experiance with any other GUI's, but I'm sure some exist... Some Relevant Results from a Google on "MySQL GUIs": MySQL Control Center Downloads MySQL-Front MySQL Administrator MySQLGUI NavicatThe Whole list of results can be found here Share this post Link to post Share on other sites
moonwitch1405241479 0 Report post Posted March 5, 2005 Well, I don't have much hands on experience in MySQL, even though I do have it on my pc to look around in it. I also have phpMyAdmin which I found to be pretty ok, I tried the MySQL Admin and Query Browser and was completely lost and utterly confused.So I would have to agree to go for the command line option And indeed, you will learn much more about MySQL through the commandline (at one point we did get this course in school - too bad I didn't pay attention )The commandline is also pretty straight forward, and there is a good help function in there as well I just found the GUI made it more complex than it is in all honesty. Share this post Link to post Share on other sites