[adam c]

What do you use?
I'm just starting out now and the method outlined in the book I'm learning from just isn't working for me. One of the developers mentioned using the official MySQL GUI application. Anyone else use this or something else?
Cheers.

[Larixk]

plain sql or phpMyAdmin

[adam c]

Cheers Larixk. Yeah I've tried using plain sql it's just difficult with this book. I think I need to maybe change the book I'm learning from.
Got any recommendations for that? The one I'm using at the moment is PHP & MySQL for Dummies, which is really clear for the PHP side but is making it confusing on the MySQL side of things.

[d*d]

php myAdmin is all I've ever used

[haku]

phpmyAdmin is all I've ever used as well, but I've never felt the need to use anything else - its pretty straightforward and easy to use.

[MikeMackay]

I'd definitely recommend phpMyAdmin too, it's great to work with, especially when you're starting out in the world of MySQL. I've also used the MySQL command line too, but not very often...

- Mike

[adam c]

cheers guys.

[proc355]

use the fricking command line already—then you'll actually know what you're doing; since you'll be writing sql to query your db anyway, you may as well learn how through the console, it gives you decent feedback.

phpMyAdmin is all well and good if that's all the access your host gives you but you should set up a local server so you can test your queries etc - phpMyAdmin is as slow as shit for playing in.

…and RTFM, the MySQL manual is top quality and has a good tutorial.

gui's indeed; more hassle than they are worth.

[iblastoff]

its not like you can't run your own sql queries in phpmyadmin. extremely handy since it displays the query as well when you perform an action via the gui.

[proc355]

Originally Posted by iblastoff

its not like you can't run your own sql queries in phpmyadmin

did i say you couldn't?

[adam c]

Originally Posted by proc355

use the fricking command line already—then you'll actually know what you're doing; since you'll be writing sql to query your db anyway, you may as well learn how through the console, it gives you decent feedback.

phpMyAdmin is all well and good if that's all the access your host gives you but you should set up a local server so you can test your queries etc - phpMyAdmin is as slow as shit for playing in.

…and RTFM, the MySQL manual is top quality and has a good tutorial.

gui's indeed; more hassle than they are worth.

Yeah I have been using the command line, it's just this book (or manual) tells you to build some weird web interface and use that to send querys and I was wondering if there was anything better.
I'll give the actual MySQL manual a go though.

[iblastoff]

Originally Posted by proc355

did i say you couldn't?

so in other words, theres no benefit to using the CLI instead. especially for a newbie.

[Hunch]

For a number of years, I created databases through the code. It always seemed pretty normal since you often needed a database initialization script to wipe/rebuild the database when testing/developing, but these days I use phpMyAdmin like everyone else.

[Larixk]

Originally Posted by iblastoff

so in other words, theres no benefit to using the CLI instead. especially for a newbie.

yes there is: it's way more productive to work with just a keyboard than with keyboard and mouse.

[haku]

I find it the most productive to use both. I love my shortcuts, but depending on what you are clicking, a mouse can be faster.

[proc355]

Originally Posted by iblastoff

so in other words, theres no benefit to using the CLI instead. especially for a newbie.

how did you extrapolate that?

there's no advantage typing the same commands in to phpMyAdmin—especially when it's a lot slower to give you feedback. a far more frustrating experience if you're a ‘newbie’ imo

by the nature of these tools, there is never anything you can do via the cli that can be done via a gui—the opposite is not true.

perhaps you would care to elaborate why you feel clicking a submit button is easier than hitting return?

i dont even use mysql much any more (i use postgresql, or sqlite for simpler things) but i'ts cli is one of the best i've used.

[tofallinlove]

i agree php my admin is the savior

[cjgraphix]

CocoaMySQL for my local server , and then phpMyAdmin for the hosted server. I just export everything from my local, so it's just running a query in phpMyAdmin.

[Dusteh]

Navicat is great.

[.sleep]

CocoaMySQL for all sql stuff.