mac mysql，my.conf全网安装与配置，一篇文章解决所有问题

最新推荐文章于 2023-05-23 11:39:48 发布

白云影中仙

最新推荐文章于 2023-05-23 11:39:48 发布

阅读量563

点赞数

文章标签： mysql 数据库 sql

本文链接：https://blog.csdn.net/qq_44847842/article/details/120086027

版权

本文详细介绍了如何在Mac上安装和配置MySQL，包括创建my.cnf文件、设置权限以及解决配置过程中遇到的问题，如错误7489237和SQL模式更改导致的启动失败等。提供了一个全面的my.cnf配置文件，确保避免常见错误，确保MySQL顺利启动。

摘要由CSDN通过智能技术生成

mysql安装与配置

去官网下载安装之后

打开终端

sudo vim /etc/my.cnf

mac是没有cnf文件的， vim会自动创建然后在里面添加

# 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_passw