Tutorial on installing mysql5.7.18 on mac os10.12

Tutorial on installing mysql5.7.18 on mac os10.12

I searched the entire web and found all kinds of pitfalls, which did not solve my problem. Finally figured it out myself.

After installation, a temporary password will pop up, copy it. If you click too quickly, you will have another chance in the notification bar, but if you click too quickly in the notification bar, you can only type by looking at your hand. If the notification bar is gone, the fastest way is to reinstall it. (Uninstall before reinstalling)

Then open the console and enter mysql. It will prompt command not found . Then enter

alias mysql=/usr/local/mysql/bin/mysql
alias mysqladmin=/usr/local/mysql/bin/mysqladmin

Give it an alias. Note that you need to re-run the above command after closing the terminal (if you want it to be permanent, you can save it to a bash file)

Then enter mysqladmin -u root password *** (replace *** with the temporary password)

Another error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Baidu has a lot of information that requires Mac OS to enable the root user (search for the method to enable it yourself)

After opening, enter su root

Then enter the root password to enter root mode

Then enter mysqladmin -u root password *** (replace *** with the temporary password)

The result is command not found again

Finally in root mode

sh-3.2# alias mysql=/usr/local/mysql/bin/mysql
sh-3.2# alias mysqladmin=/usr/local/mysql/bin/mysqladmin
sh-3.2# mysqladmin -u root -p password

Then enter the temporary password

Then you are prompted to enter a new password

Finally complete the installation.

Summarize

After installing MySQL, set the system preferences to start the service

Then enter root mode

sh-3.2# alias mysql=/usr/local/mysql/bin/mysql
sh-3.2# alias mysqladmin=/usr/local/mysql/bin/mysqladmin
sh-3.2# mysqladmin -u root -p password

Enter temporary password

Enter new password

Enter the confirmation password

OK

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.

You may also be interested in:
  • MySQL 5.7.18 download and installation process detailed instructions
  • Tutorial on installing mysql5.7.18 on windows10
  • Detailed tutorial for installing mysql5.7.18 on centos7.3
  • mysql5.7.18.zip Installation-free version configuration tutorial (windows)
  • Detailed tutorial on installing MySQL 5.7.18 under CentOS 6.5
  • Alibaba Cloud Centos7.3 installation mysql5.7.18 rpm installation tutorial
  • Windows system mysql5.7.18 installation graphic tutorial
  • Detailed tutorial on the free installation version of MySQL 5.7.18 on Linux
  • CentOS 6.4 MySQL 5.7.18 installation and configuration method graphic tutorial
  • MySQL 5.7.18 MSI Installation Graphics Tutorial

<<:  Use the sed command to modify the kv configuration file in Linux

>>:  Detailed explanation of Vue form binding and components

Recommend

How to change $ to # in Linux

In this system, the # sign represents the root us...

Correct way to load fonts in Vue.js

Table of contents Declare fonts with font-face co...

Vue3.0 handwriting magnifying glass effect

The effect to be achieved is: fixed zoom in twice...

Summary of the unknown usage of "!" in Linux

Preface In fact, the humble "!" has man...

Detailed explanation of grep and egrep commands in Linux

rep / egrep Syntax: grep [-cinvABC] 'word'...

Implementation of Docker to build private warehouse (registry and Harbor)

As more and more Docker images are used, there ne...

Detailed Analysis of Event Bubbling Mechanism in JavaScript

What is bubbling? There are three stages in DOM e...

Complete step record of vue encapsulation TabBar component

Table of contents Implementation ideas: Step 1: C...

How to Install Oracle Java 14 on Ubuntu Linux

Recently, Oracle announced the public availabilit...

Install MySQL5.5 database in CentOS7 environment

Table of contents 1. Check whether MySQL has been...

Copy the contents of one file to the end of another file in linux

Problem description: For example, the content of ...

Tips for optimizing MySQL SQL statements

When faced with a SQL statement that is not optim...