mac(m1)配置my.cnf

今天开始学习了数据库，在安装MySQL之后启动一直报错，然后在网上找了很多解决方法，最后用以下方法解决
对于习惯了windows的小伙伴来说，直接去安装目录里边修改my.ini就可以，对于习惯了Linux的小伙伴来说，直接修改mysql默认的/etc/my.cnf配置文件就可以，可是Mac端MySQL是默认没有配置文件的，需要自己手动创建。
1.新建etc文件

一般要在 先在/usr/local下新建一个etc 文件，注意etc为配置文件需要以管理员的身份新建进入/usr/local目录下中，然后输入以下命令

1. sudo mkdir etc

复制代码

然后回车即可创建etc文件
2.新建my.cnf文件

然后进入etc目录下，输入以下命令

1. sudo vi my.cnf

复制代码

然后将以下代码全部复制进去即可

1. # Example MySQL config file for medium systems.  
2.   #  
3.   # This is for a system with little memory (32M - 64M) where MySQL plays  
4.   # an important part, or systems up to 128M where MySQL is used together with  
5.   # other programs (such as a web server)  
6.   #  
7.   # MySQL programs look for option files in a set of  
8.   # locations which depend on the deployment platform.  
9.   # You can copy this option file to one of those  
10.   # locations. For information about these locations, see:  
11.   # http://dev.mysql.com/doc/mysql/en/option-files.html  
12.   #  
13.   # In this file, you can use all long options that a program supports.  
14.   # If you want to know which options a program supports, run the program  
15.   # with the "--help" option.  
16.   # The following options will be passed to all MySQL clients  
17.   [client]
18.   default-character-set=utf8
19.   #password   = your_password  
20.   port        = 3306  
21.   socket      = /tmp/mysql.sock   
22.   # Here follows entries for some specific programs  
23.   # The MySQL server  
24.   [mysqld]
25.   character-set-server=utf8  
26.   init_connect='SET NAMES utf8'
27.   port        = 3306  
28.   socket      = /tmp/mysql.sock  
29.   skip-external-locking  
30.   key_buffer_size = 16M  
31.   max_allowed_packet = 1M  
32.   table_open_cache = 64  
33.   sort_buffer_size = 512K  
34.   net_buffer_length = 8K  
35.   read_buffer_size = 256K  
36.   read_rnd_buffer_size = 512K  
37.   myisam_sort_buffer_size = 8M  
38. # Don't listen on a TCP/IP port at all. This can be a security enhancement,  
39. # if all processes that need to connect to mysqld run on the same host.  
40. # All interaction with mysqld must be made via Unix sockets or named pipes.  
41. # Note that using this option without enabling named pipes on Windows  
42. # (via the "enable-named-pipe" option) will render mysqld useless!  
43. #   
44. #skip-networking  
46.   # Replication Master Server (default)  
47.   # binary logging is required for replication  
48.   log-bin=mysql-bin  
50.     # binary logging format - mixed recommended  
51.     binlog_format=mixed  
53.       # required unique id between 1 and 2^32 - 1  
54.       # defaults to 1 if master-host is not set  
55.       # but will not function as a master if omitted  
56.       server-id   = 1  
58.     # Replication Slave (comment out master section to use this)  
59.     #  
60.     # To configure this host as a replication slave, you can choose between  
61.     # two methods :  
62.     #  
63.     # 1) Use the CHANGE MASTER TO command (fully described in our manual) -  
64.     #    the syntax is:  
65.     #  
66.     #    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,  
67.     #    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;  
68.     #  
69.     #    where you replace <host>, <user>, <password> by quoted strings and  
70.     #    <port> by the master's port number (3306 by default).  
71.     #  
72.     #    Example:  
73.     #  
74.     #    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,  
75.     #    MASTER_USER='joe', MASTER_PASSWORD='secret';  
76.     #  
77.     # OR  
78.     #  
79.     # 2) Set the variables below. However, in case you choose this method, then  
80.     #    start replication for the first time (even unsuccessfully, for example  
81.     #    if you mistyped the password in master-password and the slave fails to  
82.     #    connect), the slave will create a master.info file, and any later  
83.     #    change in this file to the variables' values below will be ignored and  
84.     #    overridden by the content of the master.info file, unless you shutdown  
85.     #    the slave server, delete master.info and restart the slaver server.  
86.     #    For that reason, you may want to leave the lines below untouched  
87.     #    (commented) and instead use CHANGE MASTER TO (see above)  
88.     #  
89.     # required unique id between 2 and 2^32 - 1  
90.     # (and different from the master)  
91.     # defaults to 2 if master-host is set  
92.     # but will not function as a slave if omitted  
93.     #server-id       = 2  
94.     #  
95.     # The replication master for this slave - required  
96.     #master-host     =   <hostname>  
97.     #  
98.     # The username the slave will use for authentication when connecting  
99.     # to the master - required  
100.     #master-user     =   <username>  
101.     #  
102.     # The password the slave will authenticate with when connecting to  
103.     # the master - required  
104.     #master-password =   <password>  
105.     #  
106.     # The port the master is listening on.  
107.     # optional - defaults to 3306  
108.     #master-port     =  <port>  
109.     #  
110.     # binary logging - not required for slaves, but recommended  
111.     #log-bin=mysql-bin  
113.       # Uncomment the following if you are using InnoDB tables  
114.       #innodb_data_home_dir = /usr/local/mysql/data  
115.       #innodb_data_file_path = ibdata1:10M:autoextend  
116.       #innodb_log_group_home_dir = /usr/local/mysql/data  
117.       # You can set .._buffer_pool_size up to 50 - 80 %  
118.       # of RAM but beware of setting memory usage too high  
119.       #innodb_buffer_pool_size = 16M  
120.       #innodb_additional_mem_pool_size = 2M  
121.       # Set .._log_file_size to 25 % of buffer pool size  
122.       #innodb_log_file_size = 5M  
123.       #innodb_log_buffer_size = 8M  
124.       #innodb_flush_log_at_trx_commit = 1  
125.       #innodb_lock_wait_timeout = 50  
127.         [mysqldump]  
128.         quick  
129.         max_allowed_packet = 16M  
131.           [mysql]  
132.           no-auto-rehash  
133.           # Remove the next comment character if you are not familiar with SQL  
134.           #safe-updates  
135.           default-character-set=utf8   
137.         [myisamchk]  
138.         key_buffer_size = 20M  
139.         sort_buffer_size = 20M  
140.         read_buffer = 2M  
141.         write_buffer = 2M  
143.           [mysqlhotcopy]  
144.           interactive-timeout
145. ————————————————

复制代码

然后按esc并输入：wq保存即可
3.设置my.cnf文件的权限

执行下面代码，否则mysql并不会读取my.cnf这个配置文件，执行下面一行命令前查看自己当前的目录，我当前是在etc目录里面的

1. sudo chmod 664 my.cnf

复制代码

最后输入以下命令 即可启动MySQL

1. sudo /usr/local/mysql/support-files/mysql.server start

复制代码

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！