Help with MySQL

Discussion in 'Web Design and Development' started by ercw, May 19, 2006.

  1. ercw macrumors regular

    Joined:
    May 4, 2006
    #1
    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
     
  2. floyde macrumors 6502a

    floyde

    Joined:
    Apr 7, 2005
    Location:
    Monterrey, México
    #2
    There's one, but it'll also make you see things blue. And it has some other, err... side effects :D

    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.
     

    Attached Files:

  3. ercw thread starter macrumors regular

    Joined:
    May 4, 2006
    #3
    Where do I find this?
     
  4. floyde macrumors 6502a

    floyde

    Joined:
    Apr 7, 2005
    Location:
    Monterrey, México
    #4
    In the downloads page of MySql's website. They're in the MySQL Tools section.
     
  5. ercw thread starter macrumors regular

    Joined:
    May 4, 2006
    #5

    dude! thank you
    I can start to see the tunnel at the end of the light!
     
  6. ldenman macrumors regular

    Joined:
    Jul 20, 2005
    #6
    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.
     
  7. ercw thread starter macrumors regular

    Joined:
    May 4, 2006
    #7
    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
     
  8. floyde macrumors 6502a

    floyde

    Joined:
    Apr 7, 2005
    Location:
    Monterrey, México
    #8
    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.).
     
  9. ercw thread starter macrumors regular

    Joined:
    May 4, 2006
    #9
    Thanks

    Thank you very much floyde, you seem very knowledgable

    Eric
     

Share This Page