Running MySQL

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

  1. KingCyrusIII macrumors newbie


    Apr 10, 2015
    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

    Mar 17, 2012
  3. 960design macrumors 68030

    Apr 17, 2012
    Destin, FL
    If you are running MySQL for local testing, then I would recommend MAMP.
  4. KingCyrusIII thread starter macrumors newbie


    Apr 10, 2015
    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


    Jan 10, 2005
    Thonglor, Bangkok
    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

    Nov 28, 2014
    What you are looking for is MySQL 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


    Apr 10, 2015
    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

    Jul 29, 2011
    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.

    If you get 'command not found' errors, then you need to follow the instructions here:

    ...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


    Jul 4, 2007
    Haarlem, the Netherlands
  10. superscape macrumors 6502a


    Feb 12, 2008
    East Riding of Yorkshire, UK
    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


    Jul 2, 2009
    Be sure to follow the post-install procedures:

    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