Help with MySQL

[ercw]

I installed a binary Package of Mysql on 10.3.9
I also have a copy of CocoaMySQL.

question1: is there a pill that I can take to make me smarter?
Question2: How can I test mySQL to make sure it's working?
#3: is there a specific command I need to do in the terminal?
#4: In CocoaMySQL, I'm unable to setup a connection to my localhost, I'm assuming that I need to use my computer name and my localhost password?

Please help a dummie

 

[floyde]

question1: is there a pill that I can take to make me smarter?

There's one, but it'll also make you see things blue. And it has some other, err... side effects

I can't remember exactly, but I think when you first install MySql, you can login using the user root and a blank password (if it's not a blank password then it's your OS X admin password). After that first login, you have to set a new password for root.

Also, try using MySql Administrator or MySql Query Browser to see if you can login with them.

 

[ercw]

Also, try using MySql Administrator or MySql Query Browser to see if you can login with them.

Where do I find this?

 

[floyde]

Where do I find this?

In the downloads page of MySql's website. They're in the MySQL Tools section.

 

[ercw]

In the downloads page of MySql's website. They're in the MySQL Tools section.

dude! thank you
I can start to see the tunnel at the end of the light!

 

[ldenman]

i'd check out navicat for a good mysql database manager.
Sure, its a little more difficult than cocoamysql, but it feels a lot better.

also, i had some problems with cocoamysql with dumping databases and what not. Just check out navicat.

 

[ercw]

Ok MySQL is working, just a coupla questions

In my Localhost, where does MySQL stores the databases?
Looks like my SQLAdmin lets me select a path. Should the databases live in the root diectory of the web site? (local site folder)
May sound like a dumb question but I'm taking baby steps here.
Thank you

Eric

 

[floyde]

Should the databases live in the root diectory of the web site? (local site folder)

Nope, that wouldn't be too secure or practical. I recomment that you use the default directory that was set by MySql to avoid any security or technical issues (setting up the proper permissions, etc.). You will almost never have the need to work with the physical database files themselves, and pretty much all you will need to do to them can be done via MySql Admin (deleting, renaming, etc.).

 

[ercw]

Thanks

Nope, that wouldn't be too secure or practical. I recomment that you use the default directory that was set by MySql to avoid any security or technical issues (setting up the proper permissions, etc.). You will almost never have the need to work with the physical database files themselves, and pretty much all you will need to do to them can be done via MySql Admin (deleting, renaming, etc.).

Thank you very much floyde, you seem very knowledgable

Eric