Installing and running MySQL on macOS with errors resolved

This article is based on macOS High Sierra version: 10.13.4 and hopefully can work for all MacBooks having OSX+ version.

3. After successful installation go to System Preferences and search mysql

when you open that, you will see the mysql server is already running

Now, this is one way to start and stop the mysql server manually. If you are looking to do the same using command prompt then follow bellow steps.

4. Open terminal and type

You’ll probably get error “-bash: mysql.server start: command not found” or something similar. This is because the path(/usr/local) where the mysql is being installed is not written in the .profile or .bashrc (contains a series of configurations for the terminal session).

5. To solve above error, without figuring which of

should be edited, the easiest way is to type

and add the path(s) you want here, one per line. For our installation we’ll add two mysql paths as shown in figure.

/usr/local/mysql/bin consists:

/usr/local/mysql/support-files consists:

6. Now restart your terminal and again type

Now, you may probably get permission denied error, which looks like this.

7. Don’t worry this is just a permission error and can be easily solved by writing sudo(gives super user access) in front of the command like this:

Yay!! We did it. Now, to stop mysql server, type

You can also restart an already running server by typing

To check current server status, type

8. Type the following command and enter the password for root that I asked you to remember in the start to enter mysql console as a root user.

9. Let me give you a little demo of structured query language. Type quit to exit mysql console.

Related posts:

Se ti piacciono le belle fotografie e i succosi BAN, guarda questo! Banano ha creato un evento con la speranza di ottenere un meraviglioso collage geografico. La famiglia di Banano è divenuta…

Art presents itself in various ways. For Memphis artist Maysey Craddock, the reclamation of abandoned buildings and structures by nature captured her interests as well. A display of her work — Ruin…

Video games can elicit an almost infinite number of emotions, but none compares to the elation a player feels when they get their hands on the best, brightest or simply most fun weapons a game has to…