phpMyAdmin and Navicat
Came across a thread about a program called Navicat that is a GUI to access mySQL databases.
Well, the little I have played with it, it seems nice and robust. However, it (in default install, might be able to change it) allows you to just click on any field/row and edit the value, move out of the field and it updates the database (similar to using MS Access). Too easy for people not knowing to go edit info lol. For things like user databases, i prefer to have to hit EDIT on the row update the fields, and then save it. I prefer the extra steps.
Was wondering if anyone else here has used it. I'm trying the 30 day trial. You can find out more info at http://www.navicat.com/
Now, one gripe I do have about about phpMyAdmin. I created a user specifically for this program to use (as you have to make a mySQL user that can access from remote IPs).
Well when I was done for the day, I went in and told it to drop the user I created. You know how on just about anything else when you go to delete data, it first asks you to confirm? Well not on a user. I selected the user, hit DROP USER, and was expecting something to pop up and confirm it... Nope.... just deleted the user!
Imagine if I would have accidently clicked on the "root" user!
Anyhow, my 2 thoughts for the day.
-Greg
teammatt3 posted this at 02:41 — 21st November 2007.
He has: 2,102 posts
Joined: Sep 2003
I had it for 30 days too. I used the ms sql to mysql converter since the mysql driver blows up when it comes across large varchar fields in ms sql. Other than that I didn't use it.
You know you can use MS Access with MySQL? You get most of the features of Access with it getting the data from a MySQL db. It's nice.
I've done that a few times, back when I didn't really understand how the MySQL user system worked, it doesn't end well.
pr0gr4mm3r posted this at 22:26 — 21st November 2007.
He has: 1,502 posts
Joined: Sep 2006
Some other client-side programs include MySQL Query Browser & MySQL Administrator.
carloncho posted this at 23:00 — 8th February 2008.
They have: 17 posts
Joined: Jan 2008
I use the TOAD for MySQL. Its free and proffessional. Test it.
Greg K posted this at 01:51 — 9th February 2008.
He has: 2,145 posts
Joined: Nov 2003
well i was going to try it, but the installer has been stuck on the same thing for 10 minutes.... and won't even let me cancel it, so i guess I'll have to kill it.
I kid you not, right after typing that, it FINALLY continued (and this is not a weak laptop!)
Not too bad, if i would have found it before I found Navicat (and paid for it
, would probably use it.
Thanks for the info, btw, for others, here is a link: http://www.toadsoft.com/
-Greg
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.