Running MySQL

Discussion in 'Mac Programming' started by KingCyrusIII, Aug 26, 2015.

  1. KingCyrusIII macrumors newbie

    KingCyrusIII

    Joined:
    Apr 10, 2015
    #1
    Hi folks, thanks for looking into this.

    I'm trying to run MySQL. I downloaded the dmg file, installed, and started it in System Preferences.

    Where do I go from here? Where's the user interface?
     
  2. kryten2 macrumors 6502a

    Joined:
    Mar 17, 2012
    Location:
    Belgium
    #2
  3. 960design macrumors 68030

    Joined:
    Apr 17, 2012
    Location:
    Destin, FL
    #3
    If you are running MySQL for local testing, then I would recommend MAMP.
    https://www.mamp.info/en/
     
  4. KingCyrusIII thread starter macrumors newbie

    KingCyrusIII

    Joined:
    Apr 10, 2015
    #4
    Thanks. I was aware that I need a third party GUI to run on top of MySQL. I was inquiring about the UI that comes with it, that is, the command line.

    I have Sequel-Pro installed. But how do I launch MySQL? Is it merely by Starting it on System Preferences?
     
  5. riverfreak macrumors demi-god

    riverfreak

    Joined:
    Jan 10, 2005
    Location:
    Thonglor, Bangkok
    #5
    You don't need a third party GUI. You start MySQL on OSX typically via the preference pane. Connect to the server by

    $ mysql

    I can't remember if there is a default user and password for new installs.
     
  6. IHelpId10t5 macrumors 6502

    Joined:
    Nov 28, 2014
    #6
    What you are looking for is MySQL Workbench (https://dev.mysql.com/downloads/workbench/).

    You certainly don't need a GUI for using MySQL but having a GUI is nice when getting started.
     
  7. KingCyrusIII thread starter macrumors newbie

    KingCyrusIII

    Joined:
    Apr 10, 2015
    #7
    Well, right now I'm just trying to get the regular UI that comes with the software to run.

    I'll worry about the GUI afterwards.
     
  8. theluggage macrumors 68040

    Joined:
    Jul 29, 2011
    #8
    You start and stop the MySQL server from the preferences pane. There's nothing to see when it is running.

    To run the various clients and utilities like "mysql" and "mysqladmin", you use the OS X Terminal app and follow the instructions at e.g. http://dev.mysql.com/doc/refman/5.7/en/invoking-programs.html

    If you get 'command not found' errors, then you need to follow the instructions here: http://apple.stackexchange.com/ques...h-variable-to-resolve-mysql-command-not-found

    ...I can't remember if the installer does this automatically.

    Once you get to the stage where you're getting errors from MySQL about non-existent databases/users, missing parameters etc. then you're in business and can start following any generic 'getting started with MySQL' guide.
     
  9. burne macrumors 6502

    burne

    Joined:
    Jul 4, 2007
    Location:
    Haarlem, the Netherlands
    #9
  10. superscape macrumors 6502a

    superscape

    Joined:
    Feb 12, 2008
    Location:
    East Riding of Yorkshire, UK
    #10
    Once you have it running nicely from the command line then you might want to look at something like Sequel Pro for a simple GUI. Of course, nothing wrong with doing it all from the Terminal if you prefer...
     
  11. ocabj macrumors 6502a

    ocabj

    Joined:
    Jul 2, 2009
    #11
    Be sure to follow the post-install procedures: https://dev.mysql.com/doc/refman/5.7/en/postinstallation.html

    When the core mysql database is initialized (either by the installer, or by hand post-install), the mysql root user will have an empty password, and can only be logged in via localhost. So login to mysql as root, change the password, then you can start creating users and databases, and delegating rights to those databases to those users.
     

Share This Page