Note that we are connected using the root user, which should only be used for administration purposes.ĭay to day use of a database should be done using a normal user. Then set a name for the connection, and enter “root” and the password you set previously:Ĭlick Connect, and you should be connected to MySQL! I know there are macOS, Windows and Linux versions.Ĭlick “Create a new connection…” and select MySQL in the list: It comes with a free trial that’s perfect for our usage, because it’s not time-based but rather it limits the amount of concurrent connections you can make to the database.ĭownload it from. The easiest way to install these is using Homebrew (https://brew. You will need to type the root user password after you run this command, and once you are done you should see this screen:Ī great GUI (graphical) software we can use to interact with a SQLite database is TablePlus. For installing DBD::mysql you need to have the libssl header files and the mysql client libs. Now you can connect to the server using the command: mysql -u root -p It’s up to you to decide which one you prefer. This will start MySQL and will keep it running until the computer is shut down, or until you run: rver stop You can also avoid this daemon mode (that’s what we call programs that always run in the background and restart when the computer is restarted) by running: rver start To stop this from happening, and also to immediately stop MySQL. Since we used brew services start mysql to start MySQL, your Mac will re-start it at reboot. The procedure can take a while, but it gives a lot of power to make sure you get the best defaults out of the box: By default the server comes without a root password, so we need to make sure it’s protected. You can now start the MySQL server by running: brew services start mysql The above command should take a while, then print something like this:

On macOS, you can install MySQL easily using Homebrew. Step by step instructions to install MySQL on macOS using Homebrew

Brew install mysql client only