mysql linux install brew_My SQL 开发笔记《Mac、Linux 上安装部署 My SQL5.7》

MacOS Mojave 10.14.6

CentOS Linux release 7.3.1611 (Core) x86_64

Client mysql Ver 14.14 Distrib 5.7.28, for osx10.14 (x86_64) using EditLine wrapper

Remote mysql Ver 14.14 Distrib 5.7.28, for Linux (x86_64) using EditLine wrapper

一、Mac 安装 My SQL

1.安装 mysql

$ brew install mysql@5.7

2.安装brew

$ brew tap homebrew/services

3.配置环境变量

# ~/.zshrc

export PATH=/usr/local/opt/mysql@5.7/bin:$PATH

重启终端或 source .zshrc 使之生效

运行服务

4.加载和启动 MySQL 服务

$ brew services start mysql@5.7

5.检查MySQL服务是否已加载

$ brew services list

6.强制链接

brew link mysql@5.7 --force

7.停止 MySql 服务

brew services stop mysql@5.7

8.修改密码

mysql -u root -p password newpass

9.新密码登录

mysql -u root -p

彻底删除 MySql

ps -ax | grep mysql

stop and kill any MySQL processes

brew remove mysql

brew cleanup

sudo rm /usr/local/mysql

sudo rm -rf /usr/local/var/mysql

sudo rm -rf /usr/local/mysql*

sudo rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

sudo rm -rf /Library/StartupItems/MySQLCOM

sudo rm -rf /Library/PreferencePanes/My*

launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

edit /etc/hostconfig and remove the line MYSQLCOM=-YES-

rm -rf ~/Library/PreferencePanes/My*

sudo rm -rf /Library/Receipts/mysql*

sudo rm -rf /Library/Receipts/MySQL*

sudo rm -rf /private/var/db/receipts/*mysql*

二、Linux 安装 My SQL

8.配置 yum 源

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

yum localinstall mysql57-community-release-el7-11.noarch.rpm

9.检查 mysql 源是否安装成功

yum repolist enabled | grep "mysql.*-community.*"

10.安装 MySQL

yum install -y mysql-community-server

11.启动 MySQL 服务

systemctl start mysqld

12.用systemctl status查看 MySQL 状态

systemctl status mysqld

13.设置开机启动

systemctl enable mysqld

# 重载所有修改过的配置文件

systemctl daemon-reload

步骤4：Linux 配置账户

14.MySQL 默认密码在/var/log/mysqld.log文件中。使用 grep 命令找到日志中的密码

grep 'temporary password' /var/log/mysqld.log

15.首次通过初始密码登录后，使用以下命令修改密码

shell> mysql -uroot -p

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

以后通过 update set 语句修改密码

mysql> use mysql;

mysql> update user set password=PASSWORD('MyNewPass5!') where user='root';

mysql> flush privileges;

16.添加远程账户。默认只允许root帐户在本地登录，如果要在其它机器上连接mysql，必须添加一个允许远程连接的帐户

mysql> GRANT ALL PRIVILEGES ON *.* TO 'zhangsan'@'%' IDENTIFIED BY 'Zhangsan2018!' WITH GRANT OPTION;

17.设置默认编码为 utf8

mysql 安装后默认不支持中文，需要修改编码。修改/etc/my.cnf配置文件，在相关节点(没有则自行添加)下添加编码配置，如下：

[mysqld]

character-set-server=utf8

[client]

default-character-set=utf8

[mysql]

default-character-set=utf8

18.重启mysql服务，查询编码

shell> systemctl restart mysqld

shell> mysql -uroot -p

mysql> show variables like 'character%';

步骤5：本地连接

本地数据库可视化工具推荐

3306 MySQL 安装完毕后默认端口，本地连接默认没有密码。Linux 服务器版本必须使用远程账户，且需要密码

图书你所遇到的问题，这里都有答案​gist.github.comCentOS7 下 MySql 5.7 安装方法​www.jianshu.com