macOS Running MySQL

[KingCyrusIII]

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?

 

[kryten2]

On all platforms except Windows, MySQL ships with no GUI tools to administer MySQL databases or manage data contained within the databases. Users may use the included command line tools,[21][22]or install MySQL Workbench via a separate download. Many third party GUI tools are also available.

You can start by reading some documentation or even one of the numerous online tutorials.

Info : https://en.wikipedia.org/wiki/MySQL and http://dev.mysql.com/doc/

 

[960design]

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?

If you are running MySQL for local testing, then I would recommend MAMP.
https://www.mamp.info/en/

 

[KingCyrusIII]

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?

 

[riverfreak]

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.

 

[IHelpId10t5]

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?

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.

 

[KingCyrusIII]

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.

 

[theluggage]

Well, right now I'm just trying to get the regular UI that comes with the software to run.

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.

 

[burne]

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

 

[superscape]

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

 

[ocabj]

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.