Mac下使用homebrew安装配置mysql

Love The Way You Lie 2022-04-18 02:08 1517阅读 0赞

步骤：

一、安装homebrew

二、安装mysql

三、配置自启动

四、修改mysql密码

五、创建my.cnf配置文件

一、安装homebrew

homebrew是macOS缺失的软件包管理器，譬如可以下载mysql、maven等等。

安装方法：

/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"  
将以上命令粘贴至终端。  
homebrew更多详情请查看官网：  https://brew.sh/index\_zh-cn.html

二、安装mysql

$ brew install mysql

三、配置自启动

$ mkdir -p ~/Library/LaunchAgents

$ ln -sfv /usr/local/opt/mysql/\*.plist ~/Library/LaunchAgents

$ find /usr/local/Cellar/mysql/ -name "homebrew.mxcl.mysql.plist" -exec cp \{\} ~/Library/LaunchAgents/ \\;

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

四、修改mysql密码

1.先启动mysql服务

$ mysql.server start

2.继续执行mysql\_secure\_installation

cometdeMacBook-Pro:~ comet  
$ mysql\_secure\_installation  
   
Securing the MySQL server deployment.  
   
Connecting to MySQL using a blank password.  
   
VALIDATE PASSWORD PLUGIN can be used to test passwords  
and improve security. It checks the strength of password  
and allows the users to set only those passwords which are  
secure enough. Would you like to setup VALIDATE PASSWORD plugin?  
   
Press y|Y for Yes, any other key for No: N   // 这个选yes的话密码长度就必须要设置为8位以上，但我只想要6位的  
Please set the password for root here.  
   
New password:            // 设置密码  
   
Re-enter new password:     // 再一次确认密码  
By default, a MySQL installation has an anonymous user,  
allowing anyone to log into MySQL without having to have  
a user account created for them. This is intended only for  
testing, and to make the installation go a bit smoother.  
You should remove them before moving into a production  
environment.  
   
Remove anonymous users? (Press y|Y for Yes, any other key for No) : Y    // 移除不用密码的那个账户  
Success.  
   
   
Normally, root should only be allowed to connect from  
'localhost'. This ensures that someone cannot guess at  
the root password from the network.  
   
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : n  
   
 ... skipping.  
By default, MySQL comes with a database named 'test' that  
anyone can access. This is also intended only for testing,  
and should be removed before moving into a production  
environment.  
   
   
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y  
 - Dropping test database...  
Success.  
   
 - Removing privileges on test database...  
Success.  
   
Reloading the privilege tables will ensure that all changes  
made so far will take effect immediately.  
   
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y  
Success.  
   
All done!  
五、创建my.cnf配置文件  
1.首先需要知道系统是按如下顺序去找my.cnf：

i.    /etc/my.cnf  
ii.   /etc/mysql/my.cnf  
iii.  /usr/local/etc/my.cnf  
iv.  ~/.my.cnf

2.所以就在/etc下创建my.cnf

$ cd /etc

$ sudo vim my.cnf

配置文件内容如下：

\# Example MySQL config file for medium systems.  
\#  
\# This is for a system with little memory (32M - 64M) where MySQL plays  
\# an important part, or systems up to 128M where MySQL is used together with  
\# other programs (such as a web server)  
\#  
\# MySQL programs look for option files in a set of  
\# locations which depend on the deployment platform.  
\# You can copy this option file to one of those  
\# locations. For information about these locations, see:  
\# http://dev.mysql.com/doc/mysql/en/option-files.html  
\#  
\# In this file, you can use all long options that a program supports.  
\# If you want to know which options a program supports, run the program  
\# with the "--help" option.  
\# The following options will be passed to all MySQL clients  
\[client\]  
default-character-set=utf8  
\#password = your\_password  
port = 3306  
socket = /tmp/mysql.sock  
\# Here follows entries for some specific programs  
\# The MySQL server  
\[mysqld\]  
character-set-server=utf8  
init\_connect='SET NAMES utf8  
port = 3306  
socket = /tmp/mysql.sock  
skip-external-locking  
key\_buffer\_size = 16M  
max\_allowed\_packet = 1M  
table\_open\_cache = 64  
sort\_buffer\_size = 512K  
net\_buffer\_length = 8K  
read\_buffer\_size = 256K  
read\_rnd\_buffer\_size = 512K  
myisam\_sort\_buffer\_size = 8M  
character-set-server=utf8  
secure\_file\_priv=''  
init\_connect='SET NAMES utf8'  
\# Don't listen on a TCP/IP port at all. This can be a security enhancement,  
\# if all processes that need to connect to mysqld run on the same host.  
\# All interaction with mysqld must be made via Unix sockets or named pipes.  
\# Note that using this option without enabling named pipes on Windows  
\# (via the "enable-named-pipe" option) will render mysqld useless!  
\#  
\#skip-networking

\# Replication Master Server (default)  
\# binary logging is required for replication  
log-bin=mysql-bin

\# binary logging format - mixed recommended  
binlog\_format=mixed

\# required unique id between 1 and 2^32 - 1  
\# defaults to 1 if master-host is not set  
\# but will not function as a master if omitted  
server-id = 1

\# Replication Slave (comment out master section to use this)  
\#  
\# To configure this host as a replication slave, you can choose between  
\# two methods :  
\#  
\# 1) Use the CHANGE MASTER TO command (fully described in our manual) -  
\# the syntax is:  
\#  
\# CHANGE MASTER TO MASTER\_HOST=<host>, MASTER\_PORT=<port>,  
\# MASTER\_USER=<user>, MASTER\_PASSWORD=<password> ;  
\#  
\# where you replace <host>, <user>, <password> by quoted strings and  
\# <port> by the master's port number (3306 by default).  
\#  
\# Example:  
\#  
\# CHANGE MASTER TO MASTER\_HOST='125.564.12.1', MASTER\_PORT=3306,  
\# MASTER\_USER='joe', MASTER\_PASSWORD='secret';  
\#  
\# OR  
\#  
\# 2) Set the variables below. However, in case you choose this method, then  
\# start replication for the first time (even unsuccessfully, for example  
\# if you mistyped the password in master-password and the slave fails to  
\# connect), the slave will create a master.info file, and any later  
\# change in this file to the variables' values below will be ignored and  
\# overridden by the content of the master.info file, unless you shutdown  
\# the slave server, delete master.info and restart the slaver server.  
\# For that reason, you may want to leave the lines below untouched  
\# (commented) and instead use CHANGE MASTER TO (see above)  
\#  
\# required unique id between 2 and 2^32 - 1  
\# (and different from the master)  
\# defaults to 2 if master-host is set  
\# but will not function as a slave if omitted  
\#server-id = 2  
\#  
\# The replication master for this slave - required  
\#master-host = <hostname>  
\#  
\# The username the slave will use for authentication when connecting  
\# to the master - required  
\#master-user = <username>  
\#  
\# The password the slave will authenticate with when connecting to  
\# the master - required  
\#master-password = <password>  
\#  
\# The port the master is listening on.  
\# optional - defaults to 3306  
\#master-port = <port>  
\#  
\# binary logging - not required for slaves, but recommended  
\#log-bin=mysql-bin

\# Uncomment the following if you are using InnoDB tables  
\#innodb\_data\_home\_dir = /usr/local/mysql/data  
\#innodb\_data\_file\_path = ibdata1:10M:autoextend  
\#innodb\_log\_group\_home\_dir = /usr/local/mysql/data  
\# You can set ..\_buffer\_pool\_size up to 50 - 80 %  
\# of RAM but beware of setting memory usage too high  
\#innodb\_buffer\_pool\_size = 16M  
\#innodb\_additional\_mem\_pool\_size = 2M  
\# Set ..\_log\_file\_size to 25 % of buffer pool size  
\#innodb\_log\_file\_size = 5M  
\#innodb\_log\_buffer\_size = 8M  
\#innodb\_flush\_log\_at\_trx\_commit = 1  
\#innodb\_lock\_wait\_timeout = 50

\[mysqldump\]  
quick  
max\_allowed\_packet = 16M

\[mysql\]  
no-auto-rehash  
\# Remove the next comment character if you are not familiar with SQL  
\#safe-updates  
default-character-set=utf8

\[myisamchk\]  
key\_buffer\_size = 20M  
sort\_buffer\_size = 20M  
read\_buffer = 2M  
write\_buffer = 2M

\[mysqlhotcopy\]  
interactive-timeout

最后wq保存

结束。

最后推荐一波iTerm，是比较好的终端使用工具，背景黑色，不多说，直接上图。

![SouthEast][]

[SouthEast]: /images/20220418/7da4789a01c641e3af4c97effbe7caf6.png