Mac下MySQL环境搭建的步骤详解


当前第2页 返回上一页

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

Would you like to setup VALIDATE PASSWORD component?

 

Press y|Y for Yes, any other key for No: Y   ## 回复y 需要密码8位以上,回复n 则不做限制

 

The password validation component is not available. Proceeding with the further steps without the component.

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    ## 是否移除匿名用户。考虑安全我选了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) : Y   ## 是否允许远程连mysql 的 root。我用做本地调试,不是远程服务器,所以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? (Press y|Y for Yes, any other key for No) : Y      ## 是否y了删除test数据库,我选了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      ## 选y, 重新加载权限列表

Success.

 

All done!

到此配置就结束了,下面我们启动 mysql 即可,记住以下命令:

1

2

3

4

$ mysql -u root -p   ## 登陆 mysql

$ brew services start mysql@5.7   ## 启动 mysql

$ brew services stop mysql@5.7   ## 停止 mysql

$ mysql.server start   ## 启动 mysql(无后台服务)

本篇文章到这里就已经全部结束了,更多其他精彩内容可以关注PHP中文网的MySQL视频教程栏目!

以上就是Mac下MySQL环境搭建的步骤详解的详细内容,更多文章请关注木庄网络博客

返回前面的内容

相关阅读 >>

mysql中关于连接(join)查询详解

数据库备份的两种方法是什么

细说mysql死锁与日志二三事

mysql全文索引实现简单版搜索引擎实例代码

navicat如何查看mysql的操作记录

oracle数据库中出现ora-12899错误怎么办

mysql 获取时间方式

mysql中查询json格式的字段实例详解

如何关闭或启动mysql服务?

mysq详细讲解如何解决库存并发问题

更多相关阅读请进入《macOS》频道 >>


数据库系统概念 第6版
书籍

数据库系统概念 第6版

机械工业出版社

本书主要讲述了数据模型、基于对象的数据库和XML、数据存储和查询、事务管理、体系结构等方面的内容。



打赏

取消

感谢您的支持,我会继续努力的!

扫码支持
扫码打赏,您说多少就多少

打开支付宝扫一扫,即可进行扫码打赏哦

分享从这里开始,精彩与您同在

评论

管理员已关闭评论功能...