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表连接的执行流程详解

mysql的case方法使用好处是什么

在linux系统下启动 mysql数据库操作

浅谈mysql的事务隔离

常用的关系型数据库有哪些?

mysql判断字段是否为null

mysql中的join操作实例分享

mysql怎么查看表结构?

mysql case when怎么使用?

mysql中常用存储引擎有哪些?它们相互之间有什么区别?

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


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

数据库系统概念 第6版

机械工业出版社

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



打赏

取消

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

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

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

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

评论

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