Configuration of MySQL database under Mac

Source: Internet
Author: User

Here's a note.

Before using the Brew install MySQL installation on the Mac, but found that the password is not good to modify after the installation, search the Internet found under the MAC using the command line to install MySQL is really a lot of problems, this is far less convenient than Ubuntu.

Online advice is to go to the MySQL official website to download, the official version is used here.

1. Download to MySQL website

http://dev.mysql.com/downloads/mysql/download it on this page, then install and drag.

2. Start MySQL

Click Preferences at the bottom to see the MySQL configuration.

Such as:

And:

3. Start MySQL at the command line

After the installation is complete, we can no longer command the line to start MySQL.

You can enter in the shell:

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

In order to be effective, we keep it in ~/.ZSHRC. (I'm using zsh)

4. Reset Password

MySQL current version of the default password I do not know, some articles said that the password is also root, I tried the next is not OK.

The MySQL version I am using is:

Server version:5.6.23 MySQL Community Server (GPL)

The Mac version is the latest Yosemite 10.10.2

Here, reset the password using:

/usr/local/mysql/bin/mysqladmin-u Root Password New password

5. MySQL Workbench can be installed and also downloaded from official website.

The configuration of MySQL under Mac is basically complete.

Configuration of MySQL database under Mac

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.