Mac brew install mysql

本文介绍了如何在Mac操作系统中使用brew命令来安装MySQL,包括启动数据库、初始化配置及完成配置向导的详细步骤。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

首先直接安装

brew install mysql

然后启动mysql

mysql.server start

最后初始化配置,启动配置向导

/usr/local/opt/mysql/bin/mysql_secure_installation

启动向导后完成如下操作:

Securing the MySQL server deployment.
Connecting to MySQL using a blank password.

VALIDATE PASSWORD PLUGIN can be used to 
test passwordsand 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: k 

//不采用密码安全检测

Please set the password for root here. 
//设置root密码

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 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? [Y/n] 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? [Y/n] Y 
//禁止远程登录
 ... Success!

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? [Y/n] 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? [Y/n] Y
//重新载入权限表
 ... Success!

All done!

完成配置


关闭mysql

mysql.server stop
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值