Shulou(Shulou.com)06/01 Report--

Editor to share with you how to install and configure MySQL under Mac, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

First, you need to download

MySQL Community Server download address: https://dev.mysql.com/downloads/mysql/

Go to the MySQL download interface (https://dev.mysql.com/downloads/mysql/). If you use Mac OS to access it, you will choose the Mac OS X platform by default. The MySQL versions that are available on Mac OS are listed below. If you are using other platforms, just select it from the drop-down list of "Select Platform" options.

There are many versions of MySQL on Mac OS, some of which come by platform, such as 10.5 Universe 10.6, then 32-bit and 64-bit, which you choose according to your own system, and then the suffixes of .tar.gz and .dmg. Here I choose .dmg. Click the download on the right to download.

Then it jumps to another interface, which prompts you whether you need to register, directly select "No thanks,just take me to downloads!" at the bottom, and then it really jumps to the download interface, which lists a lot of servers for download. Choose a server to download and OK.

Double-click the pkg file to install all the way down, and remember to save the password in the last pop-up box (it is the password of your mysql root account)

Under normal circumstances, the MYSQL2.png installation is successful.

Only the installation is successful at this time, but additional configuration is required:

(1) enter the system preference settings

(2) Click mysql

(3) enable mysql service

At this point, typing the mysql-u root-p command on the command line will prompt that there is no commod not found, and we also need to add mysql to the system environment variable.

(1)。 Go to / usr/local/mysql/bin to see if there is a mysql in this directory, see pic6.

(2)。 Execute vim ~ / .bash_profile

To add the directory of mysql/bin to this file, see pic7:

PATH=$PATH:/usr/local/mysql/bin

When the addition is complete, press esc, and then enter wq to save.

Finally, enter source ~ / .bash_profile on the command line

Now you can log in to mysql through mysql-u root-p, which will ask you to enter your password, which is > fj... on pic3.

After logging in successfully, you can change your password with the following command

SET PASSWORD FOR 'root'@'localhost' = PASSWORD (' mysql123456')

The above is all the contents of the article "how to install and configure MySQL under Mac". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.