北京建设招聘信息网站,揭阳网站制作维护,望城做网站,自己怎样创建网站在我的绝版Mac mini下安装了mysql 5.7版本#xff0c;实例中#xff0c;在通过load data 导入数据时发现表中的中文显示为 #xff1f;通过百度#xff0c;发现多个版本的解决方法#xff0c;将其中一个成功解决的方法贴上来#xff1a;大多方法都是这样#xff1a;需要…在我的绝版Mac mini下安装了mysql 5.7版本实例中在通过load data 导入数据时发现表中的中文显示为 通过百度发现多个版本的解决方法将其中一个成功解决的方法贴上来大多方法都是这样需要到/usr/local/mysql/support-files目录下将Mac上的mysql配置文件模板my-default.cnf拷贝到/etc下并重命名为my.cnf但是我的support-files目录下也不存在my.cnf文件所以只能在终端重新创建了打开终端输入cd /etcsudo vim my.cnf在vim模式下复制粘贴以下代码# Example MySQL config file for small systems.## This is for a system with little memory ( 64M) where MySQL is only used# from time to time and its important that the mysqld daemon# doesnt use much resources.## 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-setutf8#password your_passwordport 3306socket /tmp/mysql.sock# Here follows entries for some specific programs# The MySQL server[mysqld]default-storage-engineINNODBcharacter-set-serverutf8collation-serverutf8_general_ciport 3306socket /tmp/mysql.sockskip-external-lockingkey_buffer_size 16Kmax_allowed_packet 1Mtable_open_cache 4sort_buffer_size 64Kread_buffer_size 256Kread_rnd_buffer_size 256Knet_buffer_length 2Kthread_stack 128K# Dont listen on a TCP/IP port at all. This can be a security enhancement,# if all processes that need to connect to mysqld run on the same host.# All interaction with mysqld must be made via Unix sockets or named pipes.# Note that using this option without enabling named pipes on Windows# (using the enable-named-pipe option) will render mysqld useless!##skip-networkingserver-id 1# Uncomment the following if you want to log updates#log-binmysql-bin# binary logging format - mixed recommended#binlog_formatmixed# Causes updates to non-transactional engines using statement format to be# written directly to binary log. Before using this option make sure that# there are no dependencies between transactional and non-transactional# tables such as in the statement INSERT INTO t_myisam SELECT * FROM# t_innodb; otherwise, slaves may diverge from the master.#binlog_direct_non_transactional_updatesTRUE# Uncomment the following if you are using InnoDB tables#innodb_data_home_dir /usr/local/mysql/data#innodb_data_file_path ibdata1:10M:autoextend#innodb_log_group_home_dir /usr/local/mysql/data# You can set .._buffer_pool_size up to 50 - 80 %# of RAM but beware of setting memory usage too high#innodb_buffer_pool_size 16M#innodb_additional_mem_pool_size 2M# Set .._log_file_size to 25 % of buffer pool size#innodb_log_file_size 5M#innodb_log_buffer_size 8M#innodb_flush_log_at_trx_commit 1#innodb_lock_wait_timeout 50[mysqldump]quickmax_allowed_packet 16M[mysql]no-auto-rehash# Remove the next comment character if you are not familiar with SQL#safe-updates[myisamchk]key_buffer_size 8Msort_buffer_size 8M[mysqlhotcopy]interactive-timeout关键是在[mysqld]下的这几句default-storage-engineINNODBcharacter-set-serverutf8collation-serverutf8_general_ci粘贴完成检查首行是否漏掉了 #检查无误按 ESC退出编辑输入 :wq! 回车退出vim模式重启mysql即可
